Steve Jones - SSC Editor (8/18/2016)

---

Luis Cazares (8/18/2016)

---

We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some...

If you're going to generate the pivot in excel, just query the normalized data and create the pivot there. You can create a view which could be the source for...

We've got new laptops today at the office. Mine is missing SSMS. I guess I'll have to wait to be productive for some days (weeks?)

andrew gothard (8/17/2016)

---

Very briefly:

Full -

allows you to restore to a point in time - say 4 seconds past 5 this afternoon when someone accidentally...

I did test as well.

CREATE TABLE #Test(

Units decimal(10,5),

DesiredResult decimal(10,5),

);

INSERT INTO...

ntreelevel (8/17/2016)

---

This is the custom case statement that I used

case when (units - floor(units)) < 0.49 then round(units,2)

when...

ChrisM@Work (8/9/2016)

---

TomThomson (8/9/2016)

---

It's more...

Brandie Tarvin (8/17/2016)

---

I have apparently...

An additional clause should do the trick.

WITH CTE AS(

SELECT *, ROW_NUMBER() OVER( ORDER BY CASE WHEN seq = @OldSeq THEN @NewSeq

...

What about this?

create table #temp(seq int,step varchar(50))

insert into #temp (seq,step) values (1,'do this first')

insert into #temp (seq,step) values (2,'then do this')

insert into #temp (seq,step) values (3,'finally do this')

insert into #temp...

adam-639168 (8/16/2016)

---

Hello, I have a table where users enter action steps. The SEQ column indicates the step # (step 1, step 2, etc.). I am having trouble updating...

Bison

I'd say that a bad plan is when estimates aren't similar to reality. That would cause choosing the wrong operation.

There's no such thing as a bad operator, there are only...

Jeff Moden (8/16/2016)

---

I've never seen actual minimal logging cause such a thing especially since about the...

Do you mean...