gsr
09/01/2022, 6:54 PMdelete from dbo.errors
where
CASE
WHEN @typeofcolumn='e' THEN 'errorid' = @bugid ELSE NULL END
CASE
WHEN @typeofcolumn='b' THEN 'bugid' = @bugid ELSE NULL END
return;
trying to use in the procedureMyka Forrest
09/01/2022, 7:34 PMcfvonner
09/01/2022, 7:35 PMMyka Forrest
09/01/2022, 7:36 PMWhere (@typecolumn = 'e' AND errorID = @bugID) OR (@typeColumn = 'b' AND bugID = @bugID)
Brian
09/02/2022, 2:45 PMGeorge Meng
09/05/2022, 10:31 PMcwigginton
10/02/2022, 7:20 PMCASE
WHEN @typeofcolummn in ('e','b') THEN 'error' = @bugid
ELSE NULL
END;