Samuele E. Locatelli
27 lines
601 B
Transact-SQL
27 lines
601 B
Transact-SQL
|
|
-- =============================================
|
|
-- STORED stp_getValidValuesFilt
|
|
--
|
|
-- Author: S.E.L.
|
|
-- Create date: 2011.05.26
|
|
-- Description: gestione selezione dati parametrici
|
|
-- con filtro su valore con LIKE
|
|
-- =============================================
|
|
create PROCEDURE [dbo].[stp_listValues_getValidValuesFilt]
|
|
(
|
|
@TableName NVARCHAR(50),
|
|
@FieldName NVARCHAR(50),
|
|
@valueLike NVARCHAR(10)
|
|
)
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
SELECT value, label
|
|
FROM ListValues
|
|
WHERE TableName = @TableName
|
|
AND FieldName = @FieldName
|
|
AND value LIKE @valueLike +'%'
|
|
ORDER BY ordinal
|
|
END
|