It can be done.  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=220954 

Please don't cross post.   

To get you back up to the head of the queue, I will respond. 

I have no idea! 

But that is a great question as I try CHECKPOINT in our...

Ahoy matey!  Are you doing it?   

I am rather surprised by this response.  I worked for a company that did account reconciliation and if I ever told my boss that the data came in bad and...

OMG!  I just had an image of Marland Brando in "Last Tango in Paris"...   

(I'm sure that was not your meaning..., but lack...

At least not a third time.... 

(lighten up.., I was only kidding...  bully   ) 

I want to know if Adam would hire me if I brought my DVD's of the Muppets First Season into the interview.   ...

I am guessing that "datetostr" is a UDF.  If so, can you give us the code?

Thanks

Scroll down for answer...

Scroll up for answer...

Please don't cross post: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=220556 

People look at many forums. 

Thanks

Please don't cross post: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=220550 

People look at many forums. 

Thanks

I added Invoice.Amount so you could see it was getting what you were hoping for:

DECLARE @Customer TABLE( [Ac Ref] varchar(5),

                                               Company varchar(10),

                                               Address varchar(10),

                                               Town varchar(10),...

"Aye", "I", "Ar".  The pirate's alphabet....

Try Adrienne's.  That works.   

  Like I said, I wasn't born stupid...  I have to work at this!!!! 

I am too involved in something else and wasn't...