Halcyon (5/20/2010)

---

hi Team,

Please see below:

set nocount on

go

begin try

begin transaction

declare @counter int

set @counter = 0

;with remove_table as

(

select row_number() over (order by table_name asc) as id, table_schema + '.' + table_name...

Jeff Moden (5/19/2010)

---

I'm not sure why you need 3 digits for days since a month can't have more than 31 days in a month, but here's my humble take on...

Okay, how about this. Tried on your 2 dates and looks okayis to me. The MS i think is due to DateTime datatype.

DECLARE @LastUpdated datetime

DECLARE @Today datetime

DECLARE @Years int

DECLARE @Months...

You are in each case returning the total difference between @LastUpdated and @Today. So in the last ur getting ALOT of numbers and then trying to convert that to varchar(4)....

Even though i actually got this right the wording of the question aint that good. And that could be part of the reason why the correct/incorrect ration is out off...

To show my total noobness... what does the category "SSC" stand for?

Doh... of course "Sql Server Central"... its to early.