You could also do this:

REPLACE(value, char(88), '/')

tarr94 (4/6/2016)

---

Thanks for the responses!

Jacob, you're right, I missed something when pasting my sample data. I've corrected it in the original post.

Lynn, I may end up doing exactly that....

Steve Jones - SSC Editor (4/5/2016)

---

Was in SF last week. It's crazy expensive. I don't even like staying there when I visit. I've gotten to the point I'll stay near...

Greg Edwards-268690 (4/6/2016)

---

Brandie Tarvin (4/6/2016)

---

Good morning, peeps.

What are we having for breakfast today?

Mine was oatmeal with purple honey (from North Carolina) and assorted fruit. But for some reason I have...

Luis Cazares (4/6/2016)

---

And this functionality is no longer guaranteed to...

DesNorton (4/5/2016)

---

Alan.B (4/5/2016)

---

Interesting dilemma and great work with the sample data/ddl!

Quick question what are the Partnumber column always going to be 6 characters long or less?

Also (and I...

NP. 😀

Interesting dilemma and great work with the sample data/ddl!

Quick question what are the Partnumber column always going to be 6 characters long or less?

Also (and I expect the...

swansonm (4/5/2016)

---

This would work if the termDate is the date of the term of that line/effective rate, but not since the termDate is actually the term date of the line...

Indexing is a complex topic indeed. I huge part of the game is understanding how your server is using them. I always develop SQL with "Include actual Execution Plan" turned...

It will increase performance if the index is used by the optimizer for SELECT statements. Say the column name is C1 and you execute: SELECT C1 FROM youratable......

Using GetNumsAB[/url], this may be better:

WITH base AS

(

SELECT rn, d = DATEADD(DAY,n2,mn), mn = DATEADD(DAY,rn,mn), mx = DATEADD(DAY,n1,mn)

FROM

(

SELECT...

If you had 2012 this would be much easier. I have to think about this a little; the most straight-forward solution is a "triangular join" that looks like this:

WITH...

WhiteLotus (4/4/2016)

---

Hi All,

I am about to migrate some databases consist of user databases and also Report server and Report server TempDB from 1 server to another server

Question :

The destination server...