yungmunk (3/2/2015)

---

Hello, I'm sorry to resurrect such an old post but I'm trying to do basically the same thing the original poster was. Your code looks very simple and...

charlesafarr (3/2/2015)

---

I reviewed the Cross Tab and Pivot queries you suggested. I went with Cross Tab, but i am getting this result now.

ID, Office, Office1, Office2

1,Testing, Testing, NULL

2,Hello World,...

This is pretty straight forward. You can use PIVOT or my preference is to use cross tabs. See the articles in my signature about cross tabs. If you know how...

Since your code has no formatting it is hard to tell for sure. The...

Awesome. Welcome home and glad you made it safely.

Well if you want some help we need ddl and sample data that we can use.

The syntax of the query you posted is never going to work. Not sure where you found that but it is not even in the ballpark.

You can however achieve what...

Here is the challenge. You posted sample ddl and sample data but they don't match up. The columns in the inserts don't exist in the table. There numerous broken string...

Here is the article about this topic. http://www.sqlservercentral.com/articles/comma+separated+list/71700/%5B/url%5D

Nope. But I would suggest not naming...

Having read the other location you posted looking for help I agree with Erland 10000%. You are concerned about performance but wanting to use a scalar function. Scalar functions are...

Safe travels. Talk to you in...

I knew the answer since this has been asked before. Much like the last time the "unlimited" response is sort of correct because nobody in their right mind would have...

Lynn and Luis, or anybody else interested.

http://teespring.com/soccerholic-hoodie?utm_campaign=soccerholic-hoodie&utm_medium=oembed&utm_source=wordpress

Time is short to be able to get this but there are other available.

One of their recent ones I missed was "I don't...

Speaking of funny shirts. Here is one that I just got in the mail. I know that Lynn will appreciate this one.