Hi SSC Rookie

Thanks for your reply.It worked for me.

Thanks a lot.

Hi Chris,

I just chaged the query like this and it worked for me.

SELECT id, value, id1, value1

FROM @t1 t1

CROSS JOIN (

SELECT TOP(SELECT TOP(1) [Rows] = COUNT(*) FROM @t2 GROUP BY...

Hi chris

seems that you are using 1,2,3,4,5 staticly.we dont know how may rows we get as described.i have just given u a sample data.

Thanks

Hi,

Thanks for your reply.

I want this Logic without using the Looping concept.

Thanks.