Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: SQL server stored procedure help
05-18-2010, 03:54 PM #1
- Join Date
- Apr 2009
- Thanked 0 Times in 0 Posts
SQL server stored procedure help
I have a table named earned_trans with three columns [msisdn],[claim_date], [claim_type]
Please help me to write the query for this(bascially a stored procedure)
So here i have to get the claim_date using msisdn
select claim_date, claim_type where msisdn='1233'
and with this
if claim_date == null
then set result = "absent"
elseif claim_date != null
then if(claim_type == "bank")
then set result = "bank"
elseif(claim_type == "claim")
then set result = "claim"
Please help me to write this query