ALTER PROCEDURE [dbo].[RPT_GetCrimeCategory]
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select LKSCOMPLAINTSOURCE.LookupID, LKSCOMPLAINTSOURCE.Description from dbo.Lookup LKSCOMPLAINTSOURCE WITH(NOLOCK)where LKSCOMPLAINTSOURCE.LookupCategory = 126
union
select 0, 'Select'
END
No comments:
Post a Comment