Viewing 15 posts - 2,596 through 2,610 (of 7,636 total)
Yes, there are ways to do it, but they are a lot of work and they perform very poorly. In general if you need to dynamically specify the columns...
May 8, 2009 at 12:25 am
Lynn Pettis (5/7/2009)
May 7, 2009 at 11:41 pm
Looks OK to me.
Also, this is pretty straight-forward, I doubt that there is anyway to speed this up.
May 7, 2009 at 11:33 pm
As for how he keeps his job, there are two obvious possibilities: 1) Civil Service, and 2) Nepotism. These two work pretty much the same, to one degree or...
May 7, 2009 at 11:12 pm
Actually, I think that his reply to me makes the whole graduate studies thing pretty clear: its complete hooey. Numerical Analysis is not like Psych 101. You can't...
May 7, 2009 at 11:06 pm
Lynn Pettis (5/6/2009)
I'm also curious how...
May 7, 2009 at 10:35 pm
What's your hardware architecture? Do you have a SAN?
May 7, 2009 at 10:18 pm
Well SQL Injection is the biggie. Wish I had a buck every time one of my customers found out that their vendor was exposing them to SQL Injection attacks.
May 7, 2009 at 10:13 pm
Dude. This code post is really big and is causing the page to hang for me (and others, I presume)
Could you edit your post and move the code into...
May 7, 2009 at 9:49 pm
SELECT *
INTO NewTable
From yourTable
Will create a new table with all of the column definitions taken from the '*'. On the other hand it will not work if...
May 7, 2009 at 8:45 pm
Dean Jones (5/7/2009)
true talk herebut sometimes, the Query can look long winded and kind of long, and hence the reason why its been put into a temp table.
That's not a...
May 7, 2009 at 5:48 pm
FYI, the larger the string to be made, and the more strings to be concated, the better FOR XML does wrt to all other workable solutions in SQL 2005. ...
May 7, 2009 at 4:37 pm
Static SQL stored procedures are compiled and bound to the objects in the same database, unless another DB is explicitly named in an object reference. You cannot parametize a...
May 7, 2009 at 4:26 pm
Saving it as XML should make it a *.SQLPLAN. Then you will have to zip that.
May 7, 2009 at 4:16 pm
Viewing 15 posts - 2,596 through 2,610 (of 7,636 total)