Samuele E. Locatelli
25 lines
399 B
Transact-SQL
25 lines
399 B
Transact-SQL
|
|
/***************************************
|
|
* STORED stp_listValues_getDistTable
|
|
*
|
|
* ottiene elenco TableName
|
|
*
|
|
* Steamware, S.E.L.
|
|
* mod: 2015.02.25
|
|
*
|
|
****************************************/
|
|
create PROCEDURE [dbo].[stp_listValues_getDistTable]
|
|
|
|
AS
|
|
|
|
SELECT DISTINCT TableName
|
|
, '-' AS FieldName
|
|
, '-' AS value
|
|
, '-' AS label
|
|
, 0 AS ordinal
|
|
FROM ListValues
|
|
ORDER BY TableName
|
|
|
|
|
|
RETURN
|