Query Result Snapshots

  • Good morning. Looking for some advice as to the best way to snapshot results from a query? In this particular case, I am looking to snapshot inventory.

    Thanks for any suggestions. I realize that this is very general.

  • Big vague.

    Can you elaborate more on the problem in hand?

  • 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]

  • Thanks for the responses. I'm unsure what got into me..? I will use SSIS as I always do. Thanks

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply