Thanks folks, I bet you're glad everyone's not as stupid as me 🙂

cheers, yogi

Hiya,

thanks for the reply.

It makes a joyous change to realise that I am on the right track for once 🙂

Cheers,

...

Sweet,

Thanks. yogi

Howdy,

Thanks folks, they all work great.

One thing though..

I was advised to

“ use Query Analyzer and turn stats on / exec plan on to see which might be more efficient”

I...

Hi Frank,

thanks for the reply.

yes, I use these tables often.What I don't understand is, why if I run the SAME update statement multiple times on the SAME table,

eg.

UPDATE tblStoreProfile

SET...

Hi buddy, I went for the “trigger” option.Cheers for the advice.

I created a trigger on tblStoreProfile, that will update s.storeName if the

Value of p.isBigStore is changed.

I am new...

Hi SJ,

magic.It's the breakthru I was needing.I'm now in the process of running queries which return all the products that compose the main product.

Many, many thanks to yourself and also...

Hi SJ, that's a great relief to know that I am getting there.Thanks for the help.If you do manage to get time to post a small example, I'd really appreciate...

Hi SJ,

Thanks for the reply.I think I am following.

Eg, if I had a part, partId 1, which was made up of 2 other parts,

Eg, partId 2 and partId...

Hi SJ,

Thanks for the reply.I have studied the example but am still a bit confused.I have included my questions next to your post.I hope you don't mind. 🙂

In fact...

Sorry folks, I accidentally posted the reply twice. yogi

Hi Darren,

Thanks for the reply.

I have created a table tblProductComponent

It has the following fields

tblProductComponent

baseProductId (references tblProduct.baseProducId)

componentProductId (references tblComponent)

So I can now run...

Hi Darren,

Thanks for the reply.

I have created a table tblProductComponent

It has the following fields

tblProductComponent

baseProductId (references tblProduct.baseProducId)

componentProductId (references tblComponent)

So I can now run...

Hi Chris,

thanx bud.

nice to hear that I could be doing something right 🙂

skol,

yogi

Hi NPeeters,

I've done that and I now have SQL Server working.Thanks a lot for that.

Yogi