Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
533 reads
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
533 reads
A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.
2012-02-29 (first published: 2012-02-15)
503 reads
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,174 reads
I currently, have a field in a table that is a numeric field = 20030104 - I need to convert this to a date field = 01/04/2003 - what is the proper syntax for use in a select statement?Note that I am creating a table and I tried to change the field type to datetime, […]
2004-11-12
5 reads
I have a large dataset (names; in this context) of more than 50000 records which i wanted to dump into SQL Server using SQLXMLBulkLoad. I use C# and here is how i implemented:// Initialize OLEDB Connection for SQLXML Bulk LoadSQLXMLBulkLoad3Class bl = new SQLXMLBulkLoad3Class();bl.ConnectionString = ConUtil.GetBulkXMLConString();//bl.KeepIdentity = true; bl.BulkLoad = true; //bl.Transaction = true;bl.ErrorLogFile = "BulkImport.log";bl.ForceTableLock […]
2004-09-15
15 reads
OK, MS is out of date; using a subquery is faster. Like this: Select t.tname, t.tid, ( Select count(t1.tid) From #test t1 where t1.tName < t.tName--This is where you signify the rank order ) NameRank From #test t ----------------Test Data------------------ if object_ID('tempdb..#test') is not null drop table #test create table #test (Tid int identity, tname […]
2003-11-25
1 reads
quote: Does anyone know of a way to prevent people who have query privledges from Accessing SQL Server with MS Access? Has anyone tried Application Roles for this? Assume for sake of argument that the reasons for giving them direct query access are valid. MS Access can unfortunately become a powerful tool in dangerously unskilled […]
2003-07-07
4 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...