thanks my friend

thanks for your precious time

but why us # RG_SalesOut_Report (test pattern) that it give us?

baseline data about 12 million lines and how you want to write such a...

3 performs the query:

1) adds counter

2) adds a column Code

3) sorts the three columns

example

ClientID Product StatementID M_Sales

9 SKU1 01/05/2014 1

9 SKU1...

-- query1 put filters in the right place

SELECT

ClientID,

[CustomerGroup] = 'All Channels',

StatementID,

Brand,

Product,

[Amount] = SUM(Amount),

[Value_CP] = SUM(Value_CP)

INTO #t1

FROM RG_SalesOut_Report

WHERE [lock] = 0

AND [All...

ClientID CustomerGroup StatementID Brand Product Amount Value_CP M_SALES

988439 All Channels 01.05.2014 Brand 1 SKU 1 2 74,700988 0

988370 All Channels 01.05.2014 Brand 1 SKU 2 2 59,823622 0

988285 All Channels 01.05.2014 Brand 1 SKU 3 1 48,957352 0

988275 All Channels 01.05.2014 Brand 1 SKU 1 1 37,350495 0

988231 All Channels 01.05.2014 Brand 1 SKU 2 1 29,911811 0

988134 All Channels 01.05.2014 Brand 1 SKU 4 1 36,936505 0

988033 All Channels 01.05.2014 Brand 1 SKU 4 1 36,936505 0

988023 All Channels 01.05.2014 Brand 1 SKU 2 3 89,735433 0

987950 All Channels 01.05.2014 Brand 1 SKU 1 1 37,350495 0

987950 All Channels 01.05.2014 Brand 1 SKU...

my server

2014

thank you for participating,

Yes, everything works well alone

but I have to run 4 times

use in their reports query result 4

syntax as IIF and CONCAT, as a hint that the server - 2012

yes 2008

I changed the structure of the procedure

so

created a new parameter @ t2

now works good

Results and got what I want

alter proc trt

@t1 int,

@t2 int

as

delete from...

Friend

1st I delete the table numbers

2 nd inserted number to table numbers with cycle

while(@i < 3442047)

begin

insert into numbers values(@i)

set @i = @i+1

end

3rd select the...

thank you veruy much

my friends are the same PROFESSIONALS

nobody can import this file?

made but received nothing

can you change the length of the columns?

please

I changed a few times but have not received

THANK YOU VERY MUCH