What do you by "snapshot results from a query"?
Do you want to save results?
You can extract it out by BCP or SSIS or you can save it in another dedicated table, or you can call your query from some client app and save results in whatever form you want.
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)
How to post your question to get the best and quick help[/url]