Import View from another SQL Server, using date range
Posted on 2006-04-27
I have another SQL server I wish to import data from. The other server's database has a view I would like to import, but I would like to limit this import to specific dates or date ranges. This is something I am going to put into a bigger stored procedure using variables so that a web app can call the procedure, pass the date range and run the process. What is the best way to accomplish this?
I know I can import the whole view but it has a lot more data then I need and would really slow the process down.