The link is still not working. Are there any other ways to access this info?

Chris Morris-439714 (11/30/2010)

---

Thanks Dan.

SELECT rn = ROW_NUMBER() OVER(ORDER BY JobNo, Line),

Line, JobNo, PropRef, Cont, RepDate, RepTime, LogDate, LogTime, ShortDesc, Access, JobDesc, ClientJob

FROM (

SELECT Line, JobNo, PropRef, Cont, RepDate, RepTime,...

CREATE TABLE #Table (

Line INT,

JobNo VARCHAR(20),

...

Sorry for the confusion!! I have amended what the output is that is needed.

Hi Experts!!

I need to create a view to select data from table & force static data into...

Data below