SQL Windowing screencast session for Cuppa Corner - rolling totals, data cleansing

Posted by tonyrogerson on SQL Blogcasts See other posts from SQL Blogcasts or by tonyrogerson
Published on Fri, 21 May 2010 12:12:00 GMT Indexed on 2010/05/21 13:11 UTC
Read the original article Hit count: 549

Filed under:
|
|
In this 10 minute screencast I go through the basics of what I term windowing, which is basically the technique of filtering to a set of rows given a specific value, for instance a Sub-Query that aggregates or a join that returns more than just one row (for instance on a one to one relationship). http://sqlserverfaq.com/content/SQL-Basic-Windowing-using-Joins.aspx SQL below... USE tempdb go CREATE TABLE RollingTotals_Nesting ( client_id int not null, transaction_date date not null, transaction_amount...(read more)

© SQL Blogcasts or respective owner

Related posts about sql

Related posts about windowing