ramana3327 (2/24/2015)

---

Hi,

Currently, working with SQL backups.

I am looking for the route cause of slow backups. Our current environment is 208R2. We have a database around 450GB. Our current backup...

Interesting one. I've never done it, so I learned something today. Thanks.

Core

SQLRNNR (2/23/2015)

---

ssimmons 2102 (2/23/2015)

---

https://msdn.microsoft.com/en-us/library/gg492088.aspx

says it was introduced in 2012, however the other correct choices are for 2014 version, figuring it might be a trick question I selected 2012. ...

Top

I liked the statement that kids don't want to learn to program...they want to do stuff. This is so very true. Learning to program for the sake of...

No problem.

spaghettidba (2/23/2015)

---

As far as your query is concerned, this should do:

SELECT S.supplier_id, S.supplier_name, COUNT(DISTINCT A.agent_id)

FROM Suppliers AS S

INNER JOIN Supplies AS SU

ON S.supplier_id = SU.supplier_id

INNER JOIN Agents AS A

ON SU.product_id...

djj (2/23/2015)

---

Ed Wagner (2/22/2015)

---

TomThomson (2/20/2015)

---

Ed Wagner (2/20/2015)

---

crookj (2/20/2015)

---

Ed Wagner (2/20/2015)

---

djj (2/20/2015)

---

Ed Wagner (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Flame...

Lynn Pettis (2/22/2015)

---

Ed Wagner (2/22/2015)

---

Lynn Pettis (2/21/2015)

---

... Mark one off, 6 days on the calendar to go. 6 days on the calendar to go, 6 days to go, ...

And for...

TomThomson (2/20/2015)

---

Ed Wagner (2/20/2015)

---

crookj (2/20/2015)

---

Ed Wagner (2/20/2015)

---

djj (2/20/2015)

---

Ed Wagner (2/20/2015)

---

SQLRNNR (2/20/2015)

---

Ed Wagner (2/20/2015)

---

Flame (sorry about the...

Lynn Pettis (2/21/2015)

---

... Mark one off, 6 days on the calendar to go. 6 days on the calendar to go, 6 days to go, ...

And for the geeks out there:

......

Matt Miller (#4) (2/20/2015)

---

Ed Wagner (2/20/2015)

---

GoofyGuy (2/20/2015)

---

Eric M Russell (2/20/2015)

---

So,...

Sean Lange (2/20/2015)

---

SQLTestUser (2/20/2015)

---

not allowed to change the structure, wish i could, A location can have multiple areas, a customer can be associated to only one location and one area....

It sounds to me like you've got a much bigger problem on your hands than just being able to find numeric values. If you're storing numeric values in a...