Thanks Gail.

It's hard to ask why they want things because of the dark politics of what's going on. We have to keep things very much at arms length so...

I wondered if it's to handle timespans. What we're doing is heavily connected to lengths of time and the duration of various things. I could understand if they...

HanShi (11/20/2014)

---

Stuart Davies (11/20/2014)

---

Koen Verbeeck (11/20/2014)

---

I have been nominated for the "Author of the Year" award at MSSQLTips.com.

This means people have to vote for me (or other people, but preferable...

fugue

I stand corrected. There are several companies that offer pre-employment credit checks over here. The thinking is to avoid the possible corruption. One company also phrases it in...

Stefan Krzywicki (11/18/2014)

---

cackalackian (11/18/2014)

---

Would you want aspects of your life, perhaps data outside of your health (think driving, finance, etc) to be part of the evaluation (or negotiation) process for...

Give this a try

create function dbo.ProperCase (@name varchar(70))

returns varchar(70)

as

begin

declare @output varchar(70)

declare @upper varchar(70)

declare@space int

declare @first varchar(70)

declare @last varchar(70);

set @upper= rtrim(ltrim(upper(@name)))

set @space= patindex('% %',@upper)

set @first= left(@upper,@space)

set @last= reverse(left(reverse(@upper),@space) )

set @output =...

The short answer is yes, the long answer is 'it depends what for'.

http://msdn.microsoft.com/en-us/library/ms144275.aspx

Thanks Perry, I spent most of yesterday looking into the column source and destination mappings as you suggested but I'm still struggling. From what I found, I got the...

Stuart Davies (11/11/2014)

---

BWFC (11/11/2014)

---

One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious local...

One of the people whose name I've seen attached to the kitchen cabinets spam lives just down the road from me. He's a reasonably notorious local businessman who's actually...

I suspect not as many people will get this right as they should because one of the two identical options returns a wrong answer.

Reported as spam

spaghettidba (11/3/2014)

---

I'm wondering why he wants to certify on a subject that he clearly doesn't master.

However I feel his pain: how is anybody without system/network administration skills supposed to understand...

Thanks Eirikur, I'll have a look at that as soon as I get chance. I think that the only things I hadn't tried in one combination or another were...