Great question - was not aware of that issue with SQL variables at all. Leanred something very important this morning!:cool:

Great - Thanks 🙂

Some really good advice here. Very glad I started this thread 🙂

Henrico Bekker (4/12/2012)

I've done it as well... "how do you detach a Log Shipped tempdb that is in Read...

Ha! Made me laugh - sometimes it does feel like that! Thanks for the reply....:cool:

Hi all - Thanks so much for taking the time to reply - been very helpfl. Ive been playing around with Antares686's solution today and it works like a charm!

I did actually work some logic into the code and it is OK

SELECT CASE

WHEN wff.ID = 1 THEN

...

Hey Burninator - thaks for taking the time to reply to me - I was able to incorporate the logic of your query into my existing code to get the...

Hey - Thanks for the heads up - I have now masked that contact value....

All Ok - used <br/><br/> and worked OK 🙂

Hi,

I have implemented this solution and it works great sending emils with PDF attachment but I can't seem to get the email body to include the new line character.

Here is...

Thanks for the helpful replies - been reading the online preview of The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset on...

Hi GilaMonster,

OK - i read your article, took the advise and changed my query replacing the COALESE and using Dynamic SQL instead.

My query, which returns 60830 rows went from an...

Found this article which looks good to me:

http://www.sqlteam.com/article/implementing-a-dynamic-where-clause

Using COALESCE certainly looks a lot neater.....

Spent 30 mins on this one but still got incorrect answer due to issue with answers but still an excellent question - ANSI PADDING was something I never really spent...