UDF - SQL 2000 and higherThis function returns an 18 row table of date ranges around a given date.The ranges are: Day, Week (Sunday to Saturday), Month, Quarter, Half Year, Year.For each range there are 3 values: Previous, Same and NextExample of usage:Joined to an orders table:Select r.period, count(o.order_id)from orders oinner join dbo.ufn_date_ranges('2003-04-01') ron o.order_date […]
2007-04-12 (first published: 2003-07-03)
482 reads
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
By Tim Mitchell
Earlier this month, I hosted the monthly T-SQL Tuesday invitation in which I asked,...
I'm not sure that I'm posting this in the right section, so please mods...
Hi all I've written a script to keep track of how long backups...
I have this view [dbo].[Asset Metrics - Client(Rama -Client-Test)], which makes use of multiple...
In the current (Sep 2024) Data Migration Assistant, what are the possible sources for on-premises SQL Server instances?
See possible answers