@ Jeff: Thanks 🙂

@ Allister: Yes, I read it. That article on Tally table is a real eye opener.

Thanks for the help guys

Hello Allister,

Thanks for the help. Your code shows how to think column wise rather than going row by row. I am getting a hang of it now. And you are...

Hello,

Below is a script that can be used to generate the sample tables and data:

use Test

--===== If the test table already exists, drop it

IF OBJECT_ID('TableA','U')...

@ Allister Reid: 🙂 nope. At present I dont have any plans of doing that. I'm gonna read a few articles by Jeff and others on RBAR and hopefully I...

Dear Allister Reid, bitbucket and Jeff Moden,

Thanks a lot for your invaluable suggestions and guidance. I have certainly been shown the right direction and I thank you all for that....

Hello Jeff,

You are the man. Everything is going in SPs and I am scheduling the scripts calling these SPs.

Thanks for the help.

On RBAR: I guess I have to go...