Viewing 15 posts - 25,126 through 25,140 (of 26,487 total)
Cursors may be evil, but they are sometimes a necessary evil. I have seen where a cursor based solution out performed a set based solution. Having learned more...
March 10, 2008 at 8:37 am
Jeff Moden (3/7/2008)
I'll throw in that just from a code consistency standpoint, WHERE IN should be rewritten to a normal INNER JOIN like Lynn wrote it.
Thanks, Jeff. You should...
March 7, 2008 at 1:14 pm
The subquery is identifying the CategoryID for the specified CategoryName, 'Beverages', so that the main query only returns products for that specified category.
Another way to write that query is as...
March 7, 2008 at 12:56 pm
Licensing! Actually, if using Server 2003 R2 Enterprise Edition and Virtual Server 2005 you can have up to 4 virtual servers using the same license as the physical server....
March 7, 2008 at 12:30 pm
Geez, Matt, I wish I'd thought of using VM's! That is a perfect use of VM technology! Three cheers and virtual pint for Matt!
:w00t:
😎
March 7, 2008 at 12:09 pm
I'm with Matt, BAD IDEA. It may be better to build test procedures and scripts that will emulate the move to the future for testing purposes. Probably a...
March 7, 2008 at 12:00 pm
Phillip Cox (3/7/2008)
This sounds like an issue with the Connection Manager resolution at runtime, maybe due to memory pressure or a timeout issue with OLEDB provider, as the connections are...
March 7, 2008 at 10:03 am
Murphy learns to delegate, getting you to do his work for him giving him more free time to do what he does best!
😎
March 7, 2008 at 9:56 am
But it is counted as points attempted, and therefore affects your % correct. If all the answers are wrong, we shouldn't get penalized for selecting a wrong answer.
😎
March 7, 2008 at 9:15 am
Depends on why you wear two watches. Soccer refs wear two watches out on the field (I do).
😎
March 7, 2008 at 8:37 am
Here is the problem you are faced with, trying to open an application that needs to interact with a desktop where you don't have a desktop to interact with.
The path...
March 7, 2008 at 8:30 am
Been having a similiar issue with SSIS, see this thread:
http://www.sqlservercentral.com/Forums/Topic455318-148-1.aspx
March 7, 2008 at 8:16 am
Hear Hear! Well said Brandie!
😎
March 7, 2008 at 8:12 am
Definately another way to do it. Haven't used it myself yet, but should look at when needed.
😎
March 7, 2008 at 7:54 am
Viewing 15 posts - 25,126 through 25,140 (of 26,487 total)