Viewing 15 posts - 16 through 30 (of 279 total)
sometimes two or more steps come into table on same day. As we load data from files. So the above query does not work. 🙁
May 8, 2019 at 2:19 pm
Lynn- My view is the same as yours. But question was if i have the package with such three different dataflow tasks , how you design it to schedule. I...
April 19, 2019 at 7:58 pm
March 14, 2019 at 8:06 am
September 20, 2018 at 10:14 am
August 8, 2018 at 12:13 pm
August 6, 2018 at 2:41 pm
August 6, 2018 at 1:41 pm
Here is a solution that works.
WITH C1 AS
(
SELECT *, MAX(ISNULL(HoldEndDate, '9999-12-31')) OVER(PARTITION BY...
August 6, 2018 at 12:43 pm
August 1, 2018 at 12:56 pm
June 29, 2018 at 2:33 pm
June 29, 2018 at 1:24 pm
Viewing 15 posts - 16 through 30 (of 279 total)