nevermind I posted on the wrong one sorry

This is really a SQL Server question, but I don't think you can use the BETWEEN like that on a parameter.

-PatP

Will it compile? If not, you're guaranteed to have some issues. (It won't by the way.)

You have some syntax issues.

1. The parameter thing.
2. You seem to really like commas a LOT.
3. I'm probably missing something obvious here, but your date logic doesn't make sense.
4. You need to take a serious look at that last INSERT and ask yourself if you should be writing SQL. It's kind of like driving a car. You usually want to drive around in a parking lot for awhile before jumping on the race track without a helmet.