I need to count records from one table and insert that YTD total into a table that I am storing YTD summary totals.
Here is what I tried to do:
SELECT COUNT(members) as YTD_Members_CT FROM dbo.tblMembers
WHERE InputDate between '2011-10-01' and '2012-04-30'
Insert into dbo.YTDSummary (YTD_Members)
The dbo.tblMembers contains my daily information that I wish to count. I am trying to store the count of members for the time period in another table. I can get the count to appear on the screen with a column name "YTD_Members_CT" but how do I get that count to insert into the other table called dbo.YTDSummary