Re: UKHA Classified update - SQL Help!

[graham@xxxxxxx]

BUTLER, Tony, FM writes:

> > 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.
>
Brilliant! A solution and an explanation that I understand!

> > 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 :-)
>

We are going from Pembroke (I think) on the 8.15 speed cat thing. So we
will leave home at about 3.00am I think.

Graham
> 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.
> ********************************************************************
>
>
> For more information: http://www.automatedhome.co.uk
> Post message: ukha_d@xxxxxxx
> Subscribe:  ukha_d-subscribe@xxxxxxx
> Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
> List owner:  ukha_d-owner@xxxxxxx
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>