thanks Charles for the explanation...

I think Dense_Rank option answer should also be awarded points as it was not specified anywhere regarding this..

I select DENSE_RANK as it leaves no gaps in...

i dont think such type o question we need to post in this site.. :w00t:

i dont this is the correct forum to answer your question.. please post it into appropriate forum;-)

nice and tricy one...

thanks Hugo for the explanation

ohh its a nice and intresting thing to know...

learn something new today 🙂

i dont think this question is worth of 2 points..

explanation is also wrong..

GO is a batch seperator while semi-colon is a command seperator

good question but alas I got it wrong 😉

thanks....

easy one 😛

Jason, I have installed SSMS tool.

I followed your steps and it solved my problem..

thanks a lot 🙂

good one...

good basic question....

nice and easy question....:-)

is there any way to handle this scenario?

i am stuck into one more case..

if I dont have entry for procedure code '0062' and have rows for '0062A' and '0062B' then in this case how can I update...

I think A is correct, I dont knw why correct answer is D while it is not fully correct 😎