peter-757102 (7/23/2015)

---

I do like to spend time to design better early on and do various tests to confirm i am on the right track.

And doing so by making mini-scripts and...

The real question is "Should you write 'terminate employee' business logic in a stored procedure?"

You don't have to convince me on the ROI of Unit Tests, they're a proven methodology...

Robert (11/21/2008)

---

On the contrary. CMD.exe is DOS. It will execute any well behaved DOS executable, so it provides complete DOC environment. At least 32bit version, 64bit version refuses to run...

I got the question correct. However, and it's not the first time that I have noticed this on sqlservercentral. It's not 'DOS'! DOS died a long time...

Vladan,

Indeed. I didn't bother to look twice 😉 but just noticed a whole bunch of SQL while the solution was fairly simple.

And I second your sub-select comment.

Regards,

Ben

Don't know why you guys are making it so hard. What is wrong with just:

SELECT

Agt.AgentName,

Ags.Date,

PrimProj.ProjectName As PrimaryProject,

SecProj.ProjectName AS SecondaryProject

FROM

AgentSession...