topic Re: How to get data from SQL from specific range of dates in QlikView

How to get data from SQL from specific range of dates

jhona1737 — Wed, 14 Feb 2018 03:29:40 GMT

Hi everyone,

So my question is I have a lot of data on our SQL server and I think is going to take a while to download all that data, for example how can I download only 2018 data?

Thanks!

Re: How to get data from SQL from specific range of dates

karthikoffi27se — Wed, 14 Feb 2018 05:04:26 GMT

Hi Jhonatan,

try using below expressoon

select * from dbo.DATABASE where A.Date >= Convert(datetime, '2018-01-01' )

Many Thanks

Karthik

Re: How to get data from SQL from specific range of dates

shiveshsingh — Thu, 15 Feb 2018 11:02:08 GMT

by putting where clause

where Date>= '01/01/2018'

please check the date format as well before putting this clause

Re: How to get data from SQL from specific range of dates

wdchristensen — Wed, 21 Feb 2018 21:10:22 GMT

-- Avoid Using Functions in WHERE Clause --

DECLARE @TableVariable TABLE (Units INT, Account INT, BudgetPeriod NVARCHAR(20), MyDate DATE)

INSERT INTO @TableVariable

VALUES

(12, 1234,'BudgetPeriod01','01/02/2018'),

(34, 2345,'BudgetPeriod02','02/03/2018'),

(45, 1234,'BudgetPeriod01','01/02/2017'),

(67, 2345,'BudgetPeriod02','02/03/2017')

/* If you want the best performance DON’T implement your solution this way.

Here is why: https://www.mssqltips.com/sqlservertutorial/3204/avoid-using-functions-in-where-clause/ */

Select *

From @TableVariable

Where YEAR(MyDate)=2018

--This is the correct method

Select *

From @TableVariable

Where MyDate>='01/01/2018'

Re: How to get data from SQL from specific range of dates

jhona1737 — Wed, 21 Feb 2018 21:23:48 GMT

Thank you!