If the performance improvement is almost immesurable, why do we have NOLOCK/READ UNCOMMITED?

Basically, they're useful when we want an approximate result of a changing data set. These cases happen and...

Here's a possible solution. I included the full DDL and added some sample data. Take a look and ask any questions that you might have.

DECLARE @test-2 TABLE

(

AccountID INT,

Datekey INT,

RunningTotal INT

)

DECLARE...

a4apple (6/30/2015)

---

Luis Cazares (6/30/2015)

---

I was exactly going to suggest the @Points table because I had to use a triangular join which might cause problems.

Using your new Points table, here's a...

I was exactly going to suggest the @Points table because I had to use a triangular join which might cause problems.

Using your new Points table, here's a possible solution. I...

Congratulations Alan! Enjoy her as much as you can.

So that's what the office needs. 😀

That makes absolutely no sense.

How does that reflect your data? Your problem is with the relation between 2 tables and you post only one without significant data types.

Please post what I asked you to in the previous post. I can't figure out what you want. I'm sure that you have it very clear, but you might be...

Mostly what Sean said. I just wanted to add that if you want to be sure that you're not losing data, you can do some checks before changing the datatype.

That's weird Sean, I would be more scared of rar files.

About the solution, I'm not sure if you got confused with the dates because the values with zero hours don't...

If you're lost, imagine us that only have a piece of code.

Why are you joining the table twice and then using it in subqueries within the CASE?

Can you post DDL...

Is that ntext to nvarchar(MAX)?

I got it wrong because figured out that NEWID() was the only one that would show different results if called more than once in the same row. Also because I...

gazy007 (6/26/2015)

---

Hi ,

Sorry and I am grateful for your help and something I have never understood about aggregate probelm

SELECT

ca.AccountNumber , CompanyName, Value,

SUM(...

jasona.work (6/24/2015)

---

Why, oh why does it have to be such a nice day out, and me stuck here at work...

I've gone for a walk around the campus to try to...