2018-09-27
807 reads
functions
Bowled Over by SQL Window Functions
What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.
2015-02-12
10,399 reads
Blogs
Speaking Engagements 2025
By alevyinroc
It’s been a minute since I’ve gotten out to speak at events, but the...
PASS Summit on Tour in New York City
By Steve Jones
The PASS Summit goes on tour this year, with an August stop in New...
SQL Server Errorlog: Not Just for Errors!
By Kevin3NF
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get...
Forums
Need Help to implement the De Duplication
Dear All, Good Day. I have a requirement to implement de-duplication on customer data...
Own Your Mistakes
Comments posted to this topic are about the item Own Your Mistakes
Automating SQL Server Inventory Collection with SQLInventory
Comments posted to this topic are about the item Automating SQL Server Inventory Collection...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers