Thanks Mucho!!

I agree, excellent article Gail. I'll also be looking for the follow-up articles. -Carleton

I've been happily using the coalesce method for years. However, this link provided by Tom Winter has me converted to the XML method:

Coalesce is not the answer to string...

What I was able to discover is that the solution I was seeking wasn't available via SQL Server 2005. I ended up implementing user based security rather than the...

Very helpful, thanks.

Thanks Dave.

Does SQL 2008 SSIS play nicely with Excel 2007?

(sorry for hijacking this thread)

Excel 2007:

Row Limit: 1,048,576

Column Limit: 16,384

I've not played around with SSRS 2008, does anyone know if it uses Excel 2003 or 2007 row and column limits?

If you use user defined types (UDT), you must register the UDT in the tempdb before they will be available to your temp table.

Well there you have it then, a true example of teaming! So John, you and I can split the revenue for this solution.

We may be able to help, but I'm unable to see from your post what you would like help with. Could you please clarrify?

My appologies, I overlooked that you wanted records that were NOT a match. In this case adding the word NOT to my original script suggestion should work:

select * from...

In your case, the answer is not "it depends." As tmacs33 said, normalization is best for you. For databases with heavy INSERTS and UPDATES, normalization will yield the...

Here ya go:

UPDATE a SET a.title = a.[Name] + ' - ' + b.[Name]

FROM [MyTable] a

INNER JOIN [MyTable] b ON b.categoryid = a.ParentCategoryID

Job saving tip: make sure you test this...

I like arun.sas' suggestion. If you need to keep the code in the sproc, you could just add what arun.sas suggested to the top of the procedure thereby 1)...

This is a fast and dirty way of doing what you are asking for. However, this query won't win any speed contensts, so if you have a lot of...