This function takes a number of Seconds in BIGINT format and calculations and displays that in a DDD:HH:MM:SS format.I wrote this because I needed to work out the duration between two datetimes and required the result to be displayed in a Report (VARCHAR (12)) format from a Select statementTo Use:SELECT dbo.csp_SecondsToDaysHoursMinutesSeconds(DATEDIFF(SS, , )) AS DurationFROM […]
2002-05-09
353 reads
This script is designed to eliminate weekends and designated non business days (such as holidays and other days a company is closed) from a computation to determine if a particularorder was shipped on time, early, or late.
2002-05-01
805 reads
This script will be helpful to only those people who arehaving identical database with different names.This script can be used to copy single or multiple tables from one database to anotherThe parameters @tname , source database and target database are important for the script to work. In the script below I have considered two databases […]
2002-04-16
1,622 reads
A Modified Version of dateDiff. DateDiff Fucntion checks the "datepart" only of the dates. This modified function returns how many "date part" is exactly passed.
2002-04-08
1,085 reads
Sample script header to use to describe a stored procedure. This is a piece of the one I use but needs modification for each environment.
2002-04-04
1,260 reads
2002-04-01
707 reads
2002-04-01
795 reads
This script would help you find users, their logins, roles etc in a database.
2002-04-01
361 reads
Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]
2002-03-27
240 reads
This article looks at the T-SQL CAST function and how it is used and preferred to CONVERT().
2002-03-18
16,881 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item When And How to Automate?
Comments posted to this topic are about the item Hyperscale Replicas II
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers