SQL Server 2012: Time Marches On
Greg Larsen explores the new SQL Server 2012 date and time functions and shows you how to exploit these functions in new application code.
2013-02-13
3,844 reads
Date Manipulation
2012-11-27
2,168 reads
SQL Server Function to return a range of dates
A quick solution is a table function that will create a date range based on the parameters given. Then, you can just join to the results.
2012-11-02
4,979 reads
2012-01-30 (first published: 2011-12-23)
872 reads
2012-01-20 (first published: 2011-12-16)
1,007 reads
2011-06-24 (first published: 2011-06-14)
1,836 reads
Find Last Day of the Month
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,414 reads
2011-04-27 (first published: 2011-04-21)
2,735 reads
2010-11-26 (first published: 2010-11-04)
577 reads
A Flexible Day Of Week Function
A Flexible Day Of Week Function where a criteria can be passed as an integer to a stored procedure.
2010-10-13 (first published: 2010-10-06)
1,380 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...