SQLTestUser (8/26/2014)

---

Thanks for the quick response, it is for a database server which is hosted but managed internally as of now, and signs are pointing towards giving full control to...

SQLTestUser (8/26/2014)

---

If i am trying to build a business necessity justification for building an in-house DBA, rather than hiring a hosted DBA (one person or team who knows) solution, what...

Great question. Thanks!!!

jkalmar 43328 (8/25/2014)

---

Eirikur, with this test data the expected result set would be:

C1473045850 T1954 3730 ''

C1473045850 T1954 3731 ''

C1473045850 T1954 3732 ...

Something this should work.

select *

from PRE_LOAD

where BatteryID not in

(

select BatteryID

from PRE_LOAD

where LBSTAT = 'NOT DONE'

)

djj (8/25/2014)

---

Burroughs

Jeff Moden (8/23/2014)

---

Actually, there is 😀 ... the first code is both shorter to write and...

sku370870 (8/22/2014)

---

Lynn Pettis (8/22/2014)

---

Sean Lange (8/22/2014)

---

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID

...

sku370870 (8/22/2014)

---

CREATE TABLE #tblTasks

(

TaskID int,

TaskDate...

brad.mason5 (8/22/2014)

---

Not sure if this is what you are looking for. This is assuming OrderID is the correct order you want.

SELECT TaskID

,TaskDate

...

CELKO (8/22/2014)

---

I use the encoding that is being used. The IDENTITY property (not a column!) is the count of insertion...

Take a look at the...

Cathy DePaolo (8/22/2014)

---

I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve performance of...

Snargables (8/22/2014)

---

Recently I got into a discussion w/ a coworker over the primary key of a fact table. He wanted to put the primary key on the identity and I...

Really? What do you use for the PK on lookup tables? I am not by any means saying...