Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
SELECT Markets.[IRI Market], Varieties.Variety, SUM(MarketShare.[POS Qty] * Varieties.Weight) AS WMTlbs, SUM(MarketShare.[POS Sales]) AS WMTDollars, SUM(CognosData.Dollars) AS IRIDollars, SUM(CognosData.Pounds) AS IRIlbs, FROM MarketShare INNER JOIN Markets ON MarketShare.[Zip Code] = Markets.[Zip Code] INNER JOIN CognosMonths ON MarketShare.[WM Week] = CognosMonths.[Walmart Weeks] INNER JOIN Qualifier ON MarketShare.[Store Nbr] = Qualifier.Stores INNER JOIN Varieties ON MarketShare.[Item Nbr] = Varieties.[Item No] INNER JOIN CognosData ON Markets.[IRI Market] = CognosData.Market WHERE (Qualifier.Qualifier = N'Yes') AND (Varieties.Variety = N'Red') AND (CognosData.Variety = N'Red') AND (CognosData.Year = N'2009') GROUP BY Varieties.Variety, Markets.[IRI Market], CognosData.Market, CognosData.Variety, CognosData.Year ORDER BY Markets.[IRI Market]
|MS SQL 2005 Srink database in chunks||4||49|
|How to place a condition in a filter criteria in t-sql (#2)?||10||41|
|Read a Table and add those records into a existing parameter that was send from a SSRS report||11||49|
|Help with SQL - TOP 10 by date and by group||13||33|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!