Viewing 15 posts - 1,801 through 1,815 (of 10,144 total)
silverbullettruck (2/1/2016)
ChrisM...in your solution, if there were additional possible values in the Attribute column, would you need to have an OUTER APPLY for each of the possible attribute values?
Possibly not....
February 1, 2016 at 9:13 am
SELECT t.RBR, t.Value, x.Value
FROM #Test t
OUTER APPLY (SELECT ti.Value FROM #Test ti WHERE ti.RBR = t.RBR AND ti.Attribute = 'CRE') x
WHERE t.Attribute = 'XLOC'
GROUP BY t.RBR, t.Value, x.Value
February 1, 2016 at 7:44 am
As Phil has pointed out the performance of this code will be poor. Can you post the code for function dbo.isarbeitstag? Does it reference a calendar table?
February 1, 2016 at 7:34 am
SQL006 (1/31/2016)
This is just the scenario i created, In production there is no temporary table #Test only physical table which consists of 2 million data....
February 1, 2016 at 1:29 am
Luis Cazares (1/29/2016)
SELECT Id,
Amount,
CashFlowDate
FROM #Test
CROSS APPLY( VALUES(Principal, 'Principal'), (Interest, 'Interest')) x(Amount,AmtType)
WHERE...
January 29, 2016 at 9:16 am
Koen Verbeeck (1/29/2016)
Apparently got over 15,000 points today. Yay. :w00t:
What? In one day? Fingers on fire!
January 29, 2016 at 9:07 am
You could use row constructors for this too:
SELECT
t.Id,
x.Amount,
t.CashFlowDate
FROM #Test t
CROSS APPLY (
VALUES
(CASE WHEN t.CashFlowDate between '2016-01-01' AND '2016-01-05' THEN t.Principal ELSE NULL END),
(CASE WHEN t.CashFlowDate between...
January 29, 2016 at 5:55 am
SELECT
t.Id,
x.Amount,
t.CashFlowDate
FROM #Test t
CROSS APPLY (
SELECT [Amount] = CASE
WHEN t.CashFlowDate between '2016-01-01' AND '2016-01-05' THEN t.Principal ELSE NULL END
UNION ALL
SELECT [Amount] = CASE
WHEN...
January 29, 2016 at 5:43 am
Ed Wagner (1/27/2016)
January 28, 2016 at 1:51 am
Grant Fritchey (1/27/2016)
ChrisM@Work (1/27/2016)
Grant Fritchey (1/27/2016)
ChrisM@Work (1/27/2016)[hrMy jaw hit the floor when I read the last paragraph. No support for cross-database queries? Two databases on the same "instance" isn't allowed...
January 27, 2016 at 7:34 am
Grant Fritchey (1/27/2016)
ChrisM@Work (1/27/2016)[hrMy jaw hit the floor when I read the last paragraph. No support for cross-database queries? Two databases on the same "instance" isn't allowed or the two...
January 27, 2016 at 5:34 am
GilaMonster (1/27/2016)
ChrisM@Work (1/27/2016)
Two databases on the same "instance" isn't allowed or the two databases can't reference each other using three-part naming?
With Azure SQL DB, there's no such thing as...
January 27, 2016 at 3:01 am
Hugo Kornelis (1/26/2016)
Grant Fritchey (1/25/2016)
Hugo Kornelis (1/25/2016)
Grant Fritchey (1/25/2016)
What blockers...
January 27, 2016 at 2:02 am
mw112009 (1/25/2016)
Please see attached.
The highlighted field represents my PC name.
All this time I have been connecting to other servers. This time I thought I will have something locally on my...
January 26, 2016 at 2:35 am
ben.brugman (1/25/2016)
Luis Cazares (1/25/2016)
Another option:
SELECT UPPER( REPLACE( CONVERT(char(11), GETDATE(), 106), ' ', '-'))
Be carefull with dates, very often the language or the regional settings are important.
For the solution of Luis...
January 25, 2016 at 9:17 am
Viewing 15 posts - 1,801 through 1,815 (of 10,144 total)