IF EXISTS (Select * from dbo.SysObjects where name = 'Numbers' and XType = 'U' and user_name(uid) = 'dbo')

DROP TABLE Numbers

GO

CREATE TABLE dbo.Numbers (PkNumber int identity(1,1) primary key clustered, dude bit...

Not really an sql server problem but...

SET cmd = new adodb.command

Why are you using 364 as a constant?? Shouldn't that be DATEADD(D, -1, dateadd(YY, 1, Date))?

On more thing to consider. Let's say you want to go back to the record's state of 2 years ago. How hard would it be if you only...

You can also alter the relation and make it ON UPDATE CASCADE which wil propagate the changes to the child table(s).

SHOW ME the results, there's no logical link I can see with the info you gave me.

Help us help you

One audit table per table... Easier to keep the structure in sync and the audit script is a breeze to write.

This ain't ever gonna work... what is the expected output you want from the update?

That's the only read I had to reread it... QQ was pretty easy to remember .

I really don't recommend that method. It will run a scan update for EACH COLUMN instead of once for the table. Try that on 5 M rows and...

What, they can edit the report but they can't run and alter proc???

You're the lucky one... I stopped counting after I ran out of hands and feet in my whole office building .

Dude run my code, learn something and stop asking for free points.

Why can't you simply Select the data in the correct order and use the application to generate the ranking (extremely simple while you display the data)??

Didn't major in english and I never will...