August 21, 2008 at 7:08 pm
I am hoping this might be easy. My lack of knowledge in this topic is blocking me from progressing in doing a report. What I ultimately need to do is take a time value from the current row and subtract it from the pervious row's Time value. How do I look at the previous row's value? Is this a situation where I need to create a stored procedure for this, or is there a SQL method that I can use? I know that Reporting Services has a PREVIOUS method that is helpful in doing this.
Thanks for the information.
August 21, 2008 at 8:14 pm
You need to look at this article: http://www.sqlservercentral.com/articles/T-SQL/62159/
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 22, 2008 at 5:32 am
Thanks for the information. This will greatly help me.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply