﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Content tagged T-SQL, LAG</title><link>http://www.sqlservercentral.com/</link><description>Content tagged T-SQL, LAG posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Analytic Enhancements in SQL Server 2012 - Part II </title><description><![CDATA[<p>The introduction of the new analytic functions in the RTM version of SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE, with the improved over clause, greatly facilitate the analysis on ordered data sets, such as time-series data. Read on to learn more.</p><!-- machanic (SQL Comapre)-->
<table border="0" cellpadding="0" cellspacing="10" style="width: 100%;"> <colgroup>  <col width="68" />  <col width="1266" /> </colgroup> <tbody>  <tr align="left" valign="top">   <td>    <a href="http://www.red-gate.com/products/sql-development/sql-compare/?utm_source=ssc&utm_medium=pubad&utm_content=machanic&utm_campaign=sqlcompare&utm_term=rss-20226"><img src="http://assets.red-gate.com/external/SSC/sqlcompare68x68.gif" alt="sqlcompare"></td>   <td><strong>Compare and sync databases with SQL Compare</strong><br />“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP.  <a href="http://www.red-gate.com/products/sql-development/sql-compare/?utm_source=ssc&utm_medium=pubad&utm_content=machanic&utm_campaign=sqlcompare&utm_term=rss-20226">Download a 14-day free trial.</a></td>  </tr> </tbody></table>


]]></description><guid>http://www.sqlservercentral.com/redirect/articles/89995/</guid><pubDate>Wed, 25 Apr 2012 06:00:00 UT</pubDate><link>http://www.sqlservercentral.com/redirect/articles/89995/</link></item></channel></rss>