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...

I see this often and capping the memory grants...

Just wonder if the OP didn't understand...

Luis Cazares (11/14/2016)

---

Eirikur Eiriksson (11/14/2016)

---

Can you post the actual execution plan, would make this a lot easier.

😎

If the plan contains sensitive data then you can use SQL Sentry Plan Explorer...

Can you post the actual execution plan, would make this a lot easier.

😎

If the plan contains sensitive data then you can use SQL Sentry Plan Explorer to anonymize it before...