Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 


1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup:
2. Twitter:
3. LinkedIn:


Next Meeting




Jeff Moden: The Tally Table and Pseudo Cursors

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 20:00 Eastern Daylight Time
  • Language: English

Session Title: The Tally Table and Pseudo Cursors
Session Level: Intermediate
Speaker: Jeff Moden
Don’t let the “Intermediate” rating scare you “Beginners” away. This “Black Arts” session is for anyone that uses T-SQL. There are dozens of things we do in SQL that require some type of iteration anywhere from splitting delimited columns to quickly building millions of rows of random test data. "Iteration" means "counters" and "loops" to most people and recursion to others. To those well versed in the techniques of "Set-based" programming, it means some form of a "Numbers" or "Tally" Table, instead. This session takes the mystery out of how these wonderfully compact tools work and how they easily replace many types of loops. This session has been updated to include additional information about what “Pseudo-Cursors” are and how they work as well discovering why “Recursive CTE’s” can be your worst enemy. If you've never heard of a Tally or Numbers Table before, this session will change your life for the better in the competitive world of SQL Server and programming in T-SQL.
Speaker BIO:
Jeff Moden is an “Accidental DBA” with nearly two decades of SQL Server experience.  Jeff’s original article on SQL Server central helped make the advanced technique known as the “Tally” or “Numbers” Table a household word and coined the term “RBAR”, which stands for “Row By Agonizing Row”.  He’s written more than 30 mostly five star articles for and, having more than 36,000 posts, is one of the all-time leading contributors on that site.  Jeff is renowned for being able to teach extremely complex concepts and techniques in such a manner that even beginners can understand without boring the experts.  He’s been an SQL Server MVP since 2008, won the Red Gate exceptional DBA award in 2011, has spoken at the PASS Summit, many SQL Saturdays, and many local PASS chapter meetings on my different SQL Server subjects.



Back to Top