http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

This looks a lot like the classic "catch all" query. Take a look at this article about this type of thing. It will likely perform a lot better than either...

Hugo Kornelis (4/6/2012)

---

Sean Lange (4/6/2012)

---

Basically you can simulate a foreign key via triggers but it is NOT actually a foreign key. In that case it is more of a business...

OK so we have sample data and desired output but I don't understand what the output represents. Can you explain what you are trying to do here?

Jack Corbett (4/6/2012)

---

Hugo Kornelis (4/6/2012)

---

I flipped a coin and ended up lucky. Two answers can both be considered correct.

No, a foreign key constraint can not be created across...

Sivag you seem to be missing three items from your question.

1) ddl

2) sample data

3) desired output based on your sample data

Basically that means at this point you...

A linked server functions as the login that is used to establish the linked server. That means that it has whatever permissions are granted to the user or role that...

You're welcome. Thanks for letting us know that worked for you.

capn.hector (4/5/2012)

---

Sean Lange (4/5/2012)

---

Eugene Elutin (4/5/2012)

---

Is...

Unless the product list is going to exceed 8,000 characters there is no need to use CLR for this. The code I provided is a delimited list with no CLR...

Hi and welcome to SSC. In order for anybody to begin being able to help you, you first have to help us. You have not provided anywhere near enough information.

Take...

With 600+ points surely you know you should provide ddl and sample data. Please do at least that much next time.

Try this.

declare @tbl table (

...

Take a look at the link in my signature. It is super fast.

Since you know it is ALWAYS there the post Lowell shared above should work just fine. You may have to tweak it slightly to get exactly what you want.

You could use either the server name of the IP address.