Hence the best practice of having everything owned by dbo (or at least the same user).

Thanx for pointing that out Chris.

I'd go farther in that statement, make a function that returns the computed column. So you can reuse the logic somewhere else.

But if you want more help, I defenitly suggest...

How long would it take to modify the application?

Also why r u using decimal(10,0)?

Can't you use a bigint, or int instead? It would propabely solve the problem and also allow...

I know what a textarea is . I haven't coded in html for a while but I remeber the basics

Can't you simply the query from the vb componant?

Select * from dbo.Contracts where DateContrat >=dateadd(D, 0, datediff(D, 0, GetDate())) and < dateadd(D, 1, datediff(D, 0, GetDate()))

Is this solution working for you or I still need to knock it out?

DTS will append all the data, or truncate/reinsert all.

I like the control of the insert statement.

if EXISTS (Select * from GenNum where So = @Seroff)...

In order for it to be created, the table has to go in tempdb. The notion of created in memory comes from the fact that very small tables will...

Don't worry Farrell, I'm sure my version won't work .

Always another way .

Can you post what you have... will be faster to correct that than to find a vbs version.

Not sure of what you're talking about. Can I see some code?

Where's the rest of the post AJ?