Viewing 15 posts - 676 through 690 (of 6,036 total)
Why use SSIS?
It's one of the worst possible choices.
Unless it's some kind of test question.
But then it's for you to answer.
February 26, 2018 at 3:36 pm
And there is a couple of comments about your data.
1. Using FLOAT data type for Amount is quite questionable.
One of DECIMAL data types would be more appropriate.
February 25, 2018 at 10:28 pm
Yes, my JOIN condition did not include te case when OUTE renge covers more than 1 DIN range.
The correct "range overlap" condition would be
February 25, 2018 at 10:21 pm
Agreed that they're wrong if the rows are based on user clicks. Not seeing anything like that in the original request, though. Are you sure the data is based on...
February 20, 2018 at 1:48 am
The request, and consequently all the solutions provided, are wrong.
The nature of requirements has nothing to do with sequence numbers.
Between 3:20am and 4:15 am a user may click on the...
February 19, 2018 at 7:55 pm
Then we can join these aggregations by the overlapping amount ranges within the same ID's:
select *
FROM (
select D.*,
A.AllocatedAmount - D.AMOUNT PreviouslyAllocated,...
February 19, 2018 at 4:25 am
Nobody picked this up while I was away, so getting back to it.
First things first.
You need to change your tables design a bit.
The business logic of...
February 19, 2018 at 3:56 am
Should save a lot of time and efforts for hackers.
February 17, 2018 at 5:25 am
Hi,
What is the logical connection between DIN.LOGI and OUTE.LOGI ?
February 14, 2018 at 6:53 pm
Listen to what Scott said - the column which is used for range selection (e.g. BETWEEN ) must be the 1st column in the clustered index.
Everything else would be a...
February 13, 2018 at 12:40 am
Proper name for a book about all the data scientist tools:
"Blunt tools for dummies".
If you think about it - >90% of the operations they do is a waste of time...
February 11, 2018 at 4:18 am
1st - add an identity column to your staging table.
You need a way to distinguish between different duplicate rows.
2nd, use that staging ID in Error table instead of its...
February 4, 2018 at 3:50 am
If DeliveryDt contains (will possibly ever contain) a time portion (the data type DATETIME would allow that) then the condition
And DeliveryDt <= '$LASTDAYOFMONTH' will omit all deliveries from the...
February 1, 2018 at 7:52 pm
No, It is true.
You mentioned issues EOM brings with it, but there is nothing to show as it's advantage against BOnextM which could compensate for those issues.
January 27, 2018 at 8:34 am
How do you define which value goes into dat1, which one into dat2 and which one into dat3?
January 27, 2018 at 5:58 am
Viewing 15 posts - 676 through 690 (of 6,036 total)