While the database was using the full recovery model, were you taking regularly scheduled transaction log backups? If not, that is why your transaction log kept growing. The...

I can get the code to parse but without the DDL for the tables involved I can't do anything else.

blandry (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Which...

blandry (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Which...

Which one is it...

Also, replace your split function with the one you will find with this article (oh, read the article and its discussion):

http://www.sqlservercentral.com/articles/Tally+Table/72993/

blandry (5/2/2012)

---

Hi Lynn / Cadavre,

Sorry I am late today - meetings in the AM and more coming too - but while I have time I looked over the code you...

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table...

Not sure what you would want to do for null values, but this should work for actual date values.

DECLARE @DateVar DATETIME;

SET @DateVar = '20120802 10:30:58.003';

SELECT @DateVar, LEFT(DATENAME(mm,@DateVar),3) + '-' +...

It would help if you could post the DDL (CREATE TABLE statement) for the table(s) involved, sample data (INSERT INTO statements) for the table(s) involved (also, not real data, just...

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to...

Sean Lange (5/2/2012)

---

Lynn Pettis (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table...

Basically came up with the same thing as ColdCoffee:

DECLARE @TestStr VARCHAR(128);

SET @TestStr = '/Customer Service2/CS Team - CareFirst Connect';

SELECT REVERSE(LEFT(REVERSE(@TestStr),CHARINDEX('/',REVERSE(@TestStr))-1));

SET @TestStr = '/Enrollment Analyst/Enrollment Analyst 1';

SELECT REVERSE(LEFT(REVERSE(@TestStr),CHARINDEX('/',REVERSE(@TestStr))-1));

SET @TestStr = '/Enrollment...

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a temp table and then call a...

Unfortunately, none of your responses until now really made that clear. I apologize if I got to aggressive in trying to make that point.