4 Replies Latest reply: Feb 24, 2014 8:04 AM by Johan Fredrik Øhman RSS

    Multiple statements in SQL query

    Johan Fredrik Øhman

      Hi,  I have a quick question, which I suspect the answer to is No.

       

      Can you, in Qlikview, directly execute SQL statements like this:

       

      --------------------

      LOAD *;

      SQL

      declare @maxdate date;

      select @maxdate =  max(MyColumn) from Holdings

      select * from AnotherTable Where Column < @maxdate;      

      ---------------------

       

      In MSQL Server Management Studio they run just fine, but I believe there are restrictions on these multiple statements over ODBC, and that they need to be converted to stored procedures serverside?

       

      Can anybody confirm this?

       

      Thank you.

      J