That was my guess. Would certainly explain why our help didn't work. 😛

rbond 51820 (1/17/2012)

---

I've verified that both the fields I am trying to "concatenate" are string data......I've also discovered that the + operator does not work for these but the ||...

Ideally that type of formatting should be done in the front end. What you have as desired output is really tough because you want to turn 3 rows of data...

The point Lowell was making is that unless you are cross referencing real time the spid is inaccurate at best. They get recycled so a spid of 42 might belong...

Ahh I see where you are going. I wish I knew where that info was stored. You are probably correct that it is in the registry somewhere...

Phil take a look at Wayne's post on page 1 of this thread. http://www.sqlservercentral.com/Forums/Topic1004880-2739-1.aspx He explains how the color can be set from two locations depending on how you connect....

As pointed out this type of structure can be painful to deal with. If possible normalizing this into another table is preferred. That of course is not always an option....

Hugo Kornelis (1/17/2012)

---

A good question, and it's hard to see how anbody could contest the correct answer.

Although in the spirit of nitpicking, I could argue that the format one should...

I don't think there is a better way but I have seen a lot of ways that are a lot worse. 😀

You have a few things not quite right.

The questions table does not (and should not have) a reference to department. The question belongs to a survey and the survery belongs...

Roy Ernest (1/16/2012)

---

Change of topic... I got my second part of my Audit series published here... Yay..!!!!

And I got a A+ review for the year 2011 from my CTO. So...

Lynn Pettis (1/13/2012)

---

Jeff Moden (1/13/2012)

---

Sean Lange (1/13/2012)

---

Jeff Moden (1/13/2012)

---

Sean Lange (1/13/2012)

---

I have to say this whole situation has left me feeling extremely reluctant to post on just about anything for...

SQL Kiwi (1/14/2012)

---

As Sean says, FILESTREAM is an option, as is storing just the path in SQL Server and keeping the images themselves in the file system. Storing images...

Jeff Moden (1/13/2012)

---

Sean Lange (1/13/2012)

---

I have to say this whole situation has left me feeling extremely reluctant to post on just about anything for fear that I come across as...

I would avoid anything other than date or datetime for storing dates. Storing this type of data in any other datatypes will cause nothing but headaches down the road. It...