Viewing 15 posts - 736 through 750 (of 10,144 total)
Why did you change the query to dynamic? There's a potentially very good reason...
Here's the query formatted for readability. I'm not prepared to go any further with this,...
May 19, 2017 at 6:31 am
-- I find it helps to preaggregate the table down BEFORE the pivot.
-- it's a visual thing - it's easier to see what's going to happen.
May 19, 2017 at 6:10 am
Thanks for showing interest to understand the query. But unfortunately being SOX audited application,...
May 19, 2017 at 1:53 am
May 18, 2017 at 1:43 am
May 17, 2017 at 9:57 am
May 17, 2017 at 9:44 am
May 17, 2017 at 9:35 am
SELECT y.min_d, y.max_d, CASE May 17, 2017 at 9:31 am
I created a large temp table and I'm able to query it just fine...
May 17, 2017 at 9:11 am
Apologies,
For 2017-04-27 date having two schedules that is 17:00 and 23:00 , 17:00 is executed...
May 17, 2017 at 8:48 am
May 17, 2017 at 8:31 am
May 17, 2017 at 8:14 am
Something like this:SELECT cus.CompanyName, kc.SalesItemId,
SUM([Solgt i perioden KG]),
SUM([Ultimo lager KG]),
SUM([Primo lager KG]),
SUM([Købt i perioden KG]),
SUM([Solgt i perioden KG])
FROM [dbo].[CustomerSetup] cus
LEFT JOIN...
May 17, 2017 at 8:08 am
You're writing a "dynamic cross-tab query". It's well-documented and very well studied.
To begin with, can you write the query you would need for just the first percent column,...
May 17, 2017 at 8:02 am
Viewing 15 posts - 736 through 750 (of 10,144 total)