Friday, March 27, 2015

Assigning avg to columns and grouping that info by date

First, you need to remove those parameters, you're assigning values to them, and then just selecting them right afterwards. Since they can only hold a single value at a time, you'll never get more than one row.


Second, provide us some example data and DML, example:



DECLARE @table TABLE (accountID INT, accountstartDate DATE, tokensReceived INT)
INSERT INTO @table (accountID, accountstartDate, tokensReceived) VALUES
(1, '2015-01-01', 1),(1, '2015-02-01', 1),(1, '2015-03-01', 1)





Don't forget to mark helpful posts, and answers. It helps others to find relevant posts to the same question.


No comments:

Post a Comment