As I don't truly make any adjustments to the model, the important one to me is the msdb containing all the scripts for jobs. For me, the important one of...

I see Hugo's point. You cannot take into account leap years and other such anomalies when you are creating a calculation using months. Months are unreliable in a...

Hugo,

Not sure what you mean but I took the date you implied (37 years and 9 months ago) and ran the routine and came up with 37 and 3/4 years...

I like the fact that Rick used the CTE. Interesting approach Rick

Jamie

Rick,

I don't know how to search the posts and there are too many to find yours. Can you repost?

Jamie

Hugo,

http://www.sizes.com/time/cal_gregorian.htm

Try changing the Int to Round. Note that the calculation takes into account the factors you mentioned. I just put this one out there (with int...

I think it may work if the int function is changed to round. I took this from VB code which does work. I confused the cint function in...

Without extensively testing - I haven't checked whether int or round is the correct function below; however, at the very least, the two functions below will give you the correct...

The second answer is clearly the "best" answer. The third one is incorrect and the first one is clearly not the best. A better answer might have been...

The second answer is clearly the best answer. The third one is incorrect and the first one is clearly not the best. A better answer might have been...

I don't know if I'd agree with you about living under a rock. The question was worded poorly. Windows Server 2008, SQL Server 2008, and VS NET 2008...

Ryerson has a cool picture of breadth first vs depth first traversal

http://www.ryerson.ca/~dgrimsha/courses/cps721/images/nBreadthFirst.gif

http://www.ryerson.ca/~dgrimsha/courses/cps721/nDepth.html

IS the breadth-first command available in SQL 2005?

with recursive itemlist(atitem,piece,qty,cost) AS

(select item_id,planning_item,1,0)

from titems

where item_id='AT1000000'

UNION ALL

SELECT item_id,piece,qty,qty*cost

From vInventory,tItems

where...

Microsoft is reknowned for their big events. What happened this time?

http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.programming/2004-10/3361.html

http://www.sqlservercentral.com/Forums/Topic435501-8-2.aspx

Whew... got that one wrong! This explains why there were issues on SQL 2000 when moving over to 2005 IDE.

Does the IDE for SQLMgr pick up the...