It most certainly can be converted into a set based query (maybe using the divide'n'conquer approach).

We'd need table def and sample data for all tables involved in a ready to...

Please provide table def and sample data in a ready to use format as described in the first link in my signature together with your expected result.

I'm confident there's a...

subrata.bauri-1051938 (5/29/2011)

---

I have a Temporary Table which has no of records (Rows) Now I want to go these Temp Table thru row by row. Is it Possible in SQL ...

Here's a rather meaningless example of an unpivoted table based on your equally vague original table def. As you may notice, there are no rows with NULL values allowed. This...

First a thought on your current strategy in general:

If you store your hourly trans dumps on the same server, do you mean you're using the same physical drive(s) as used...

Why not using a unpivoted versiion of the table and store the type of date in a separate column instead of adding a column per type? I there's a need...

Did you try to email it as an attached html file?

It seems like it's an issue with the embedded html data of sp_send_dbmail.

At least we exluded the query being a...

I'm curious what business case you're trying to implement.

Would you please provide more details? What is the purpose of the trigger?

At a first glance it sounds like a "semi-optimal" table...

I copied your result into a html file and it looked just fine. Based on the data I cannot verify the result you see.

What do you use to view the...

Please remove the xml sample since it obviously contains personal information (you crrectly obfuscated it in your original screenshot).

I don't think it's the output of the original statement except the...

Replace

Select SubGroupType from dbo.subgroup

with

Select ISNULL(SubGroupType,0) from dbo.subgroup

I hope it's a rather small database and performance is not important...

T oanswer your original question: use ISNULL(NAME2,'0').

Please note that you should use consistent data types (not an integer to replace a varchar value).

But the much more important issue you should...

set identity_insert <tablename> on basically means you're providing the identity value within your INSERT statement (making sure there are no duplicate or NULL values).

With set identity_insert <tablename> off you don't...

I've seen the html tag before. No reason to repost it. 😉

I don't think you had "the same" output with and without the html tag...

My question was: what is the...

check sys.sql_expression_dependencies.

Also, Aaron Bertrands blog is a good reference.