ScottPletcher (4/18/2014)

---

Try this:

SELECT

emp.eid, emp.agentid,

info.emailid,

mail.EmailAddr, mail.LName, mail.FName

FROM...

Sean Lange (4/18/2014)

---

DDL, sample data and desired output would go a long way to getting you an answer. It is not at all clear what you mean by putting an...

This gave me a place to start.

For my Package/Process I think...

+1...The...

PHYData DBA (1/21/2014)

---

I want to thank everyone that took the time this morning to read my article and comment on it.

I had no idea that my very first...

Congrats to all the winners!

+1

thomashohner (12/5/2013)

---

I have to create a report that tells us if a Patient has had a Behavioral Health visit and a Medical Visit on the same day. We need to...

I prefer the "Jack of All Trade, master of none" verses being a so-called expert at 1 or 2 things. Keeps things from getting stale or boring.

I would really like a copy of the book!

(Select SchoolID, SchoolYR,

ROW_NUMBER() OVER(PARTITION BY SchoolID ORDER BY UPDT_DTTM DESC) AS RowNum

from dbo.SCHOOLYEARDEMOGRAPHICS) AS T

I once worked for a company where the managers couldn't give out any 5's. But you were expected to work towards a 5. I asked what was the purpose of...

I use an USB with all the tools and scripts and I usually have access to the internet at my workplace.

David.Poole (11/27/2013)

---

Jeff Moden (11/26/2013)

---

Gosh. I believe this is real simple.

The signs should say that you'll be towed after 2 hours UNLESS you register your vehicle with the folks inside....

"Do you think you could learn something like Powershell in 20 hours?"

Depends, for me I would need a task that is to be done with Powershell. Then I would...

Dale Turley (11/13/2013)

---

I strongly disagree with the idea of just pushing something out to fit a time frame, and this kind of mentality is the reason for IT having such...