I am having trouble with how to write this in SQL - in a stored procedure .
ALso Output table should look like this :
Output Table should produce this :
Request ID Status
001 C
002 NULL
003 C
004 NULL
Please...
I have a table which contains many records for a RequestID ,
Each request has a BookingID .
Aim : to write a stored procedure and create an output table
which contains a RequestID and Status ( If any request has a Status of ‘C’ then Status
overrides any other status other status is whatever is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.