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 *;


      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.