Viewing 15 posts - 1 through 15 (of 61 total)
Could also check logon trigger.
September 19, 2021 at 11:36 am
I'm sorry, but I think that I'm misunderstanding something. In your results you updated the record that has replacementCode 860, but according to my understanding from your explanation, it should...
September 19, 2021 at 6:06 am
Are you running the select * statement from the same process that locks the records? If so, the select * statement should return all the records from the table, because...
September 12, 2021 at 6:19 am
Here is one way that does it:
declare @t table (name varchar(50))insert into @t (name) values ('ARANESP 100MCG PFS SOLD BY THE'),('ARANESP 200MCG PFS SOLD BY THE'),('ARANESP 40MCG...
August 19, 2021 at 2:59 pm
select iif(len(first_name) > 10, concat(SUBSTRING(first_name, 1, 10),'...'),SUBSTRING(first_name, 1, 10)) as first_name from @t1
August 19, 2021 at 7:28 am
I think that this update should do it:
update #testset AmountAll = Amount * NumDayswhere NumDays > 0go
August 18, 2021 at 7:52 am
The ring buffer stores the information only in memory and does not store it also in a file. There are some problems with ring buffer. The first problem is that...
August 17, 2021 at 7:51 am
I don't think that creating a covering index will help you. Since you are using the clustered primary key as your search argument, you are not doing any lookup. Are...
August 17, 2021 at 7:04 am
Many of comments to reply, so I'll just write my comments for all of them, on this message.
It is nice and amusing to read slogan such as “Those who know...
August 17, 2021 at 6:40 am
I will always prefer someone that spends also time in participating in such discussions then someone that doesn't participate.
You mean like virtually everyone on StackOverflow where such...
August 16, 2021 at 6:51 am
Welp, it seems worthwhile mentioning reputation points in an online forum, i.e. Stack Overflow, are a good way to enhance your resume.
They're also a good way to...
August 15, 2021 at 6:53 am
SELECT DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) % 7, [Order Date]) AS [Week of], COUNT(*) AS CountFROM dbo.your_table_nameGROUP BY DATEADD(DAY, -DATEDIFF(DAY, 0, [Order Date]) %...
August 15, 2021 at 6:40 am
I know that it is a shot in the dark, but did you check if the table was drop and recreated between the time that you dropped it and created...
August 10, 2021 at 6:00 am
As other wrote without the code there is no way to help you.
Also I agree with Jcelko212 that the keys should be taken from the table and not be computed...
July 20, 2021 at 7:11 am
I don't think that the server is creating new column to an existing table as sparse columns. Creating column as sparse columns has a big effect on the storage...
July 20, 2021 at 6:59 am