Scott thank you so much, i have been messing with this all day trying multiple cross joins and then trying to filter the results with a where =.

in...

I have another file I am trying to import all is fine using your methods but there are multiple repeating child entries <Description> see file below but Wish to only...

Thankyou both

Scott Coleman and Jonathan Szeto for your replies.

I...

Thanks everyone for you input

@s_osborne2 i will bear this in mind

thanks again

John.

Thanks very much, i had this working in the past but couldnt remember how I did it or find an answer.

Solved.:-)

Product ID is an integer but im trying to add a string to it. I can change it to a varchar if needed as there isnt that many products so...

Got it working thanks for the direction here is the script i used

DECLARE @Product_ID INT

DECLARE Product CURSOR

FOR SELECT Product_ID

FROM dbo.table

OPEN Product

declare@Paths varchar(128) ,

@FileName varchar(128),

@FileExtension varchar(128)

...

Thank you. Ill get reading..

I changed the code to do that however it just returns one answer can you spot anything wrong ?

Thanks for you help its much appreciated, this has been driving me...

Thanks SSCrazy Eights makes sense knew it wouldnt be that easy . however im trying to pull back all values for a column and run through all of them,...

Thanks Sean, Ill be back on my server in the morning so Ill try to post it up then.

Thanks for helping this had been driving me mad for a couple...

The script above works fine and returns the results I need for one category (73) but I would like the results for lots of categories so instead of just inserting...

Hi Sean thanks again for earlier it got me on the right track.

I actually needed to find all the category id's going the other way so I had a look...