I've changed data with this it is no good. Logic must be the same for all options

Try your solution with this data

INSERT INTO @test-2 VALUES

(1,2010001,'20150101','xxx',0, 30),

(2,2010001,'20150201','yyy',70, 0 ),

(3,2010001,'20150301','kkk',0, 60...

Thank you

View fourth answer and tell me your opinion

What do you think about this:

DECLARE @t1 TABLE (

CODE nvarchar(20),

COLUMN1 numeric(18, 2),

COLUMN2 numeric(18, 2)

)

INSERT INTO @t1 (CODE, COLUMN1, COLUMN2)

VALUES ('432', 0,...

I have update schema and i upload image with my desire result. I realized I need this result.

CREATE TABLE #NONAMETABLE(

sinGroup NVARCHAR(10)

,column1 INT

,column2...

No, this is my starting point:

CREATE TABLE #NONAMETABLE(

ID INT

,column1 INT

,column2 int

);

INSERT INTO #NONAMETABLE(ID,column1,column2) VALUES

(1,100.00,40)

;

drop table #NONAMETABLE

T- SQL

You need to do something like this

Select a,b,c from x

union all -- ALL doesn't filter dups and is faster

Select d, e, 'c' as f from y

Thank you very much!

Yes this is good. But what if i have input data in first column without '-'. Like this

CREATE TABLE #accounts (

AccountCode NVARCHAR(10),

...

I have edit my question.

I looked grouping set and I wrote this..

with data as (

select ACCOUNTCODE, substring(ACCOUNTCODE, 1, len(ACCOUNTCODE) - 1) as Prefix, accountName, Total...

I have edit my question