Post reply

Query Result Snapshots

  • October 28, 2015 at 7:28 am

    #399236

    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.

  • October 28, 2015 at 7:37 am

    #1836041

    Big vague.

    Can you elaborate more on the problem in hand?

  • October 28, 2015 at 7:48 am

    #1836050

    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]

  • October 28, 2015 at 8:12 am

    #1836058

    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 3 (of 3 total)

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