Viewing 15 posts - 811 through 825 (of 6,678 total)
If you look at the original post, he checks for month less than 4.
August 17, 2021 at 6:47 pm
good discussion here: https://stackoverflow.com/questions/15138593/nvarchar-concatenation-index-nvarcharmax-inexplicable-behavior
relevant section to this application:
Even without ORDER BY, we do not guarantee that @var = @var + will produce the concatenated value for any statement that...
August 17, 2021 at 6:39 pm
If the installation process is well documented - then anyone can perform the install, especially where the required components for installation have been identified. I have found that most system...
August 17, 2021 at 6:34 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 solution...
August 17, 2021 at 6:27 pm
How do you determine that 2021-01-04 (January 4th, 2021) is the first day of the year? Is that valid for every year - or do other years start on a...
August 17, 2021 at 6:17 pm
Rubber ducky effect is strong for me this morning. Was baffled for the past couple of days as to why the "exact same code" would work in a query...
August 17, 2021 at 1:50 pm
I never change min memory - only set max memory. On a dedicated host for a single instance - SQL Server will grab all memory up to the max memory...
August 15, 2021 at 4:03 pm
Not confusing for me. You have existing data and you have new data. He want's a way to compare the data that changed.
I do absolutely agree that he needs...
August 15, 2021 at 2:32 pm
ZZartin wrote:So ORDER BY CONVERT(datetime, last_activity_date, 3) desc
Now shows error
Invalid column name 'last_activity_date'.
This is because you are trying to convert the 'alias' name - you would need to either:
August 15, 2021 at 2:25 pm
This is confusing - it really isn't clear what you want to accomplish. I am thinking you might want a temporal table - but since you haven't provided the requested...
August 14, 2021 at 4:12 pm
My table as a PK(unique) of:
[InvoiceNbr] ASC, [Line] ASC, [SubLine] ASC, [InvoiceDate] ASC, [ShipDate] ASC
The process that creates the file to load to SQL does a FULL refresh of...
August 13, 2021 at 6:48 pm
thanks for the Response Sean. attaching sample data
No offense mate but not going to pull down an excel document to load up some sample data. Post it as...
August 11, 2021 at 2:05 pm
It’s funny nobody suggested the most obvious choice in such situation - RIGHT JOIN:
Select s.Shipment_No
, p.pkg_no
...
August 6, 2021 at 3:58 pm
Have you enabled 'Optimize for Adhoc Workloads' at the server level?
As for which database - I would identify one or more databases where you can evaluate the application after making...
August 6, 2021 at 2:10 pm
Viewing 15 posts - 811 through 825 (of 6,678 total)