Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  combine SELECT results into a text variable

Author  Topic  costint Starting Member 5 Posts Posted - 2001-05-29 : 14:18:24 I'm trying to use an SQL statement to create an html string, where it throws in all my variables in the right places. When I execute this, I get several rows. I can concatenate them into a variable by using SELECT @myvar = @myvar + 'text...', but that only goes up to 8000 characters, since SQL Server 7 doesn't allow me to define text variables as local variables. The ultimate goal, is to take my text string and store it in a column in one of my tables. So, does anyone have any suggestions on how to do this? Any help would be really appreciated. Thanks.