I have add a snap shot of the PS_ORD_HOLD_AUDIT for one customer that shows my trouble. My report is to pull all customer that have been CRD_APPR(credit approved) and the...

But to use a have you need to be aggregating something and I am not?

is this correct?

I have about 4000 rows of values to insert that are in a word doc that I will cut and paste into my sql statement but I do not want...

is there away to mark the rows with the table name that is different?

Is there a wild card to use for the cust_table name. something like cust_% ?

SELECT * HMDEV.dbo.cust_table

except

SELECT * HMTST.dbo.cust_table

Thank you that works perfect.

I have 3 sql servers DEV, TEST, Production I would like to compare about fifty customer tables between TEST and Production. I just want to see what the difference...

I'm sorry I have removed the order_no from group by on my live Query and I thought that I had completely removed it from my test database but as you...

I don't have order in the tsql that where I get lost

see attachments for the output

Thanks for you help