Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Are you able to load SQL queries with variables/table variables? I would like to keep the TSQL syntax for the variables. The below query is just an example and is not practical.
Example:
DECLARE
@fdate DATETIME,
@tdate DATETIME,
SET @fdate = '1/1/2021'
SET @tdate = '1/31/2021'
DECLARE @test TABLE(
ID INT
)
INSERT INTO @test
SELECT ID FROM table1
WHERE ID < 50
SELECT *
FROM table2 t2
JOIN @test t1 ON t2.ID = t1.ID
Hi Terra,
you can create sp in ur SQL server & use it in qlik app
SQL EXEC urprocedurename;
Thank you. Yes I thought of that as well, however I don't want to create Sprocs every time I have a script that is similar to this.