Viewing 15 posts - 646 through 660 (of 6,676 total)
Thanks, I used SSIS to write file locally, then DOS COPY in a .BAT file to move it to the remote server.
Just curious - why not use the built-in...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 4, 2022 at 6:54 pm
Thanks..
Could you crave out a template to get me started?
Sorry - I am not in a position right now where I can write any code. These are all things...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2022 at 9:00 pm
how could I wrap the S/P in Powershell to accomplish that task?
I can think of a couple of ways - pull the full list, loop over each item -...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2022 at 8:56 pm
Would I be able to give each row a Label?
,CASE WHEN datepart(hour, dt.dt_stamp) < 8 THEN 1
WHEN datepart(hour, dt.dt_stamp) < 16 THEN 2
ELSE 3
END as 'HrReported'
Instead of having a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2022 at 8:47 pm
Would I be able to create different output files based on in the SP?
,CASE WHEN datepart(hour, dt.dt_stamp) < 8 THEN ..... Create output file1
WHEN datepart(hour, dt.dt_stamp) < 16 THEN...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 3, 2022 at 8:44 pm
For SSIS - you don't need an execute process tasks if you use WinSCP. There is a .NET component available that can be used in a script task and a...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 2, 2022 at 4:53 pm
I would do this in SSIS - but then again, I have already done this in SSIS so I already have a template available to build a new project. It...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 1, 2022 at 8:51 pm
What problem are you having? I would put that CASE expression in another CROSS APPLY. Then it can be included in the SELECT and the GROUP BY as any other...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
February 1, 2022 at 8:28 pm
any way to make it all done in SP without having to invoke SSIS or Powershell? Dump 3 files based upon the CASE above?
Yeah - you can probably build...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 31, 2022 at 9:58 pm
It would be placed after the End...
I have seen other methods - for example, some will put the semi-colon as the only item on the line:
IF 1...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 31, 2022 at 9:53 pm
You can break it out any way you want - now that you have your datetime column it is just a matter of defining the value. How you go about...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 31, 2022 at 6:12 pm
Sorry - having problems with copying:
Declare @start_date datetime = '20220101'
@end_date datetime = '20220131';
Declare @ts_start bigint = cast(1000 As bigint)...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 31, 2022 at 2:49 pm
I had posted another response - not sure where it went. As I stated before - you should calculate the start/end range of the t_stamp column instead of converting that...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 30, 2022 at 6:23 pm
Looks like there was a copy/paste error - the statements should be:
Declare @current_date datetime = '2022-01-12 10:22:21.183';
Declare @ts_start bigint = datediff_big(ms, '1970-01-01 00:00:00.000', cast(@current_date - 1 As...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 30, 2022 at 5:46 pm
Semicolon is missing before the WITH, ohterwise ok
semi-colon is a statement terminator. Why would you need a semi-colon 'before' the WITH?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 30, 2022 at 5:12 pm
Viewing 15 posts - 646 through 660 (of 6,676 total)