Viewing 15 posts - 4,786 through 4,800 (of 59,067 total)
Yes, 3226. My bad on the typo.
It is a third party backup which I've looked at their documentation to see if there is a setting to prevent writing to...
August 17, 2021 at 9:11 pm
there are LineNo, itemNo and qty fields in one table, I want to the accumulative qty (totalQty) for each item and want to the totalqty shown as below picture,...
August 17, 2021 at 9:02 pm
Phil Parkin wrote:DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);
SELECT @FRDate
,@newFRDate;+1000
Would agree - except the...
August 17, 2021 at 8:49 pm
however dev and test have exactly same databases and application
That never turns out to be the truth. At the very least, they live on different hardware, they have different...
August 17, 2021 at 8:11 pm
With the same Line,subline?
Look at the PK you've chosen. IMHO, only the first 3 columns of InvoiceNbr, Line, and SubLine should make up the PK.
August 17, 2021 at 7:59 pm
The windows teams have a nasty habit of installing SQL Server on the "C:" drive. They have the same nasty habit for the page file, which really needs to have...
August 17, 2021 at 7:52 pm
I have found that just putting that together will often lead to a solution or helps identify the actual issue.
Heh... PREACH IT BROTHER! 😀
August 17, 2021 at 5:46 pm
Answering Post by Jeff
"Two tables (one of existing data, one for new data) would be great."
Are you absolutely sure that you want to include the invoice date and the...
August 17, 2021 at 4:06 pm
DECLARE @FRDate DATE = '20210228';
DECLARE @newFRDate DATE = DATEFROMPARTS(YEAR(@FRDate) - 1, 4, 1);
SELECT @FRDate
,@newFRDate;
+1000
August 17, 2021 at 3:49 pm
First of all, the function you wrote is converting the final output to DECIMAL(10,2) because that's exactly what you told it to do in the RETURN clause of the function.
Second,...
August 17, 2021 at 3:04 pm
... maybe. Testing is your buddy in these circumstances.
Preach it Brother! One good test result is worth a thousand expert opinions.
August 17, 2021 at 12:21 pm
I have a simple proc that I suspect is causing intermittent blocking. It takes a customer ID (int) as a param and returns an output param FeatureFlag (bit) indicating...
August 17, 2021 at 12:19 pm
I've attached 3 functions for this that I needed to build for a project at the end of July. They're fully documented and they include test code for your QA/UAT...
August 17, 2021 at 4:30 am
I guess I would be interested in knowing HOW the numbers of which versions running SQL Server were determined.
Not enough to actually click on the links in Steve's...
August 17, 2021 at 2:26 am
I'm with Frederico on this... I wouldn't try to salvage the old code. The only thing I'd take from the old code is what the overall goals for ALL the...
August 17, 2021 at 2:19 am
Viewing 15 posts - 4,786 through 4,800 (of 59,067 total)