This is a nearly impossible task to get 100%...

schleep (2/27/2014)

---

Well if I'm understanding this -- and to be honest, I'm on very thin ice -- I can't check the state of the connection in my original code as...

schleep (2/27/2014)

---

Sean,

Actually I got your connection object example to work, needed to remove the

Server. in SET oConn = Server.CreateObject("ADODB.Connection")

So, I'll let it run for a couple of days, and...

Been quite some time since I worked with this but you don't have an explicit connection. You should declare your connection as an object so you manage it.

conStr="Provider=sqloledb;Data Source=<SQLServer2008>;Initial Catalog=<mydb>;Integrated...

batesview (2/27/2014)

---

I wonder if a CLR function would be worth considering here? .NET includes the System.Globalization.TextInfo.ToTitleCase() function which seems to do a pretty good job getting things properly capitalized. Not...

Jeff Moden (2/27/2014)

---

Sean Lange (2/27/2014)

---

Using the explicit value is...

Using the explicit value is generally considered better practice....

Did you try this?

ROW_NUMBER() OVER(PARTITION BY r.clientid, GenActivityCode ORDER BY appointmentdate asC) AS FollowUp_No

pbaldy (2/26/2014)

---

Just wanted to say thanks Sean. I followed your recommendation and have a holding table populating from the trigger and a stored procedure that uses a cursor to...

dwain.c (2/26/2014)

---

Can't say I see that much of a resemblance but it is always good to...

Woohoo!!! I was trying to reference something there earlier today and noticed it was still down.

sankepalli (2/26/2014)

---

Hello Folks,

Suppose, there are 1 million records, if we insert all these records in the log file, it will become full & DB will become read only. We cannot...

pbaldy (2/26/2014)

---

There could be a delay, but it would be measured in minutes rather than hours. The status field is used to let dispatchers know whether they can give...

pbaldy (2/26/2014)

---

I appreciate the information and I'm always looking to improve. That said, it doesn't address my issue of executing a stored procedure on a linked server. I...

I came back to this thread today because I was trying to proper case some stuff around here. I needed to exclude tokens that contain at least a single digit...