Jeff Moden (11/13/2016)

---

TheTrojan (11/13/2016)

---

@mister.magoo You will be happy to know that your solution is slightly faster than mine! Have a look at the times:

-- if the parameter is 1000: 76...

Adi Cohn-120898 (11/15/2016)

---

Here is one more way:

declare @Org varchar(150) = 'Lorem ipsum dolor sit amet, CONSECtetur adipiSCIng elit. PelleNTesque in ELIT ut ex accumsan sagittis in a urna'

declare @Results varchar(200)...

You are very welcome.

😎

To...

farax_x (11/15/2016)

---

GilaMonster (11/15/2016)

---

You're going to have to investigate why that procedure is compiling frequently. There's nothing in the code that would cause compiles or recompiles, so start by tracking down...

Before changing anything, what is the output of this query?

😎

SELECT

'dbo.MAP_MONTH' AS TABLE_NAME

,MAX(MM.SYS_ID) AS MAX_VAL

FROM...

From what I can see, you will have to change the data type of the ID column in the MAP table to INT, currently it is NUMERIC(9,0) (999999999) which is...

dothedev (11/15/2016)

---

I need to replace in given string all uppercase strings longer than two characters with lowercase and set html bold tags around them. Any leads?

For example convert this:

Lorem...

s0da9 (11/14/2016)

---

Ed Wagner (11/13/2016)

---

s0da9 (11/13/2016)

---

Adi Cohn-120898 (11/10/2016)

---

Can you check the server's error log? By default it is configured to write into the error log details about failed logins. ...

Script the tables in question as shown in the picture and the post the generated scripts here

😎

lady.konvicka (11/15/2016)

---

hi i have this test code which replace our problem on production

first replace for CHAR(0) removes character 'C' --- I dont know Why

when u set input to for example...

GilaMonster (11/15/2016)

---

Eirikur Eiriksson (11/14/2016)

---

I used to have the same problem in Iceland, blazing fast local but anything else would be crawling, here in London I'm getting around 985Mbs on the...

Jeff Moden (11/14/2016)

---

Iwas Bornready (11/14/2016)

---

Gary Varga (11/7/2016)

---

...or they could just continually lose staff with all their knowledge of both the business and it's workings then hire someone with none of...

GilaMonster (11/14/2016)

---

Eirikur Eiriksson (11/14/2016)

---

GilaMonster (11/14/2016)

---

Steve Jones - SSC Editor (11/14/2016)

---

I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are...

GilaMonster (11/14/2016)

---

Steve Jones - SSC Editor (11/14/2016)

---

I would be happy to make you a moderator, but it consumes lots of bandwidth. The #$%#$@# way the forums are setup is you'll...

omar4454 (11/14/2016)

---

Hey everyone, can someone provide some light on this error, or how to go about troubleshooting? I am getting this error for about 5 columns. They are not in...