|
-
Mar 22nd, 2002, 12:01 PM
#1
Thread Starter
Hyperactive Member
Loop Thru Columns
In SQL Server 7 is there a way to Loop Thru every column?
The reason for doing this.
There are like 57 columns. They each hold Dollar values. Sometimes the Dollar values are extended to 4 decimal places and we don't want that.
Is there a way to loop thru the columns and apply the fix within query analyzer? No VB just SQL. Like maybe a column index you can loop thru or something?
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|