Dear Jeff

Thank you for your reply. I will look at this link as it does seem to be what I need.

Thanks again for your help

Dear Phil

Thanks for yur reply, I have put the result in an excel spreadsheet so hopefully it be more clearer. Sorry about not doing it properly.

Hello...

Dear Steve

Thank you for your reply. Apologies for the mistakes. As I mentioned I am very new to this am will try to get this right.

I have included the changed...

Dear Steve

I have made changed the records and below are sample results from each tables in my script:

Sale_Basket:

Basket_idDay_Uid_TRADESite_Code_PHYSICALCustomerLoyaltyNumberIsTradeIsVoidBasketPriceTOTAL

223066019201610202722123456781062.95

223066020201610202120234567891041.95

22306602420161020D15311223521101000.95

22306602520161020D1521234567810480.95

2230660262016102028125246514710130.95

2230660272016102022271247898710271

2230660352016102028121234567810270.5

22306603720161020D1231451234610152.95

22306603920161020D124164532151087.95

22306604320161020D125138521451080.95

Rewards_SpendActivity:

Basket_idRwdMember_id

2230660246666666

2230660272345678

2230660371111111

1555487988888888

999999996666666

888888881111111

777777779999999

666666663827370

2230660393827370

2230660435555555

map_SiteBusinessManager

Site_CodeAreaName_BM

2120Mens GF

D125Mens LG

D152Womens

D125Womens

D124Sport

D123mens GF

D125mens LG

D126mens LG

2190Sports

2215Menswear GF

Sale_Line

Basket_idLine_idSite_Code_POSTINGArticle_Code_POSTINGDay_Uid_TRADELinePriceIncVATIsVoidIsTrade

223066037186667668D1251232016102012900

155548798191555490D1231452016102010900

9999999919156109822151652016102019.9500

88888888191561099D4471462016102014.9500

777777771915611722190123201610202000

10078922719156117321901452016102054.500

777777771915660572120167201610202.9100

1007911191915660582215168201610203.900

100791119191566059D123196201610201.200

1007911191915660602215196201610202.200

dim_Site

Site_CodeChannel_Code

2212 ...

Dear Steve

thanks for the reply. Can oyu please advise if you would like me to send you a line of result for ech table is this what you would...

Dear Steve

Thank you so much for the time you spending on this.

I have tried your suggestion and do not get any results back. Is the second select statement should be...

I just tried this and below is my whole query now:

ITH VALID_CUSTOMERS AS (

SELECT DISTINCT BK.CustomerLoyaltyNumber , rs.RwdMember_id, bk.Day_Uid_TRADE

FROM HUDS.dbo.SALE_Basket AS BK

INNER JOIN HUDS_Analytics.dbo.map_SiteBusinessManager AS GSM

ON GSM.Site_Code = ...

Thank you so much for your help. Apologies for duplicating the thread, I just thought it be easier to start a fresh one and explain things a bit better, I...

Thanks you so much for all your helps . This works great now. I really appreciate your time

Hi Again

Unfortunately this wasn't fixed as I only get the result for Mens where I need a different outcome as per my message to Luis. Its nearly there but no...

Dear Steve

In Huds.Sale Basket each record show the amount spent per total transaction for each customer , along with their customer number (if they are a member of the reward...

Dear Luis, Steve

I tried the code and it work. The only thing is it only returns Mens sales, I need to see where-else they shopped. So if Customer a shopped...

Can I also say thank you for everyone who has contributed to this. I am very grateful for all your times and sorry for not following the corrcet procedures, I...

Dear Steve, Tom

Thanks for the reply , some of the answers are below

I am using SQL Server Management Studio 20912 and only have read access to the tables

Toms questions

I...