Worked like a charm. Learnt some new things today.

Thanks everyone!

Thanks, this worked fine for what I was trying to do. I appreciate it.

For my own further knowledge though, what if the data was mixed with some strings like...

No significance. Just wanted to make it vary.

There could be more than three fruits. Very curious to see why you asked that.

The first solution worked correctly. Thank you guys for both solutions.

Thanks for your response. I think you have done more than enough to help me understand set based sql more clearly.

Good point, I have been testing a lot. One last question regarding this, what if it was an update operation in the loop,

will it be as simple as just...

I have to say, that was a pretty slow moment on my path. You are right, I was still thinking loop instead of set. Thanks again

Any other solutions will be...

Thanks for the response,

To answer your question, Not really. The loop version returns the result set returns 4 rows, 2 for each accountid.

Accountid,RID,date,users

11,10,2013-10-31 17:21:27.203,John

11,50,2013-10-31 17:21:27.203,John

15,10,2013-10-31 17:21:27.203,John

15,50,2013-10-31 17:21:27.203,John

This is...

Thanks Paul, you have been very helpful as always.

False alarm never mind. Sorry about that and thanks for all the help guys !!!

i :-D, I also thought for a minute that there were 1905 records on the table but that was not the case. There are 3 tables that I am putting...

Hey guys, i noticed that the query gave me some 1905 dates?? Is there a reason why?

Thanks for the help guys!

I just love how guys on this website are willing to help others. Gsquared is obviously a very advanced sql guru but takes the time and patience to answer even...