I find it to work without the defaults on the params... are they absolutely necessary, or just for so other odd occurances?

HTH.

use the dts transfer objects wizard, or the import option (right click, db).

Try merging them into a single field when doing the transfer in a datetime field, it should work... or transfer them separatly and merge them afterwards.

without a date attached to it?

not quite... changing to varchar just makes the transfer work.. you still should use datetime if possible, that's why I wanted to know about the range of dates.

try importing as a varchar() field.

Also what are the biggest and smallest dates in that table?

is the column varchar or datetime??

if it's over 0 it's an error, else it's ok. You show the users what you want 'em to see.

Do you have a date linked to that time??

dbo = god >> no restriction, not even checks for restrictions.

check the return value (almost last line of code). If it's 0 it worked, then you can do response.redirect (.url????) and send 'em to another page.

only 5800 seconds left 'till weekend .

#tmpTBL is a temp table

@tmpTBL is a table variable (who doesn't accept indexes anyways besides the clustered PK).

I think the first step should

exec dbo.GotoWeekEnd

followed by

exec dbo.ResumeNightSleep

with

exec dbo.TakeAbeer

somewhere in between