Skip to content

Instantly share code, notes, and snippets.

@troyscott

troyscott/dbo.BcsSalesForecastReadList.sql

Created January 20, 2014 07:23
Show Gist options
  • Save troyscott/8516292 to your computer and use it in GitHub Desktop.
Save troyscott/8516292 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dbo.BcsSalesForecastReadList.sql
create procedure dbo.BcsSalesForecastReadList as set nocount on
select EnglishMonthName + '-' + WeekNumber + '-' + SalesTerritoryRegion + '-' + Category ID,
EnglishMonthName MonthName, WeekNumber, SalesTerritoryGroup SalesGroup,
SalesTerritoryRegion SalesRegion, Category ProductCategory, LastYearAmount,
ForecastAmount from dbo.WeeklySalesForecast
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment