Proofdada
Bewarse Legend Username: Proofdada
Post Number: 134576 Registered: 03-2004 Posted From: 72.54.157.179
Rating: N/A Votes: 0 | Posted on Monday, March 17, 2014 - 5:54 pm: | |
select (select st.StoreName from dim.Store st1, mart.TradeToSale mt1 where m1t.CurrentStoreKey = st1.ParentStoreKey)as ParentName,(select st.StoreName from dim.Store st, mart.TradeToSale mt where mt.CurrentStoreKey = st.StoreKey) as companyName from mart.TradeToSale mar, dim.Store store where CONVERT(DATE,mar.TradeDate) in('2014-01-01','2014-01-10'); Narsiah fans Ramu,Gali...
|