Viewing 15 posts - 841 through 855 (of 6,036 total)
Type 2 SCD would involve some kind of time stamp indicating the the date of change.
So, marking "expired" product versions as deleted would not be a problem at all.
It seems...
_____________
Code for TallyGenerator
June 5, 2017 at 2:37 am
Did you try the LEFT JOIN approach?
_____________
Code for TallyGenerator
June 2, 2017 at 8:32 am
You're gonna need ROWNUMBER to the SELECT part (ordering by start date) and then do cross tab query on top of it.
_____________
Code for TallyGenerator
June 2, 2017 at 1:13 am
_____________
Code for TallyGenerator
June 1, 2017 at 11:36 pm
_____________
Code for TallyGenerator
June 1, 2017 at 11:22 pm
_____________
Code for TallyGenerator
June 1, 2017 at 11:12 pm
Can you explain the logic in records for PersonID 2 and 3?
They seem like contradicting each other.
_____________
Code for TallyGenerator
June 1, 2017 at 11:02 pm
This query would perform much better:SELECT t.nArticle_Id,
t.nRev_Id,
isnull(pt.dEnd,t.dStart) Start,
t.dEnd
FROM @tData t
outer apply (select top 1 dEnd from @tData p
where p.nArticle_Id = t.nArticle_Id...
_____________
Code for TallyGenerator
June 1, 2017 at 12:47 am
It's a quick hack that people have used because it has worked.
It's not quite a hack.
All date-time manipulation a in Excel are built on this "hack".
It's rather an architectural approach:
Numerical...
_____________
Code for TallyGenerator
May 30, 2017 at 7:29 pm
The main reason my company went with SSIS is that my boss doesn't like linked servers.
Use OPENQUERY, OPENROWSET, etc.
Same connection using the same driver.
Except - it's only 1 connection...
_____________
Code for TallyGenerator
May 25, 2017 at 3:14 pm
Can you please put those tips here please if that is okay.
There are several books filled with those tips.
Which one do you want to put in this thread? 🙂
You can...
_____________
Code for TallyGenerator
May 24, 2017 at 6:28 pm
Default max - means "take everything".
You need to define how much memory you need for OS, Web server, SSIS and allow the remaining memory for SQL Server to take.
_____________
Code for TallyGenerator
May 24, 2017 at 12:10 am
Not to mention that the original request was lame.
3.3 not equal to 3.30
10/3 = 3.3 - correct
10/3 = 3.30 - wrong.
Number of decimals to be displayed is defined not by...
_____________
Code for TallyGenerator
May 23, 2017 at 7:50 pm
Anyone in the mood for talking about RAM requirements while remaining tight-lipped about the use of NOLOCK? Here you go.
Apparently, there is nothing wrong with NOLOCK.
It's inbuilt in in-memory...
_____________
Code for TallyGenerator
May 23, 2017 at 6:30 pm
1700+ user transactions - what does it mean?
Ped day, per hour, simultaneous?
_____________
Code for TallyGenerator
May 23, 2017 at 1:13 am
Viewing 15 posts - 841 through 855 (of 6,036 total)