Viewing post 1 (of 2 total)
Try the below:
CREATE PROCEDURE Test
@statusID int = 0
AS
DECLARE @select as nvarchar(100)
DECLARE @where as nvarchar(100)
SET @select = 'select * from tblStatus'
IF @statusid > 0
SET @Where = '...
September 2, 2005 at 7:48 am
#587195