Hi,
I've a simple TSQL query with Date range parameters that runs fine in SQL Server Management studio and SSRS. Now, I'm trying to use this query in QlikView to create a report. I'm new to QlikView and just couldn't find a way to get the dataset from the below mentioned query. I believe I must be missing out something here.
Any kind is help and suggestion is really appreciated.
Thanks.
SELECT FirstName
,LastName
,PsgrID
,TktNbr
,FlightDate
,DeptCity
,TktAmount
,SeatNbr
FROM Tbl_Psgr
WHERE FlightDate BETWEEN @StartDate AND @EndDate
ORDER BY FlightDate desc;