True. I was just adapting the solution to what he already posted.

@emailBODY = 'first

<br /><br /><br />

second

<br /><br /><br />

third'

<br /><br />

Was JayK's solution. Did it not work for you?

I don't know about the OP, but I would like to see a set-based solution based on the criteria the OP gave.

I have really nothing of significance to add. But I'd like to say "thank you" for going through this problem for everyone to see. The thought process, going through the...

sidenote: That was very Yoda-like 🙂

That's interesting. I would have never thought of using Excel for code or code generation (outside of VBA)....

By any chance, have you written Parts 2 - 4? Good article by the way.

Yep.

cgrammont (5/4/2011)

---

Version control for application code (VB, CSharp, etc) I know. But version control for SQL, not really sure how to approach it, much less what to use for it....

I guess not many people version control their SQL....

VisualHg works with VS 2008 but not SSMS 2005 🙁

I'm not sure why but SQL Server doesn't think that's a legitmate GUID.

This works:

declare @aTest uniqueidentifier

set @aTest = 'B85E62C3-DC56-40C0-852A-49F759AC68FB'

select @aTest

But this doesn't:

declare @aTest uniqueidentifier

set @aTest = '56YB32BA-BEB2-4066-B0FC-BB7691E6ED38'

select @aTest

Are you making an update to this script for SSRS 2008 Standard?