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...
June 5, 2017 at 2:37 am
Did you try the LEFT JOIN approach?
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.
June 2, 2017 at 1:13 am
June 1, 2017 at 11:36 pm
June 1, 2017 at 11:22 pm
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.
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...
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...
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...
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...
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.
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...
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...
May 23, 2017 at 6:30 pm
1700+ user transactions - what does it mean?
Ped day, per hour, simultaneous?
May 23, 2017 at 1:13 am
Viewing 15 posts - 841 through 855 (of 6,036 total)