You've received what you wanted, but here's some additional help. 😉

In the future, review the DDL and sample data that you post. You posted the same table twice and missed...

Thank you for your responses. 🙂

I understand the part of devs telling them how to do their work. On another server, where we have the permission, I've found a lot...

Could I get your opinions on this issue?

http://www.sqlservercentral.com/Forums/Topic1576705-391-1.aspx

If there's no WHERE clause, then those are CROSS JOINS producing cartesian products. Without join conditions, that will only return a lot of bad information.

Kill the one that wrote that...

You should really stop believing in myths. Group by and Distinct are designed for different cases. When you're grouping use group by and when you want to eliminate duplicates use...

Can you explain further? maybe with examples.

An insert will insert rows, not columns. You might have a valid request but I'm confused.

Read the following article to find out how to do it.

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

I...

The best option would be to change the column to nvarchar(max).

The other option is to cast/convert your column during the query to nvarchar(max).

Instead of throw, you could use a simple condition.;-)

DECLARE @ErrorMessage NVARCHAR(4000) ,

@ErrorMessageShort NVARCHAR(4000) ,

@ErrorNumber...

Ed Wagner (5/30/2014)

---

I also have the Proper Case thread saved in my briefcase because it's good. Luis, great approach. BTW, I still have your Start With...Connect By solution...

lorrin.ferdinand (5/30/2014)

---

Hi,

There are other ways to skin the cat, depending on whether performance is an issue. Using some kind of a an actual table, CTE, or derived table...

Sean Lange (5/30/2014)

---

KoldCoffee (5/30/2014)

---

Yes, I know about what you're talking about. I was lucky to once have a great manager tell me what an awesome job I did after...

And be aware that if you have batch separators (GO) the variables will go out of scope.

Let's say that there's an app where you can select multiple items to generate a report. The web developer chooses to send a string as 'Item1,Item3,Item7' (which could be integers,...