Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


12345»»»

Discuss Content Posted by Jeff Moden Expand / Collapse
TitleStarted ByRepliesViewsLast Post
Hot Topic (New Replies)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.  
1243
Rated 5 stars based on 4 votes
Jeff Moden 428 121,214 Yesterday @ 9:14 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations  
126
Jeff Moden 51 13,805 Yesterday @ 5:47 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Tally OH! An Improved SQL 8K “CSV Splitter” Function  
1292
Jeff Moden 918 279,402 Monday, November 28, 2016 5:19 AM
Last Post By: Ed Wagner
Hot Topic (New Replies)
How to Make Scalar UDFs Run Faster (SQL Spackle)  
1210
Jeff Moden 97 71,660 Monday, November 21, 2016 12:33 PM
Last Post By: mickyT
Hot Topic (New Replies)
Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)  
1232
Jeff Moden 310 135,979 Saturday, October 8, 2016 2:04 PM
Last Post By: Seggerman-675349
Hot Topic (New Replies)
Forum Etiquette: How to post data/code on a forum to get the best help  
1221
Rated 5 stars based on 4 votes
Jeff Moden 204 111,528 Friday, July 8, 2016 7:32 AM
Last Post By: John Mitchell-245523
Hot Topic (New Replies)
Create a Tally or Numbers Table  
124
Jeff Moden 36 7,503 Saturday, May 21, 2016 7:48 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Group Islands of Contiguous Dates (SQL Spackle)  
127
Rated 5 stars based on 1 vote
Jeff Moden 60 25,359 Thursday, March 10, 2016 2:10 AM
Last Post By: Gert.Broekhaar
Hot Topic (New Replies)
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets  
128
Jeff Moden 76 39,032 Wednesday, December 16, 2015 8:43 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
A Simple Formula to Calculate the ISO Week Number  
127
Jeff Moden 68 8,615 Wednesday, December 9, 2015 11:20 AM
Last Post By: chill-1062987
Hot Topic (New Replies)
Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)  
126
Jeff Moden 56 19,824 Thursday, December 3, 2015 6:01 AM
Last Post By: ChrisM@Work
Topic (New Replies)
"Quirky Update" Where Clause Problem  

iracildols 0 381 Wednesday, July 8, 2015 10:39 AM
Last Post By: iracildols
Hot Topic (New Replies)
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs  
1213
Rated 5 stars based on 1 vote
Jeff Moden 129 47,191 Tuesday, July 7, 2015 8:08 AM
Last Post By: Goldie Lesser
Hot Topic (New Replies)
Hidden RBAR: Counting with Recursive CTE's  
128
Jeff Moden 72 79,372 Tuesday, June 23, 2015 11:56 AM
Last Post By: Jeff Moden
Hot Topic (New Replies)
REPLACE Multiple Spaces with One  
1243
Rated 5 stars based on 1 vote
Jeff Moden 420 172,018 Thursday, May 28, 2015 8:27 PM
Last Post By: Alan.B

12345»»»

Permissions Expand / Collapse

Topic Key Expand / Collapse
Topic (New Replies)  Topic (New Replies)
Topic (No New Replies)  Topic (No New Replies)
Hot Topic (New Replies)  Hot Topic (New Replies)
Hot Topic (No New Replies)  Hot Topic (No New Replies)
Poll (New Replies)  Poll (New Replies)
Poll (No New Replies)  Poll (No New Replies)
Closed Topic  Closed Topic
Moved Topic  Moved Topic