Home Forums SQL Server 2005 Development Problem segregating third occurence from a column RE: Problem segregating third occurence from a column

  • May 7, 2009 at 10:16 am

    #990481

    rayash16 (5/7/2009)

    Thanks guys for such a quick response,

    actually the function might work,i used some myself .

    the problem is the result set has to use a group by because i need to spit the address column for each customer.

    And i want to run that on the table so that i can get the segregation for each customer in the table.

    i will appreciate it

    thanks

    That will require additional work from you. We would need the DDL for the table(s), sample data (in a readily consumable format), expected results based on the sample data.

    You can get help with this by reading the first article I reference below in my signature block.