But its a nice clean bulldozer...  Anyway, I still like to play in the dirt... 

Thank you for your suggestions Boreades, but:  "Neaner, neaner, neaner... we won."   

(Albeit, that was a pretty good rant...) 

Vladan - yours WILL absolutely be faster!  Mine is far more a bulldozer approach.  I should probably change my screen name to bulldozer... 

Both CHAR(13) and CHAR(10) can cause this problem. 

I have a function along with a table that will prevent that information from getting into your database if you would like...

Actually, mine should work even if two orders were made on the same date, as long as your date field, (and the data passed into it) is smalldatetime or datetime. ...

This might be overkill, but here is another option.  If you take the -- out of the PRINT @sql line, you will see what is happening...  Like Vladan's, this will...

Well no, you don't HAVE to..., that is a wonderful choice we can make...  

(ooops..., is my Irish showing?)

I am shooting in the breeze here - you have a lot of table/fields with no data to populate. 

You are in fact using an INNER join outside the LEFT...

Is that "plain" as in boring, or "plain" as in understandable? 

If every entry is in this format try using SUBSTRING. 

ELECT SUBSTRING( '2005/07/13', 9, 2) + '/' + SUBSTRING( '2005/07/13', 6, 2) + '/' + SUBSTRING( '2005/07/13', 1, 4) 

Thanks for your help. 

This is driving me nuts.  When I first created it, I declared the Stored Procedure and the parameters were read by Reporting Services and already fulfilled. ...

Too young for COBOL????  Man, I had to learn it on the fly to try and document Business Rules for some past application stuff.  It is still around and working...

Remi was correct in interpretting my meaning.  I should have said three (3) prefixes instead of four; I erroneously counted the table name as a prefix.  Dopey me. 

COBOL is a "Business Language" (har har) that old dudes used. 

Actually, I was doing something along these lines on a linked server and ran into the same problem.  I too will be interested to know if there another way to...