What will you learn?

Have you ever needed to compute the minimum or maximum value over columns? How about computing row numbers with no particular order, just for uniqueness? Have you ever tried creating an ordered view? How about reusing column aliases defined in the SELECT list in other clauses like the WHERE and GROUP BY? This session describes a number of needs that are not directly supported in T-SQL, and shows how with a bit of creativity, you can address those needs.

Visit PASS site


Itzik Ben-Gan is a mentor and Co-Founder of Lucient. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books including T-SQL Fundamentals, T-SQL Querying, and T-SQL Window Functions. Itzik’s speaking activities include PASS Summit, SQLBits, and various user groups around the world. Itzik is the author of Lucient’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for their T-SQL related activities.