Are you perhaps using a date format that SQL doesn't like? I have great difficulties dealing with US dates vs EU dates. to save hassle I always use dates in...

WTH??

I just copied the code into notepad, canceled the stored proc window, reopenned it and pasted the code back from notepad and it worked??

oh well.

Thanks for looking.

Ben

I've just run your code and it works perfectly...

Heres my (slghtly abridged) code:

  DECLARE @copycommand AS nvarchar(255)

  DECLARE @transdate AS DATETIME

  DECLARE @transdate2 AS CHAR(8)

  DECLARE @dtschecker AS int

 SELECT...