Forum Discussion
CASE Statement
I am a SQL novice. Our SQL expert is unavailable and I need to make some small changes to a stored procedure, any help would be appreciated. So I have a stored procedure that pulls the data into ...
You can use a case statement in Pay column something like that
case when (se <1 or ty =3 or yr =0 or st ='OUT')
then 0 else py
end