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?

check the plan of the proc. When you use 123456, you'll probabely have a clustered index seek, but with 123456.00 you'll probabely have a clustered index scan. The...

Hehe, looks like I made a fan here... Feels weird .

Does it have to be in excel??

Cause this seem to be a really great task for any reporting tool out there.