Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
2008-01-31
17,749 reads
Jeff Moden
- Interests: SQL. When Im not having fun with that, then SQL. ;-)
Performance Tuning: Concatenation Functions and Some Tuning Myths
Rumor has it that Concatenation functions have gotten the nasty reputation of being "performance hogs". Here's why that's not true.
2008-01-01
22,143 reads
Calculating Work Days
How many times have you wished that there was a parameter for DATEPART to allow you to check for workdays? While many of us may get stuck working 6 or 7 days a week, most of the world revolves on a 5 day work week. Monday through Friday. New author Jeff Moden brings us a method of easily calculating the number of workdays between any two dates.
2007-10-02 (first published: 2005-01-10)
71,871 reads
Difference between dates with thousands separators
This function calculates the time difference between 2 datetimes and displays the results in the following format:H,HHH,HHH:MM:SSThe return is a 15 character field that is left padded with spaces so that the field becomes right justified. This makes the colons line up for easy reading. Commas are automatically added as thousands separators as needed by […]
2004-03-14
410 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)...