Viewing 15 posts - 12,196 through 12,210 (of 15,381 total)
Such is the complication of IT people everywhere. "Normal" people think about what software could/should do and have concept of programming. The challenge is to take incredibly vague and often...
April 27, 2012 at 2:28 pm
opc.three (4/27/2012)
Sean Lange (4/27/2012)
opc.three (4/27/2012)
Lynn Pettis (4/27/2012)
opc.three (4/27/2012)
...on second thought...comment removed...Dang, had three minutes to see what you said and I missed it. 😛
Yeah...for once I need to stop...
April 27, 2012 at 2:22 pm
I particularly liked his last comment.
i am putting it in if condition,does that is the problem?
I know exactly where the problem is...that big blob right between the keyboard and...
April 27, 2012 at 2:18 pm
opc.three (4/27/2012)
Lynn Pettis (4/27/2012)
opc.three (4/27/2012)
...on second thought...comment removed...Dang, had three minutes to see what you said and I missed it. 😛
Yeah...for once I need to stop violating my rule...
April 27, 2012 at 2:06 pm
This post, http://www.sqlservercentral.com/Forums/FindPost1291791.aspx is when it is nice to show stupid amounts of patience. It seems this person is finally starting to realize the importance of posting ddl and sample...
April 27, 2012 at 1:58 pm
njdevils39 (4/27/2012)
Sean Lange (4/27/2012)
April 27, 2012 at 1:56 pm
This looks excellent!!! I do have a question about your proc. It looks like you want to have this proc return data for 1 employee? If we used employee #3...
April 27, 2012 at 1:41 pm
I seriously doubt you need a loop for this. Take a look at the first link in my signature for best practices on posting questions. After you post ddl, sample...
April 27, 2012 at 12:25 pm
LOL I honestly didn't really look very closely. The OP said they wanted to see if they could do it without sys.syscolumns. I simply used the version ChrisM wrote and...
April 27, 2012 at 12:21 pm
I have worked with a few EAV systems in the past and I can tell you from my experience I would run away from this as fast as possible. It...
April 27, 2012 at 9:43 am
With this type of schema you have create a 1:1 relationship from Person to Address. You did not gain any of the advantages of normalization with this. You will 1...
April 27, 2012 at 9:14 am
That is kind of nasty. You first have to split your string, then you have a dynamic cross tab.
This really should be done in the front end. If there is...
April 27, 2012 at 9:03 am
If you are using .NET the application side of this is trivial. Just bind a datagrid to your datasource and it will generate the columns dynamically.
The sql side of this...
April 27, 2012 at 8:59 am
What is wrong with the answer you got in your other thread?
April 27, 2012 at 8:55 am
Please don't cross post. It just fragments responses. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1291608-1292-1.aspx
April 27, 2012 at 8:54 am
Viewing 15 posts - 12,196 through 12,210 (of 15,381 total)