Concatenate a specific cell value in another column

[ferchops1987]

Hello,

I have the next table to record when a customer changes from one service to another one.

DDP_DATAALTA = Registration date

DTE_SERVEI_ANTIC = Old service

DTE_SERVEI_NOU = new service

DTE_DATA_MODIF = Modification date

I need to get the first service and the registration date in order to concatenate these values like this:

Finally I want to get something like this (concatenate the last two column with the first service (95) and the registration date as Start Date:

Start date	Service	Comments
05/07/04	95	This is the registration date and the first service from the column DTE_SERVEI_ANTIC.
23/09/08	1000076
16/05/14	118
12/02/15	1000076
19/03/15	118

Once I get this table, I will construct a period table.

I will appreciate so much your help. I tried to achieve this without success.

[tomasz_tru]

Could you translate this one question into english?

Tomasz

[ferchops1987]

I’ve translated it! Thank you 

[tomasz_tru]

I don't fully understand the desired output, but I would find first transaction on the SQL server side using OVER statement...