Viewing 15 posts - 5,521 through 5,535 (of 13,876 total)
= (DT_DATE) DATEADD("DAY",...
June 19, 2017 at 12:42 pm
SELECT DATEADD(dd, DATEDIFF(dd, 0, GETDATE()) - 1, 0);
Change -1 to -2 for day before yesterday.
June 19, 2017 at 12:16 pm
For file operations, I would normally expect to see a File System Task or a Script Task being used. Why are you calling an executable to do this?
June 19, 2017 at 10:43 am
June 18, 2017 at 8:26 am
Please read Chris' post again, particularly this:
For the main part of the query, start with hard-coded for testing then recode to dynamic sql when you're done.
He's giving...
June 16, 2017 at 9:10 am
June 16, 2017 at 6:20 am
June 16, 2017 at 6:14 am
Duplicate post. Answers here please.
June 16, 2017 at 6:06 am
June 16, 2017 at 6:05 am
This is going to help a lot of people, I am sure. Well done on making the effort to document everything.
June 15, 2017 at 9:59 am
I need to create and attach a password to protect the Excel files generated by...
June 15, 2017 at 9:21 am
June 15, 2017 at 8:50 am
Thanks. John's version should work as well and may perform better, so you may like to check that.
June 15, 2017 at 8:37 am
As you can see, my query below displays the revenue by name for those...
June 15, 2017 at 8:16 am
June 15, 2017 at 6:06 am
Viewing 15 posts - 5,521 through 5,535 (of 13,876 total)