Below is a sample of the data I would like to work with. I would like to select the RUN data (last column) from the previous row. For...

ROWIDWORKORDER_BASE_IDWORKORDER_LOT_IDRESOURCE_IDSEQUENCE_NO

472609396211WI PRESSGR-NHB110

472610396211WIPRESSOP20

472611396211WI OVEN-530

472612396211WI PART COOLOFF35

472613396211WI SAND-640

472614396211WI INSPECT50

472615396211WI STAMP-160

472616396211WI REWORK70

472774396221WI SRL GRP20

472775396221WI REWORK70

472788396241WI PULL FR STK60

472789396241WI SHIPPING STK70

472790396251WI PRESS-2910

472791396251WIPRESSOP15

472792396251WI SAND-120

472793396251WI OVEN-230

472794396251WI PART COOLOFF31

472795396251WI SAND-135

472796396251WI CNCMILL GRP40

472797396251WICNCMILLOP45

472798396251WI INSPECT49

472799396251WI STAMP-150

472800396251WI REWORK60

47280139623AWI PRESSGR-OR-210

47280239623AWIORANGEOP20

47280339623AWI OVEN-330

47280439623AWI...

As I explained earlier, I do not have any experience creating tables. I appreciate your patience. I found enough information to successfully create the temp table. Please...

Here you go.

CREATE TABLE #mytable

(

ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

...

I did that first. Even if I add that statement to the rest, I still receive the same error.

I am attempting to follow the instructions for trying to compile some test data and I keep getting the error message 'Invalid Column Name'. I am obviously missing something....

I'm not sure if that would pertain or not. What I am trying to do is pull information from a table (Operation) that contains multiple operations per Work Order....

Thank you all for your input but after further review, I cannot use the rowid field as some of the operations were added later so the numbers are not in...

Hi Dwain - Thank you for the advice, but no, I am on 2008.

Thank you...I'm going to have to review my data further and do some testing to see if row id will work. I hope so. I'll post back in...

Lowell - You are correct, the SEQ is a number and the information that I want is associated with the SEQ # directly before that operation. I attached a...

I appreciate both of your help. It is the row above in both the abc table and the view. I am reviewing the article that Brain Donor referenced...

Thank you...I just wanted to be sure.

Martin - Can I just reinstall SSRS and not override anything else? How would I do that? I did not do the original install and don't want to...

Sorry, that was a stupid question...I only have the Business Intelligence Development Studio installed on my workstation, some stuff is coming back to me. Yes, I will continue reading...