Philip Sivyer | SQLServerCentral

Philip Sivyer

Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

RE: adding a column where data required is "next row date field"

Thanks again - Phil

April 25, 2006 at 5:32 am

#633968
RE: adding a column where data required is "next row date field"

When I try to create a view with your sql query the following error appears ....
Server: Msg 1033, Level 15, State 1, Procedure fsd, Line 6
The ORDER BY clause is invalid...

April 25, 2006 at 4:44 am

#633962
RE: adding a column where data required is "next row date field"

Spot on ....... Vladan, thanks for your help.
Regards
Phil

April 25, 2006 at 4:32 am

#633960
RE: adding a column where data required is "next row date field"

Yes - the issue_id is 6758

April 25, 2006 at 4:18 am

#633958
RE: adding a column where data required is "next row date field"

Thanks for the reply - when run this happens - see row 2 - the date returned in column 4 is incorrect, it should read "2008-02-01 00:00:00.000 ". Perhaps I did not...

April 25, 2006 at 3:48 am

#633950

Viewing 5 posts - 1 through 6 (of 6 total)