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...

ClientIDCustomerGroupStatementIDBrandProductAmountValue_CPM_SALES

988439All Channels01.05.2014Brand 1SKU 1274,7009880

988370All Channels01.05.2014Brand 1SKU 2259,8236220

988285All Channels01.05.2014Brand 1SKU 3148,9573520

988275All Channels01.05.2014Brand 1SKU 1137,3504950

988231All Channels01.05.2014Brand 1SKU 2129,9118110

988134All Channels01.05.2014Brand 1SKU 4136,9365050

988033All Channels01.05.2014Brand 1SKU 4136,9365050

988023All Channels01.05.2014Brand 1SKU 2389,7354330

987950All Channels01.05.2014Brand 1SKU 1137,3504950

987950All Channels01.05.2014Brand 1SKU...

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