Use the COALESCE function.

John

You don't need to use a Script Task. A (relatively) simple UPDATE statement will do the trick. I haven't tested this, so you may need to tweak it:

WITH...

What version of SQL Server are you using? Please will you post a sample of data from your tbl_SI_Var_CS1 table?

John

Yes, or use GROUP BY and HAVING. Sounds suspiciously like an interview or homework question to me.

John

Use a CASE expression.

John

Is whatever application you are using to look at the files and folders set to show hidden and system folders?

John

I agree with Jason. But don't take our word for it. Try them both, and compare the execution plans.

John

You're right - you can't do it like that. Here's what I would do. It's from memory, so forgive me if the details aren't 100% accurate.

(1) Create a...

If Column1 is bit, it won't be an empty string. It'll either be 1 or 0 or NULL.

John

One alternative is to use the Execute SQL task instead to run sp_send_dbmail, which allows multiple attachments.

John

Having two nested WHILE loops is likely to be a performance killer. See if you can rewrite them into a set-based operation. As Bhuvnesh mentions, please post table...

The your first statement should start IF NOT EXISTS, should it not? In any case, please post the results of the following query:

SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME LIKE '#temp%'

John

The error is occurring in the stored procedure itself. Do you get the same error if you run just the EXEC line?

John

What application are you using to do the inserts? What happens if you run the same insert statements from Management Studio?

John

Brilliant - learned something else! Perhaps I should have used the word "gracefully"? Anyway, I've edited my first post by striking out the word "cleanly".

John