Post reply

Union on two views into a table

  • May 18, 2011 at 9:09 am

    #239762

    I have two views that I have created. The first view is used by the second view as criteria. What I want to do is combine the two views into a table that will allow me to summarize in Excel.

    I am not sure that what I want to do can be done.

  • May 18, 2011 at 9:18 am

    #1326553

    Is it a 1 off export? Or something that needs to be done regularly?

  • May 18, 2011 at 9:49 am

    #1326588

    I would like to do this for the next month or so, but if I have to recreate on a 1 off basis I will.

  • May 18, 2011 at 10:00 am

    #1326597

    I would presonnally make a procedure on the server. Add a button to excel and simply code the dataset call there along with the presentation. It gives you a little more power than plain exporting with sql server.

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

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