Hello,

The client sandbox SQL database is at another site than my development machine.

I know how to run the view and see the result in SSMS, but I actually want to have data on my development machine so I can trace through the code to ensure all is well.

How do I run the view and get that data result back to my development machine?

Thanks,

TFISHER



>>Hello,
>>
>>I am writing an import utility that will ultimately query another company's SQL database so that information already typed into that other company's database does not have to be retyped into my software.
>>
>>The other company has written a read only view and installed it in a common client's sandbox SQL database.
>>
>>How do I run the SQL View and have it export data in a format that I can import into a table on my development machine so that I can test the import utility?
>>
>>I would like to get several records from the view and put them in a table on my development machine so that I can test to ensure everything that I am getting in the view will work properly during the import.
>>
>>Thanks,
>>
>>TFISHER
>
>Assuming you have an access to the view, you just need
>
>select * from myView -- using the right database
>
>to get the information.