Another possibility is, assuming that:

(1) column avol was NULL before this UPDATE

(2) your server still has the default FILLFACTOR 0f 0 (=100)

Then this UPDATE could a lot of leaf...

I didn't use it, but once I did a code review to one of out developers.  The code wasn't a good code, so I called him and explained what is...

We can also run a code that shows that SQL Server caches the temporary table and doesn't drop it.  If you'll run the code bellow (pleas run it on a...

One nice trick that I learned from Brent Ozar is to create a table for each publication that has only one row and one column of datetime datatype.  Have a...

It looks like  DENSE_RANK function will work for you.

Adi

You can use a CTE that first sums up the data according to the date, and then run the query on the CTE:

create table main3( saleddate date,...

you can use the sum function with over clause.  Here is an example that is based on your script:

--create thet table
create table main3( saleddate date, sales_count int)
go

--insert...

Unfortunately I believe that most places don't even bother to go over our time tracking reports.  Few years ago my brother worked in a big company and made a bet...

• This reply was modified 2 years, 11 months ago by  Adi Cohn.

SSMS shows you the matching parenthesis when your cursor is on the matching parenthesis.  Some times it is hard to see it, so you can configure it to use a...

Why are you storing date as numeric data type?  You should store it as what it is and compare it to the same data type instead of a numeric data...

If I understand what you wrote, you already get the wrong data in the CSV file.  If this is so, then all the modification that you'll do for the import...

From my experience almost all times that I had databases that were stuck on recovery pending, someone messed up with the storage and SQL Server was not able to find...

Format function does not change the calculation.  It takes the results of the calculation and then modify the format.  In your case all the columns in you expression are integer,...

Could also check logon trigger.

Adi

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...