# Discuss Content Posted by Jeff Moden

• Topics

Started by

Posts

Last post

• ## A Simple Formula to Calculate the ISO Week Number

Comments posted to this topic are about the item A Simple Formula to Calculate the ISO Week Number …

77 replies

• ## Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Comments posted to this topic are about the item Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs…

130 replies

• ## Hidden RBAR: Counting with Recursive CTE's

Comments posted to this topic are about the item Hidden RBAR: Counting with Recursive CTE's --Jeff …

73 replies

• ## How to Make Scalar UDFs Run Faster (SQL Spackle)

Comments posted to this topic are about the item How to Make Scalar UDFs Run Faster (SQL Spackle) -…

102 replies

• ## Hidden RBAR: Triangular Joins

Comments posted to this topic are about the item Hidden RBAR: Triangular Joins[/url] First, thank…

255 replies

• ## Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

Comments posted to this topic are about the item Some T-SQL INSERTs DO Follow the Fill Factor! (SQL…

11 replies

• ## Group Islands of Contiguous Dates (SQL Spackle)

Comments posted to this topic are about the item Group Islands of Contiguous Dates (SQL Spackle) --…

62 replies

• ## Sorting Months By Number (SQL Spackle)

Comments posted to this topic are about the item Sorting Months By Number (SQL Spackle) --Jeff Mode…

97 replies

• ## REPLACE Multiple Spaces with One

Comments posted to this topic are about the item REPLACE Multiple Spaces with One --Jeff Moden RBAR…

425 replies

• ## Solving the Running Total and Ordinal Rank Problems (Rewritten)

Comments posted to this topic are about the item Solving the Running Total and Ordinal Rank Problem…

307 replies

• ## Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

Comments posted to this topic are about the item Skipping Columns (& other tricks) Using BCP Fo…

19 replies

• ## Calculating Work Days

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum…

156 replies

• ## Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Comments posted to this topic are about the item Cross Tabs and Pivots, Part 1 – Converting Rows …

243 replies

• ## Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Comments posted to this topic are about the item Hierarchies on Steroids #2: A Replacement for Nest…

50 replies

• ## Create a Tally or Numbers Table

Comments posted to this topic are about the item Create a Tally or Numbers Table --Jeff Moden RBAR …

34 replies

Viewing 15 topics - 16 through 30 (of 57 total)

You must be logged in to create new topics.