Post reply

GROUP SUM LEN on VARCHAR column and concatenate

  • July 3, 2015 at 10:13 am

    #319517

    Hi all,

    I've got a fairly standard query that does a group by a type column, and then sums the lengths of a VARCHAR column. I'd like to add into that a concatenated version of the string always concatenating in primary key order. Is that possible?

    Thanks for any insight.

  • July 3, 2015 at 11:01 am

    #1810236

    please post CREATE TABLE and INSERT DATA statements for example data. Then, show the query you have built so far and a sample of the desired output of the final solution.

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply