Viewing 15 posts - 841 through 855 (of 13,841 total)
Your code does not result in an error, so that explains why the CATCH block code is not executed.
Or is your question 'Why does this code not generate an error?'
August 17, 2023 at 4:54 pm
To read data from a DB2 database on SQL Server 2017, you can use the Linked Server feature. First, create a linked server using the "sp_addlinkedserver" system stored procedure....
August 17, 2023 at 3:27 pm
As Grantor is a column which is specific to your database, no one here is going to be able to help in any detail without additional information.
But, my assumption is...
August 17, 2023 at 7:57 am
Presumably, you've tried this and it did not work out the way you wanted?
SELECT *
FROM T1
JOIN T2
...
August 15, 2023 at 3:05 pm
Getting started with SSIS is a bit of a learning curve. I recommend you read a few of the stairway articles (link) to help you understand how everything fits...
August 10, 2023 at 7:55 am
Understood. But you mentioned 'SQLJob timings' and I was simply wanting to confirm that you had referred to this in error.
August 8, 2023 at 12:25 pm
Hi Phil,
a) Whether a row is good or not - NOT
b) If a row is considered bad, how should its revised InTime or OutTime be derived? -
August 8, 2023 at 12:22 pm
I checked the SQLJob timings and the times this error occured.It seems to occur at random times.
You mean the Event Viewer, presumably? OK, I don't know what to suggest...
August 8, 2023 at 10:44 am
OK, does it happen randomly, or only at set times?
August 8, 2023 at 10:33 am
Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'? - No, missed punch out for the 28th. I just described two...
August 8, 2023 at 9:07 am
Your expected results ignore rows with InTime from 28-31 May, presumably because these rows are considered 'good'?
But if row 3 (28th) is good, why do you want to use its...
August 8, 2023 at 8:03 am
Is this something which has just started happening? If so, do you have any new jobs running which get data from other sources?
August 8, 2023 at 7:49 am
Hi Can anyone help me with this question? Any help will be appreciated. Thanks.
Welcome to the forum.
Please start a new thread, rather than hijacking this one.
Also, if you want...
July 25, 2023 at 12:27 pm
DROP TABLE IF EXISTS #test2;
CREATE TABLE #test2
(
tran_log_writes VARCHAR(8000) NULL
);
INSERT #test2
(
tran_log_writes
)
VALUES
(N'db1: 245471085 (68491820 kB)');
SELECT t.tran_log_writes
...
July 25, 2023 at 11:15 am
This is easy in SSIS, if you are open to that.
July 21, 2023 at 3:04 pm
Viewing 15 posts - 841 through 855 (of 13,841 total)