USP_SIMPLEDATALIST_EXISTLOCALCORP
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STATEABBREV | nvarchar(2) | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_EXISTLOCALCORP
(
@STATEABBREV nvarchar(2) = null
)
as
select TOP 1
CITY as VALUE,
CITY as LABEL
FROM dbo.LOCALCORP(nolock)
where STATEABBREV = isnull(@STATEABBREV, STATEABBREV) and ISACTIVE=1 and LOCALCORP<>''
order by CITY;