I have been given, what is to me, a fairly substantial join query with the instructions of creating a new database and scheduling the updating the new database with the results from that query.
1. Can I just create a default database and let the query create the necessary tables on the first run and then let it update them in the future?
2. Being fairly new to performing complex (again, complex to me) T-SQL queries, what kind of language/syntax would I add to this join query to have it port it's results to another database on a different server?
The join query pulls from 6 tables on the source database.
Thanks for any help. Researching the specifics of doing this has led to varied results, and I'm hoping it's much simpler than it looks.