Viewing 15 posts - 601 through 615 (of 851 total)
[font="Verdana"]I guess the thing that worries me is the thought that "so long as I'm not using a cursor, it's okay." It's not the cursor that is the problem,...
February 18, 2009 at 12:05 pm
[font="Verdana"]You know, there was a time when the overhead required to compile/translate SQL was significant. Unless you are running your database on an ancient server, I think you should...
February 18, 2009 at 11:59 am
[font="Verdana"]Can you give us some sort of idea as to which records are missing that you expect to see in the list?[/font]
February 18, 2009 at 11:56 am
Bob Hovious (2/17/2009)
I've been trying to search for CORRUGATED subqueries !!!! :w00t:
[font="Verdana"]Look in SQL Server Books Online under "nail gun".[/font]
February 17, 2009 at 6:33 pm
Jeff Moden (2/17/2009)
February 17, 2009 at 6:19 pm
[font="Verdana"]A friend of mine wrote a book on why IT projects fail. One of the points he made (which I remember vividly) was that there are different levels or...
February 17, 2009 at 2:55 pm
[font="Verdana"]Could be worse. Could be elephants.[/font]
February 17, 2009 at 2:50 pm
GilaMonster (2/17/2009)
<Sigh> Why don't people read the manuals?
[font="Verdana"]So we have an excuse to say "RTFM"?[/font]
February 17, 2009 at 1:59 pm
[font="Verdana"]That can work. The issue there is around propogating address changes. If a customer changes their address for one product, should it change for all? Also, disc...
February 17, 2009 at 1:57 pm
[font="Verdana"]I think using a WHERE clause is probably the right approach. You have one commented out. Did that not do what you want?[/font]
February 17, 2009 at 1:38 pm
[font="Verdana"]Please, not the "mine's bigger than yours" thing. :P[/font]
February 17, 2009 at 1:37 pm
[font="Verdana"]As I'm sure you have realised, the answer is "no". 🙁 You can capture the result sets, but not the console output.[/font]
February 17, 2009 at 1:30 pm
[font="Verdana"]You won't be able to do this with an identity field, as it generates a unique number for every row. You will need to manually generate the numbers. ...
February 17, 2009 at 1:10 pm
nabeelmukhtar (2/17/2009)
February 17, 2009 at 1:02 pm
[font="Verdana"]Setting up a VM (the first time) should take a little more time than setting up a physical server from the point of view that you have to set up...
February 17, 2009 at 12:38 pm
Viewing 15 posts - 601 through 615 (of 851 total)