We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
spGetCars set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER proc [dbo].[spGetCars] ( @uid varchar(30) ) as set nocount on DECLARE @ufilter varchar(200) DECLARE @uexpdate datetime DECLARE @cmd varchar(200) select @ufilter=ufilter, @uexpdate=uexpdate from UFILTERS where uid=@uid IF ISNULL(@ufilter, 'ZZTOP') = 'ZZTOP' BEGIN select * from Cars where 1 = 2 END IF @ufilter = 'NONE' BEGIN select * from Cars order by Make, Model END ELSE BEGIN set @cmd = 'select * from Cars where ' + @ufilter exec (@cmd) END
Join the community of 500,000 technology professionals and ask your questions.