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.
_____________
Code for TallyGenerator
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.
Code for TallyGenerator
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
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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,...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
February 19, 2018 at 3:56 am
Should save a lot of time and efforts for hackers.
_____________
Code for TallyGenerator
February 17, 2018 at 5:25 am
Hi,
What is the logical connection between DIN.LOGI and OUTE.LOGI ?
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
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?
_____________
Code for TallyGenerator
January 27, 2018 at 5:58 am
Viewing 15 posts - 676 through 690 (of 6,036 total)