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...

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...

Hi Lynn,

Can i bother you with a quick question? Have had a look at the code and am intersted in a couple of bits that are new to me....

Hi Lynn,

Thanks for the post, off now till friday afternon (gmt) so will have a look and respond after i have abrorbed.

Cheers,

...

Hi Sean,

When the original developer put it all together (about ten years ago) and started to show me the basics of Sql, he told me to always use the...

Thanks Chris will have a look at that this afternoon.

Martin.

Thanks for your time, will get those on and have a play around with it.

Cheers,

...

Hi,

Sorry, have read through the link now. I think i was getting sidetracked by my thoughts that the query itself is not the problem, so didnt cover it enough.

Have...