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...

Do you have to store the images in the database? If you are not familiar with it FILESTREAM may be a better alternative. Take a look at BOL here. Depending...

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 "one of those", or...