vinodand
asked on
append data into t-sql cursor
i wanted select * from table1 where id=1 to retrieve the data two times - ie the single row should get duplicated and appended below the result returned from above query.
eg. select a,b,c from table1where id-1 should return data like below
a b c
xys abc def
xys abc def
can someone help?
thanks in advance
eg. select a,b,c from table1where id-1 should return data like below
a b c
xys abc def
xys abc def
can someone help?
thanks in advance
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window