Previous Monday to the Start of the Previous Quarter
Previous Monday to the Start of the Previous Quarter
2019-07-29 (first published: 2019-07-18)
427 reads
datefirst
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)
527 reads
Week Starts On Saturday?
A function that emulates SET DATEFIRST 6 within a function for finding relevant date information.
2012-02-29 (first published: 2012-02-15)
502 reads
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
9,869 reads
DateTime Conversion
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
2 reads
SQLXMLBulkLoad C# Issue on Insert :: URGENT HELP!
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
14 reads
RE: Return row number without using IDENTITY
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
RE: Preventing MSAccess Connections
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
2 reads
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers