Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
from rows into columns
hi, does anybody know how to change a table with some values: row_A(1), row_A(2), row_A(3) into a table with values: column_A(1), column_B(2), column_C(3) with a stored procedure? Ex. column_A column_A | column_B | column_c row_A 1 1 2...- mikmak
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
concatenation
hi, I have a problem with my report format. I use stored procedure to generate a report from some templates, which contain many input variables (ex. A, B, C). The report should look like: A, B, and C. Currently, my condition is: CASE WHEN @A != '' THEN @A + ',' + SPACE(1) ELSE '' END+ CASE...- mikmak
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
