Viewing 15 posts - 13,231 through 13,245 (of 15,381 total)
That was my guess. Would certainly explain why our help didn't work. 😛
January 17, 2012 at 12:54 pm
rbond 51820 (1/17/2012)
January 17, 2012 at 12:44 pm
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...
January 17, 2012 at 12:37 pm
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...
January 17, 2012 at 12:35 pm
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...
January 17, 2012 at 12:06 pm
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....
January 17, 2012 at 10:31 am
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....
January 17, 2012 at 8:10 am
Hugo Kornelis (1/17/2012)
Although in the spirit of nitpicking, I could argue that the format one should...
January 17, 2012 at 7:24 am
I don't think there is a better way but I have seen a lot of ways that are a lot worse. 😀
January 16, 2012 at 3:25 pm
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...
January 16, 2012 at 3:23 pm
Roy Ernest (1/16/2012)
And I got a A+ review for the year 2011 from my CTO. So...
January 16, 2012 at 3:10 pm
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)
January 16, 2012 at 3:10 pm
SQL Kiwi (1/14/2012)
January 14, 2012 at 6:27 am
Jeff Moden (1/13/2012)
Sean Lange (1/13/2012)
January 13, 2012 at 10:31 pm
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...
January 13, 2012 at 10:20 pm
Viewing 15 posts - 13,231 through 13,245 (of 15,381 total)