Viewing 8 posts - 1 through 9 (of 9 total)
Hmm... No replies... maybe I'm not explaining this simply enough. Think of this problem this way... Let's say I have a folder table that looks like this:
FolderID ParentID FolderName
1...
December 10, 2008 at 10:23 am
FROM FolderStructure as fs
INNER JOIN Process AS p ON fs.FolderID = p.ProcessFolderID
INNER JOIN TestStep T ON P.ProcessID= T.ProcessID
order by Level
I added this line and it...
December 9, 2008 at 9:59 am
That worked! Thank you so very much!!! :w00t:
December 9, 2008 at 8:43 am
ha ha! I figured it out! here's how I solved it!
SELECT TOP 10 PERCENT MAX(CASE AttributeListID WHEN 7 THEN ItemValue + ', ' ELSE '' END)...
December 4, 2008 at 4:13 pm
I've also been able to get the right details by doing it this way
SELECT MAX( CASE AttributeListID WHEN 34 THEN ItemValue + ', ' ELSE '' END ) +...
December 3, 2008 at 2:54 pm
But when I use ali.ItemValue + char(13) I get this
Functional Test Integration Test Load Test Regression Test Security Test Stress Test System Test
hmm... the formatting didn't come through...
December 3, 2008 at 1:41 pm
Alright! I'm making progress! Using your suggestions, I opted to use the For XML Path and it is almost working. I just need someone to help out...
December 3, 2008 at 1:36 pm
Interesting... I tried the example shown and am getting an error with it. Here's my query
SELECT
p.processID,
Text = substring(SELECT ( ', ' + ali.ItemValue)
...
November 26, 2008 at 3:59 pm
Viewing 8 posts - 1 through 9 (of 9 total)