The way this question is asked it would be 11 hours, but I do get the confusion: that's what happens when British people try to Americanize the question, LOL. 17:05pm...

• This reply was modified 1 year, 7 months ago by  Aleksandr Furman.

Email had "Select @sql" on the site it said "EXEC (@SQL). In first case you get 2 statements concatenated into one, in second case you get 2 separate...

How about this: You like the job you currently have but even though you liked your original salary after 3 years of 2.5 - 3% raises you now feel that...

WOW! 10% got it right. Congrats! LOL

I usually first create an HTML document using some WYSIWYG (what you see is what you get) tool apply all the formatting I want through the interface and then look...

I've never had a problem with any of the email clients. Simple HTML is recognized by all of them.

This subject is very dear to my heart - I had to do so many projects that send emails to customers. One thing I always do is create HTML templates...

That's not exactly...

skyline666 (8/26/2008)

---

Nope, its this:

SELECT...

"Format C:\ COMPLETE" Takes me back to DOS days pranks. Nowadays we just add couple of zeros to the end of daily sales numbers. 😛

Simon Facer (5/27/2008)

---

The REPLICATE('-', 8000) has an implicit cast to NVARCHAR, try this to explicitly CAST it to NVARCHAR(MAX):

declare @C nvarchar(max)

set @C = N'hello' + CAST(replicate('-',8000)...

About size of nvarchar(max)

I tried this:

declare @C nvarchar(max)

set @C = N'hello' + replicate('-',8000)

print len(@c)

the result was still 4000. Can someone explain why it wasn't more since...

Another alternative to drag-and-drop is click on word Columns then Ctrl+C to copy then in query window position your coursor where it should go and Ctrl+V to paste. This way...

That reminds me of an old joke:

What’s the difference between mechanical engineer and computer geek?

Mechanical engineer thinks Kilobyte is 1000 bytes.

And computer geek thinks kilometer is 1024 meters. 😀