I have to agree with Mike here. A little more information is needed...Like what is the code column for as that information might be critical to the manner in...

A left join should work here to acheive your goal. Here is a great article about joins:[/url] by Walter Crivelini

In short a left join will return all of the...

Thanks for the clarification Sean. I incorrectly assumed by max the max 4000 was implied.

TonjaB

It should not degrade performance to any noticeable degree. However, not knowing your data or the volume of data I say that with no guarantee. The only thing...

The following script describes how to script dts packages to text files:

Script ALL DTS packages on server to text files

The below should take you straight the the article on this...

nvarchar(x) or nvarchar(max) the only difference to me is the difference between x value and the max value (which i think is 4000...someone please correct if I am mistaken). ...

Hey this is great but I cannot create the .pdf file in the C: drive...What could I possibly be doing wrong?

Great article. I my shop it is punishable by being forced to turn on an overhead light in your office if you use a cursor. I tebd to...