Sergiy (7/6/2016)

---

Lynn Pettis (7/6/2016)

---

How about a page from Mr. Celko's book (none of which I have or will read), because CAST is the ANSI standard and CONVERT isn't.

You should always...

Sergiy (7/6/2016)

---

There are more.

You can easily filnd them if you look up for the article "CASR and CONVERT" in BOL.

...

ScottPletcher (7/1/2016)

---

Jeff Moden (7/1/2016)

---

ScottPletcher (7/1/2016)

---

I still say don't explicitly code it unless the code requires it (some system procs require unicode strings specifically, for example), because it can cause...

alexhartley13 (7/1/2016)

---

Hello everyone.

I would like to know if it is possible to use SQL Server Management Studio at home so I can learn SQL. I know a little bit...

ScottPletcher (7/1/2016)

---

Sergiy (6/30/2016)

---

ScottPletcher (6/30/2016)

---

Jeff Moden (6/24/2016)

Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals....

Lynn Pettis (6/30/2016)

---

Never mind, I think I just figured this one out as well. I think...

Never mind, I think I just figured this one out as well. I think I have...

Is there a limit on how deep you can nest a REPLACE?

ScottPletcher (6/30/2016)

---

Jeff Moden (6/24/2016)

Shifting gears a bit and depending on how that's used, it could become a performance problem due to the implicit conversions of the string literals. Since...

kpwimberger (6/30/2016)

---

Thanks for the reply. So far I have found suggestions to edit the XML data conversion config file (which may get me fired), create a View from the query...

JoNTSQLSrv (6/30/2016)

---

J Livingston SQL (6/29/2016)

---

For knowledge shake, is it possible to implement the same result in while loop ?

why?

what benefits do you perceive you will gain by using a while...

I have a T-SQL solution.

Nested REPLACEs in an in-line table valued function.

May still revisit this as an exercise later when I have time to try and learn C#.

I don't usually ask desperate questions, but if anyone as something already in place I could use some help here.

I guess I better start learning C#.

TheSQLGuru (6/29/2016)

---

J Livingston SQL (6/29/2016)

---

For knowledge shake, is it possible to implement the same result in while loop ?

why?

what benefits do you perceive you will gain by using a while...

So what is the problem? We can't see what you see.