Welcome to Sign in | Help

Select continand un group by si o concatenare de stringuri

  •  08-10-2009, 4:53 PM

    Select continand un group by si o concatenare de stringuri

    Salut,

    Pt a fi mai usor inteles o incep direct cu exemplul:
    - am un tabel care are 2 coloane A si B de tip nvarchar
    - datele din tabel:
    -------------------------------
    A B
    xxx1 yyy1
    xxx1 yyy2
    xxx1 yyy3
    xxx2 jjj
    -------------------------------
    - printr-un select as dori sa obtin urmatoarea informatie:
    -------------------------------
    xxx1 yyy1,yyy2,yyy3
    xxx2 jjj
    -------------------------------
    Multumesc
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems