Search results
21 lut 2014 · SELECT * FROM ( SELECT * FROM [table] tbl WHERE [some conditions] ORDER BY tbl.date ) WHERE ROWNUM < 100; is extremely inefficient, since the entire table is read and ordered. It is likely (but not guaranteed) that the most recent dates are at the end of the table.
17 wrz 2016 · I need data in the following form. This table has a status and its corresponding start and end timestamp for a particular thing_id: +----------+-------------+---------------------+---------------------+. | thing_id | status | status_start_date | status_end_date |. +----------+-------------+---------------------+---------------------+.
17 maj 2021 · Learn SQL Server date and time functions SYSDATETIME, SYSDATETIMEOFFSET, SYSUTCDATETIME, CURRENT_TIMESTAMP, GETDATE(), DATENAME, DATEPART with examples.
2 maj 2008 · select @file_date=cast(ltrim(left(dl,charindex(' ',dl))) as datetime),@file_size=cast(replace(substring(dl,charindex(' ',dl),255),@fn,'') as bigint) from @dir where dl like '%'+@fn+'%' end
20 lip 2013 · We can use a query like below to get Quarter’s Start and End Date for a given date. DECLARE @AnyDate DATETIME SET @AnyDate = GETDATE() SELECT @AnyDate AS 'Input Date', DATEADD(q, DATEDIFF(q, 0, @AnyDate), 0) AS 'Quarter Start Date', DATEADD(d, -1, DATEADD(q, DATEDIFF(q, 0, @AnyDate) + 1, 0)) AS 'Quarter End Date'
30 sty 2024 · The SQL Server function EOMONTH() makes it easy to find the end of the month for any date. One of its uses is to turn all the dates into the last day of the month, i.e. when there’s a monthly reporting period.
18 lip 2019 · Learn to calculate Start / First of Week, End of Week, Start of Next Week, Year, Quarter, and Month of the week, Week Numbers and more in T-SQL (Jeff Moden)
