Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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)
Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets  
128
Jeff Moden 70 14,490 Saturday, July 19, 2014 12:45 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Hidden RBAR: Triangular Joins  
1227
Jeff Moden 265 39,473 Monday, July 14, 2014 2:07 AM
Last Post By: Cody K
Hot Topic (New Replies)
The "Numbers" or "Tally" Table: What it is and how it replaces a loop.  
1243
Rated 5 stars based on 2 votes
Jeff Moden 424 59,404 Saturday, July 12, 2014 6:25 AM
Last Post By: Eirikur Eiriksson
Hot Topic (New Replies)
Tally OH! An Improved SQL 8K “CSV Splitter” Function  
1265
Jeff Moden 643 137,149 Wednesday, July 9, 2014 2:46 PM
Last Post By: mburbea
Hot Topic (New Replies)
Group Islands of Contiguous Dates (SQL Spackle)  
126
Rated 5 stars based on 1 vote
Jeff Moden 59 11,995 Sunday, June 29, 2014 9:42 PM
Last Post By: dwain.c
Hot Topic (New Replies)
How to Make Scalar UDFs Run Faster (SQL Spackle)  
1210
Jeff Moden 94 32,407 Wednesday, June 25, 2014 9:41 PM
Last Post By: dwain.c
Hot Topic (New Replies)
Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)  
1217
Jeff Moden 166 32,237 Tuesday, June 17, 2014 2:45 PM
Last Post By: ColdCoffee
Topic (New Replies)
Order by does not work with intersect (thread started by suggestion from Sean Lange)  

valeryk2000 9 83 Friday, June 6, 2014 11:42 AM
Last Post By: Lynn Pettis
Hot Topic (New Replies)
Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)  
1229
Jeff Moden 287 62,076 Wednesday, May 28, 2014 10:24 PM
Last Post By: autoexcrement
Hot Topic (New Replies)
Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations  
124
Jeff Moden 35 6,322 Tuesday, April 8, 2014 10:11 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Finding “Active” Rows for the Previous Month (SQL Spackle)  
125
Jeff Moden 41 2,015 Friday, February 7, 2014 11:30 AM
Last Post By: marcia.j.wilson
Hot Topic (New Replies)
Displaying Sorted Hierarchies (SQL Spackle)  
126
Jeff Moden 58 40,645 Monday, January 27, 2014 9:30 AM
Last Post By: sholliday
Hot Topic (New Replies)
Query Tuning  
125
Jeff Moden 49 13,095 Saturday, January 25, 2014 5:48 AM
Last Post By: pmadhavapeddi22
Hot Topic (New Replies)
Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)  
12
Jeff Moden 15 1,006 Thursday, January 23, 2014 7:15 PM
Last Post By: Jeff Moden
Hot Topic (New Replies)
Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)  
125
Jeff Moden 45 3,046 Monday, January 20, 2014 6:14 PM
Last Post By: Peter E. Kierstead

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