title: Save summary count data
body: <p>I have a SQL Server table with a large amount of data.</p>
  
  <p>All my data changes every 3 hours. So I want to make these variables update when my data changes.</p>
  
  <pre><code>Person
  (
      "Name" VARCHAR(50) NOT NULL,
      "Address" VARCHAR(150) NOT NULL,
      "Jobs" VARCHAR(50) NOT NULL,
      "Date_of_subscription" DATE
  )
  </code></pre>
  
  <p>I want to provide the count of people that subscribed the last week, the count of people that subscribed the last month, and the count of people that subscribed the last 3 months to my web app.</p>
  
  <p>Is there anyway I can save the count of my selection in a variable in my SQL Server database to avoid the waiting time. And serve the counting values to the web app without making my app counting each selection.</p>
  
  <p>Can a SQL Server stored procedure help me?</p>
  
  <p>I'm preparing a project for my graduation. I'm developing an ASP.NET web app and using the asp data gridview. I'm using SQL Server 2019.</p>
  
  <p>My application is a dashboard.</p>