I have a script that runs daily and acquires all AD user information and other data, dumping into a sql table.
I want to setup another script that, once a month, will dump that same data into a 'history' table, but populate the first column with the date of the dump.
Source table being [user id],[first name],[last name].
I want the destination table to be
[record date],[user id],[first name],[last name].
Is there an easy sql command I can use to accomplish this?
SQL 2k8 on a 2k8 server, using powershell.