September 14, 2012 at 8:34 am
Here is the err mssg and the line it went to:
Msg 102, Level 15, State 1, Procedure MISQRY0000026, Line 32
Incorrect syntax near '.'.
outer apply [dbo].[BoxedStock](cil.modelid) bs(ItemCount)
The above line follows an inner join clause and is followed by the second outer apply.
The functions created fine, thanks for the links will check them all out.
Martin.
September 14, 2012 at 8:42 am
m.henly (9/14/2012)
Here is the err mssg and the line it went to:Msg 102, Level 15, State 1, Procedure MISQRY0000026, Line 32
Incorrect syntax near '.'.
outer apply [dbo].[BoxedStock](cil.modelid) bs(ItemCount)
The above line follows an inner join clause and is followed by the second outer apply.
The functions created fine, thanks for the links will check them all out.
Martin.
I have got no idea. With out the tables used by the procedure and functions I can't test. You need to post the DDL for the tables.
September 14, 2012 at 9:03 am
Not to worry Lynn you have given me more than enough help and information to move me along, i will look into what im doing wrong myself and get more familiar with the APPLY method. I do recognise the apply articles from previous visits to the site, but probably only having the 2k server at the time didnt take them in.
Cheers again, have a good weekend:-D
Martin.
Viewing 3 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply