Ya let's hear more about that contest .

Who knows maybe, Oracle will work on sets and sqlserver like cursor??

Now that would be the end of the world .

I forgot to mention that you might want to truncate the time of the day for GetDate().

It would look something like this :

DATEADD(d,0,DATEDIFF(d,0, GetDate()))

Winiso can do that.... but I'm not sure it's impossible to burn an image of 750 mb.... I remember burning vcd of 800+ mb.

That would be something worth checking out.

Create table Activities

(

ActivityDate datetime (primary key clustered)

ActivityDescription varchar(100)

)

Then you can run this proc daily :

Delete from dbo.Activities where ActivityDate < DateAdd(M, -1, GetDate())

Is this simpler than your code?

Yup... but it's still one more tool in the box .

Like I said, but it's nice to know it's out there...

I don't know the yukon syntaxe... but basically it increments colid and reseeds to 1 everytime the id changes.

Maybe you could create a small app that connects with a special account that his in the db_ddladmin group, and that he could then call that proc (and only that...

check in the transfer options. I think you have a few options. You can either delete the data and reinsert, or append it... but I'm not sure what...

Thanx for sharing with us... too bad with can't be of more help.

Happy to hear we got through your programmers .

HTH.

What'S that supposed to mean Sharky??

menu_lvl2_id seems to be the primary key

menu_lvl2_item seems to be some book title or something like that.

I wouldn't expect him to want to update the whole table with the same...