muthyala_51 (11/21/2014)
I am not fully finished with the code and the schema i provided is not the same in our database, i have posted simplifying it. So can you please provide your input on the best solution how to achieve it. Thanks
Without something to work with I would stop looping and turn this into a set based update.
It sounds like you want to change the status_id to 0 when ANY of the subscriptions are not 'Y'?
pseudocode...
update yt
set status_id = case when Sub1 = ' Y' and Sub2 = 'Y' and Sub3 = 'Y' then 1 else 0 end
from YourTable yt
join ....
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/