Viewing 15 posts - 3,781 through 3,795 (of 13,855 total)
December 6, 2018 at 8:32 am
eg:
select...
December 6, 2018 at 8:29 am
If you are prepared to install Excel on the server where SSIS is running (I wouldn't), it should be possible using the Sheet.Copy method – in a script task.
December 4, 2018 at 5:34 pm
December 4, 2018 at 5:24 pm
SELECT
l.HTS_99_Num,
L.Ctry_Origin,
T.DutyRate,
T.Chap99,
CASE...
December 4, 2018 at 5:19 pm
December 4, 2018 at 1:37 pm
I...
December 4, 2018 at 11:08 am
PSB - Tuesday, December 4, 2018 10:32 AMIf I change it to 140, will there be any implications ?Thanks,
PSB
Of course. It will...
December 4, 2018 at 10:36 am
PSB - Tuesday, December 4, 2018 10:14 AM. Set at 110
So now you understand the problem, I presume?
December 4, 2018 at 10:20 am
PSB - Tuesday, December 4, 2018 10:10 AM
What is the compatibility level of the database you are working in?
December 4, 2018 at 10:13 am
The problem with these solutions (mine included) is that they don't work :blush: At least not on my instance.
The CTE produces the correctly ordered resultset.
STRING_AGG then appears to...
December 4, 2018 at 8:56 am
December 4, 2018 at 7:44 am
Your kind support in below
Table 1 named Calendar
Table 2 DataBT.
Calendar table in holiday calendar...
December 3, 2018 at 11:45 am
Viewing 15 posts - 3,781 through 3,795 (of 13,855 total)