Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004

    Unanswered: retrieving only 50 chars from a detail table

    Hello everyone -

    I have a detail table of comments. I need to grab the fist 50 characters from the comment field from this table. The kick is that I need to get the comments from all of the records in the detail table, as the comments might be less than 50 characters, so i need to pull the comments from the other comment records that apply to the master table record.

    right now i have the comments in a join to the master table, but this is causing a few records to be returned....

    I guess what i am looking for is a way to grab the comment value from the first record of the detail table.


  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    Try this:
    SELECT Master.Id,
    	LEFT((SELECT LTRIM(RTRIM(Details.comments)) + ' ' 
    		FROM Details
    		WHERE Master.Id = Details.MasterId
    		ORDER BY Details.seqNr
    		FOR XML PATH('')
    		), 50) AS Comments
    FROM Master
    GROUP BY Master.Id ;
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts