Keep in mind that 2005 introduced into the SQL Native client the ability to have encrypted communications between client and server (simply go into the connection OPtions screen before connecting...

Steve Jones - Editor (3/26/2009)

Here, here....

In the spirit of teaching you how to fish - here is a great article on conatenation options:

http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

Similary - here's the CLR sample aggregate I was mentioning:

http://msdn.microsoft.com/en-us/library/ms131056.aspx

Keep in mind as well that conceptually, higher normalization = greater flexibility and lower normalization = less flexibility. So as part of your redesign you need to consider (specifically...

You want to look up custom AGGREGATE functions in 2005's BOL. The CLR sample provided is a concatenation function.

In order to use a function in the PIVOT, it needs...

In case you don't know which link to go check out - here's Jeff Moden's "tips and tricks" article on various creative ways yo use a Tally table:

http://www.sqlservercentral.com/articles/TSQL/62867/%5B/url%5D

The last example...

Sounds to me that you might want to investigate the conditional split options whic may give you the flexibility you need. In other words - split the process into...

Then Alvin is on the right track - you're not looking for a UNION statement at all.

A "UNION" essentially combines the rows from each query into a single query. ...

Is there a specific question? I suspect you're getting a truncation error, but it would be nice to know what the question actually is....

Don't NAME it "identity" - MAKE it an identity column. If you're using the UI - look in the properties of the column (identity specification section).

Try this instead then. The 0x001a refers to an ASCII code, represented in binary, so - convert it to INT first, then convert it to a character.

CONVERT(varchar(max),(SELECT Replace(Replace(TIUDocumentReportText,char(CAST(0x0020 as...

The documentation is correct - just very hard to read. Lynn - the [,...n] you saw is under the ADD and DROP sections, and not the ALTER.

That being said...

Try using NVarchar instead. I suspect you will get better results.

Unless I completely misread what you're asking for - there IS no need to use a cursor. You do have to acucmulate the "values you want to pass...

Generically - break this into 2 parts:

1. write the SELECT statement that does the PIVOT correctly.

2. once 1. outputs correctly - wrap the statement from one into a derived...