Viewing 15 posts - 1 through 15 (of 29 total)
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...
June 18, 2014 at 6:34 am
3 performs the query:
1) adds counter
2) adds a column Code
3) sorts the three columns
ORDER BY t2.ClientID DESC, t2.Product, t2.StatementID desc
example
ClientID Product StatementID M_Sales
9 SKU1 01/05/2014 1
9 SKU1...
June 18, 2014 at 5:39 am
-- 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...
June 18, 2014 at 4:08 am
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...
June 18, 2014 at 12:55 am
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
June 18, 2014 at 12:04 am
syntax as IIF and CONCAT, as a hint that the server - 2012
June 17, 2014 at 11:13 pm
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...
April 21, 2014 at 2:50 am
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...
April 21, 2014 at 1:29 am
my friends are the same PROFESSIONALS
nobody can import this file?
January 15, 2014 at 11:52 pm
can you change the length of the columns?
please
I changed a few times but have not received
January 15, 2014 at 3:15 am
Viewing 15 posts - 1 through 15 (of 29 total)