USP_SIMPLEDATALIST_SMARTQUERYCATALOG
Returns the list of the smart query catalog.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @RECORDTYPEID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_SMARTQUERYCATALOG
@RECORDTYPEID uniqueidentifier
as
select distinct SMARTQUERYCATALOG.ID as [VALUE],
SMARTQUERYCATALOG.NAME as [LABEL]
from dbo.SMARTQUERYCATALOG
--where RECORDTYPEID = @RECORDTYPEID