Good question, although not that hard (for 2 points).
erajendar (5/13/2010)
It is very interesting. However, am still not clear on [flag ='y' ]. Can someone tell me what is this flag. I didnt get any content in BOL.
The flag isn't actually there. Since it is contained in brackets, it is just an alias name for the table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP