Recruiter = isnull((select top 1 x.fullname from users x

inner join OrderCandidateRecruiter y on y.userid = x.userid

where y.orderid = a.orderid and y.candidateid = a.candidateid

and y.entitytype in ('Primary','Secondary')

order...

I look forward to advancements in cloning so I don't have to take my laptop everywhere: 😉

If you are already very familiar with SQL Server then the fastest way to hone in on what knowledge you need to pass the exam is to use exam prep...

LINQ is good for querying objects cached in memory. I don't know that I would use it for something other than that.

nHibernate isn't really good for much in my...

It doesn't work in every scenario. The proc. that I wrote handles every condition possible that I had encountered.

Excellent post Jeff. I had written a function to calculate business days about 3 1/2 years ago for a client of mine (http://www.sqlservercentral.com/scripts/Miscellaneous/31543/). Yours is a...

Sorry, I misread your original post to mean zero-length string not space.

I am surprised I hadn't encountered that problem before so thanks for pointing it out. I...

Just out of curiosity, why would you want to split on a blank string?

Andy Leonard (1/26/2009)

---

This sounds like fair practice... if and only if every time someone does something that saves the company a person-year the company writes them a check equivalent to...

I had a former employer try to dock my pay for the time it took to install the software applications that I needed to do my job. When I...

This is tres cool! Thanks for posting.

Pretty much. Defeats the purpose of owning one.

Eavesdropping is the biggest issue. Using a phone to intercept conversations could seriously impact national security. Insuring that no one has physical access to the phone and removing...

I suppose that is a possibility but I have not encountered it yet.

Thank you.