Hello sql expert,
I have a query that output to a excel sheet daily and instead outputting to excel, I want to store those daily result set to a table without truncate the table. The purpose what I am trying to do is to keep those daily result set (historical)
Here is my simple sql query:
Select Column1, column2, datefield
Where datefield = convert(date,getdate())
so, this query will run daily and I want to load the result set to this below table;
the question, if I load today result set, can I keep today's result set for tomorrow load and so on?