Viewing 15 posts - 1,756 through 1,770 (of 7,616 total)
This statement:
ALTER DATABASE [MYDB] SET ALLOW_SNAPSHOT_ISOLATION ON
causes the db to start snapshot processing -- adding 14 bytes to each row and storing any needed row versions in tempdb -- and...
March 29, 2021 at 10:21 pm
SELECT
issuedate, replydate,
CASE WHEN replydate IS NULL AND DATEDIFF(DAY, duedate, GETDATE()) > 0
THEN DATEDIFF(DAY,...
March 29, 2021 at 10:04 pm
DECLARE @date1 date
DECLARE @date2 date
SELECT ...
...
CROSS APPLY (
SELECT dbo.fnGetSeconds(@date1) AS date1_secs,
dbo.fnGetSeconds(@date2) AS date2_secs
) AS alias1
...
March 29, 2021 at 3:48 pm
My preferred approach is to use a CROSS APPLY to assign an alias name to the computation. That name can then be used in any other clause in the SELECT,...
March 29, 2021 at 3:15 pm
Should use the new file just fine. Make sure the new file is present, or you will have no space to write to.
What's happening is this. Your file has not...
March 29, 2021 at 1:59 pm
Try SELECT too rather than PRINT, since SELECT can show more chars than PRINT. Also, be sure to adjust the options in SSMS to show the max chars possible.
March 29, 2021 at 1:49 pm
I
Don't worry about ms, just use seconds. A few ms diff could be caused by almost anything is and not significant for an SSIS package.
I have to...
March 29, 2021 at 1:47 pm
Don't worry about ms, just use seconds. A few ms diff could be caused by almost anything is and not significant for an SSIS package.
March 29, 2021 at 4:47 am
An ORDER BY either has an OFFSET clause or it doesn't. There is no "sometimes it does, sometimes it doesn't".
In this structure, rather than use 0 for the count, could...
March 25, 2021 at 8:07 pm
Sorry, thought I changed it to jma.... (which I'll now do in my orig post as well). But I'm assuming that such a column exists just because or your comments...
March 25, 2021 at 5:44 pm
Seems like the table must be empty.
Make sure you are in the correct db.
A long shot, but you should always put the schema name on the table anyway, for performance...
March 25, 2021 at 4:49 pm
Here's my best guess at what you're trying to do.
SELECT
JO.jmoJobID, JA.jmaPartID, JO.jmoWorkCenterID,
JO.jmoProcessID, JO.jmoOperationQuantity,
...
March 25, 2021 at 4:16 pm
For a little disk space, you can create staging tables in DB2. Load to the staging tables. You then don't need a separate back up of the original tables because...
March 23, 2021 at 6:49 pm
I believe it's because you're doing "MAX" but the value is a string not a number. Therefore '9' is greater than '10', or '1', so '9' becomes the MAX value. ...
March 23, 2021 at 5:31 pm
If they log into SQL initially as themselves, ORIGINAL_LOGIN() might give you their own name rather than the generic name. It may not, but it's worth a try first.
March 23, 2021 at 3:42 pm
Viewing 15 posts - 1,756 through 1,770 (of 7,616 total)