Post reply

Is there a replacement or workaround for COMPUTE clause in SQL Srever 2014 ?

  • June 24, 2015 at 8:33 am

    #309395

    I have some scripts written in 2008 where I have COMPUTE clause, and now we are migrating to 2014.

    Is there a replacement for it in 2014? Sorry, I don't have B.O.L. installed on my machine, so I have to ask such simple question here. And I mean database engine, not SSAS.

    Thanks

  • June 24, 2015 at 9:15 am

    #1807795

    Check here[/url] for some ideas.

    You don't need BOL installed to use it. Look here.

  • June 24, 2015 at 9:52 am

    #1807811

    Thanks for 1st tip, Phil. Rollup works for me, however with some changes to order by clause.

    But about the 2nd tip, this is not exactly BOL that I expected. I tried to search for ROLLUP in upper-right search window, and it gave me hundreds of links, most of them for MS Dynamics, Windows, Access, etc. And it's very slow.

    In my real BOL which I use in 2008, if I type a word in upper-left search window, it immediately brings me to needed section.

  • June 24, 2015 at 11:14 am

    #1807839

    SQL Guy 1 (6/24/2015)

    Thanks for 1st tip, Phil. Rollup works for me, however with some changes to order by clause.

    But about the 2nd tip, this is not exactly BOL that I expected. I tried to search for ROLLUP in upper-right search window, and it gave me hundreds of links, most of them for MS Dynamics, Windows, Access, etc. And it's very slow.

    In my real BOL which I use in 2008, if I type a word in upper-left search window, it immediately brings me to needed section.

    If I am having problems finding something in BOL, I usually embellish the search to help narrow down the results. In this case, instead of searching for 'compute', try searching for 'compute technet t-sql'.

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

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