<div>
Hi qadsam,<br />
<br />
As far as I am aware, SQL Server has not implemented the LEAD or LAG functions. &nbsp;This might help <a href="http://rafael-salas.blogspot.com/2008/05/t-sql-lead-and-lag-functions.html" rel="ugc">http://rafael-salas.blogspot.com/2008/05/t-sql-lead-and-lag-functions.html</a>&nbsp;<br />
<br />
lwadwell
</div>


Hi qadsam,

As far as I am aware, SQL Server has not implemented the LEAD or LAG functions.  This might help http://rafael-salas.blogspot.com/2008/05/t-sql-lead-and-lag-functions.html [http://rafael-salas.blogspot.com/2008/05/t-sql-lead-and-lag-functions.html] 

lwadwell

<div>
Solution found<br />
Thanks,
</div>


<div>
<div class="content wysiwyg-content">
I am trying to accomplish lag function, over and last value, first value in sql server 2005.<br />
<br />
Can you please help.<br />
Query from oracle i wanted to convert to sql server<br />
100*((reads- nvl(lag(reads,1)over(order<wbr /> by snap_id),reads)) /<br />
&nbsp; &nbsp; (last_value(reads)over(ord<wbr />er by 1)-first_value(reads)over(<wbr />order by 1))) Reads<br />
<br />
Thanks,<br />
sam<br />

<pre><code id="code-295721">100*((reads- nvl(lag(reads,1)over(order by snap_id),reads)) /
    (last_value(reads)over(order by 1)-first_value(reads)over(order by 1))) PRD,
</code></pre>
</div>
</div>


I am trying to accomplish lag function, over and last value, first value in sql server 2005.

Can you please help.
Query from oracle i wanted to convert to sql server
100*((reads- nvl(lag(reads,1)over(order by snap_id),reads)) /
    (last_value(reads)over(order by 1)-first_value(reads)over(order by 1))) Reads

Thanks,
sam

lag function

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.