Viewing 15 posts - 1 through 15 (of 19 total)
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...
February 27, 2019 at 1:52 pm
February 27, 2019 at 3:42 am
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...
February 26, 2019 at 11:00 pm
February 23, 2019 at 4:26 pm
April 18, 2013 at 6:52 am
Thanks very much, i had this working in the past but couldnt remember how I did it or find an answer.
Solved.:-)
April 18, 2013 at 6:28 am
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...
April 18, 2013 at 6:22 am
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)
...
July 4, 2012 at 5:46 am
Thank you. Ill get reading..
July 4, 2012 at 3:25 am
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...
July 4, 2012 at 3:19 am
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,...
July 4, 2012 at 3:02 am
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...
May 31, 2012 at 3:48 pm
🙂
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...
May 31, 2012 at 3:27 pm
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...
May 31, 2012 at 12:23 pm
Viewing 15 posts - 1 through 15 (of 19 total)