Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Proofdada Bewarse Legend Username: Proofdada Post Number: 134571 Registered: 03-2004 Posted From: 72.54.157.179 Rating: N/A Votes: 0 Posted on Monday, March 17, 2014 - 5:42 pm:    select store.StoreName,(select st.StoreName from dim.Store st,mart.TradeToSale mt where mt.CurrentStoreKey = st.StoreKey) from mart.TradeToSale mar, dim.Store store where CONVERT(DATE,mar.TradeDate) in('2014-01-01','2014-01-10') and mar.CurrentStoreKey = store.ParentStoreKey; idhi workout ayyidha... Narsiah fans Ramu,Gali...