Skip to content

Instantly share code, notes, and snippets.

@kristinaconley

kristinaconley/Calculate Data into Table Variable

Last active December 17, 2015 20:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kristinaconley/5667772 to your computer and use it in GitHub Desktop.
Save kristinaconley/5667772 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Calculate Data into Table Variable
BEGIN
INSERT INTO @Projected (timeframe, Successes, Contacts)
(SELECT
P.timeframe
,SUM(Successes) AS 'Successes'
,SUM(Contacts) AS 'Contact'
FROM CalculatedData C
RIGHT JOIN @Projected P ON (P.timeframe = datediff(dd,AddedDate,GETDATE()))
GROUP BY p.timeframe, datediff(dd,AddedDate,GETDATE())
)
END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment