I have a table in the below format ,

Create TABLE tab1

(

UniqueID VARCHAR(3),

ID ...

Let me explain my requirement in detail.

I have a table A with 20 rows. I need to supply the data for my down stream system in a format of...

Yes , thank you for the reply.

Iam dividing the whole query to 20 different iterations and executing like below.

SET nocount on

declare @rownum int

declare @iteration int = 20

select...