Here is a formula that appears to work okay in SQL Server:

datediff(yy, @dob, @calcDate) - case when (datepart(dy, @calcDate) < datepart(dy, @dob)) then 1 else 0...

I will add this to the issue at my previous employer: it was an inherited system (was supported by an outside company and brought internal) that was written entirely in...

If discounts have to be applied in a specific order, it does add to the complexity. Ten percent off of ten percent off, is not twenty percent off:

x =...

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...

Thanks, Jeff. You should...

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...

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....

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:

😎

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...

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...

Murphy learns to delegate, getting you to do his work for him giving him more free time to do what he does best!

😎

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.

😎

Depends on why you wear two watches. Soccer refs wear two watches out on the field (I do).

😎

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...

Been having a similiar issue with SSIS, see this thread:

http://www.sqlservercentral.com/Forums/Topic455318-148-1.aspx