Hello

I have attached sample data in a csv formats and the three table structures as a text file, i hope this works.

this is the query i used:

SELECT Returns.ReturnDate,...

Hello

I want to use query 2 and 3 join together to return an accurate result set

What will i have to write to extract records that are not blank?

Thanks

Your a star!!!

1-placed an order over a certain amount -(all orders)

2-requested for an order over a certain amount to be delivered to a different address,-( all orders for new customers over 90...

Any customer who registered within the last 30 days

Thanks Gail

Was able to attache it as a zip file

Not able to attached execution query plans, file type not permitted

the execution plan is graphical, how will i be able to send that to you?

When you say table structure, do you mean the create table query?

And if i would like to find out orders placed by the a customer within a 7 day period will i use:

DATEDIFF(dd,T_OrderHeader.OrderDate,GETDATE()) BETWEEN 1 AND 7)

I got the right result, my mind was going towards an inequlity or something syntax to be needed - Thanks

I want know the last time a customer placed an order in addtion to the information required

Yeah, got one question for you though, what are the best and easily comprehensible books out there to understand T-SQL development?

Fixed, incorrect placement of syntax, eventually used:

WHEN 'REFUND' THEN - CAST (Amount AS MONEY)