Joined: 25 Dec 2006 Posts: 63 Location: Perambalur
I guess what you are asking for is
a query to select values from one or more columns and
return it as one row, which i think is impossible.
For some reason, if you want this way
in your program to avoid the usage of cursor,
you can create a temporary table having one row with so many columns and (call a stored procedure) or (code sqls in your program) to update that temporary table with latest values. And then select it from that temporary table.