Here is a short video that shows how to convert those ugly derived table (SubQuery) queries into a common table expression to help clean up… Read More »Using a Common Table Expression Instead of a Derived Table
Next week, on Thursday Feb 26th Aaron Buma and I, as part of the Free SQL Training, will be presenting on the use of the… Read More »Next Week’s Free SQL Training: MERGE Statement and Recursive Queries
I just a added a video to YouTube titled “What is a Common Table Expression”. This video covers the extreme basics of what a CTE… Read More »What is a Common Table Expression
The free SQL Server Queries weekly training is being presented by Steve Stedman and Aaron Buma. The name of the presentation started out as “OUTPUT Clause and… Read More »Weekly SQL Training – OUTPUT Clause and Derived Tables
Earlier in the week I added a blog entry on using the OUTPUT Clause on INSERT Statements, today I will expand it by exploring the use of… Read More »TSQL OUTPUT Clause With UPDATE Statements
One of the often overlooked features of SQL Server is the OUTPUT clause, which applies to INSERT, UPDATE, DELETE, and MERGE statements. In this post… Read More »TSQL OUTPUT Clause on Insert Statements
On Thursday Feb 19th at 9:00am pacific time, Aaron Buma and I will be doing another FREE SQL query training session. This is a free training… Read More »Next Free SQL Query Training – OUTPUT Clause and Derived Tables
Here is the agenda for this weeks free SQL training covering Set Operators, Derived Tables and CTEs – Presentation to prepare for the 70-461 exam: Set… Read More »Set Operators, Derived Tables and CTEs – Presentation downloads
SQL Server – TSQL Analytics Word Search Find the following words in the word scramble above. TOP RANK DENSE_RANK ROW_NUMBER NTILE OVER LAG LEAD FIRST_VALUE… Read More »SQL Sunday Word Scramble
NTILE is a SQL Server function that can be called in a TSQL Query. This is part of the free sql query training to prepare… Read More »TSQL Queries – Using NTILE