RE: Re: UKHA Classified update - SQL Help!

["BUTLER, Tony, FM" <tony.butler@xxxxxxx>]

> Sorry Tony, didn't make myself clear, it was Steve's code
> that I tried and
> had the problem with (I was busy/lazy and so used his code as

NP.
Change this line:
Select ProductTypeID into ##tablist from tblProductsType where
ParentProductTypeID = @ProductTypeID

to the following two:

create table ##tablist (ProductTypeID int)

INSERT ##tablist
SELECT ProductTypeID from #tblProductsType where
ParentProductTypeID = @ProductTypeID

The problem is that you are using identity columns in your 'real' tables
&
Steve's lazy (baiting!) way of doing things means ##tablist inherits the
identity property & you get the problem you've seen.  The above should
cure
it.

> for cut and paste without any thought). I might give your code a go
> tonight, but I am driving over to Ireland in the early hours,
> so could well
> be the subject of a computer embargo until we are packed!

SNAP!  Race you!  5am start probably for us.
don't mind the drive to Holyhead so much, but it's a bugger driving across
the irish sea :-)

Tony


********************************************************************
Visit our Internet site at http://www.rbsmarkets.com

This e-mail is intended only for the addressee named above.
As this e-mail may contain confidential or privileged information,
if you are not the named addressee, you are not authorised to
retain, read, copy or disseminate this message or any part of it.
********************************************************************