This is what something i want:

* Safe place */

GO

SET NOCOUNT ON;

/* Table variable for the sample data

If the flag values are only 0 or 1

...

Hey,

thank you very much. It does work.. But I have to repeat this scenario for 3 flags.. So I have to define CTE all three times.

Do we have any...

Hi,

thank you for your reply.

We do not have permission to do that.. so I have to find an alternative way to do this.

I am planning to create a hashkey...

Hi,

Thank you for the reply.. The Error I was getting earlier seems to have solved. But now I am getting below Errors.

Error: The buffer manager cannot extend the file "C:\Users\}.tmp"...