Glad we could help, and thanks for the feedback.

😎

No offense taken, just restating why everyone who did answer should not be penalized for answering the QotD. I will admit I answered #2, and it returned the correct...

Actually, if you need to move the record from Table1 to Table2 on delete, you would use a trigger that fired ON DELETE to move the record.

😎

Since all provided answers were actually wrong (even though #2 seemed to provide a more accurate answer than #1 or #3), noone should lose any points for attempting to answer...

So, based on all the comments so far, does everyone agree we all should get our 2 points?

Perhaps a poll should be setup.

😎

So, when does...

Actually, somewhere on this site I found a similiar (yet different) problem. The solution recommended was adding this:

127.0.0.1crl.microsoft.com

to the hosts file on the server.

I asked our network services people...

I hope this can help you get started on a solution to your current issue:

create table dbo.TeamEffectiveDate (

EffectiveDateId int identity(1,1),

StaffId int,

...

If it ain't broke, don't fix it, else throw more hardware instead of fixing the underlying problem. Seems like how most management approaches problems like this.

All we can do...

It would help us help you if you would provide us with the DDL (create statements) for the tables, some sample data (in the form of unioned insert statements), and...

Not a problem. I find myself having to check MS licensing on a regular basis to be sure we stay legal (to the best of my knowledge at least).

😎

Adam Bean (3/6/2008)

---

Cory Ellingson (3/6/2008)

---

The biggest issue I had was with linked servers from the 64bit to 32 bit SQL servers. I had to run an update on all...

Actually, I just read the EULA for SQL Server 2005 Standard Edition, and you can install multiple instances on the same computer. I think that was a change from...

Here is some code that works:

declare @DateOfBirth datetime

set @DateOfBirth = '1959-08-29 09:59:00.000'

select datediff(yy, @DateOfBirth, getdate()) - case when dateadd(yy,datediff(yy, @DateOfBirth, getdate()), @DateOfBirth) > getdate() then 1 else 0 end

set @DateOfBirth...

I want my point back too....

Here is the code as run with results:

declare @DateOfBirth datetime

set @DateOfBirth = '1959-08-29 09:59:00.000'

select DATEDIFF(yy, @DateOfBirth, GETDATE()) union all

select FLOOR(CONVERT(decimal(9, 2), DATEDIFF(d, @DateOfBirth, GETDATE())) /...