Good call on the extra...

Could you post some sample data, about 10 to 20 rows, as a series of INSERT INTO statements for the source table (and if you haven't provided the CREATE TABLE...

LutzM (1/26/2011)

---

PSB (1/26/2011)

---

It fails with string

5305 ...

For some other date manipulation functions, look here: Some Common Date Routines.

First, you probably don't need a cursor. Second, can't really help you with the info you have provided. Sorry, we can't see from here what you see from...

Mostly from practical experience. Seems I've worked with server admins that have partitioned the "c" drive into two drives, C: and D:. The C: Drive is usually only...

Okay, tested my solution against that of mister.magoo and his won. Mine returns the same result set with the same sample data.

I guess I'm going to have to start...

"It fails" is a typical user response. How did it fail, what is the exact error message or messages you are getting.

If you would like better help, help us....

CirquedeSQLeil (1/26/2011)

---

Lynn Pettis (1/24/2011)

---

Grant Fritchey (1/24/2011)

---

Jeff Moden (1/24/2011)

---

Grant Fritchey (1/24/2011)

---

Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on...

WayneS (1/26/2011)

---

IMHO, this would be indicative of...

WayneS (1/26/2011)

---

Well, I don't see a problem with this:

1. constraints are a separate object, and are stored in the sys.objects (or sysobjects) views.

2. the scripted commands for a drop/create work...

Based on sample data, what is the expected output?

WayneS (1/26/2011)

---

Lynn Pettis (1/25/2011)

---

Does the following snippit help?

declare @TestStr varchar(128) = 'TRITON9700 L9700031288172 10-07-09 | EDC TRITON 9700 CASH DISPENSER';

select

SUBSTRING(@TestStr, PATINDEX('%[0-9][0-9]-[0-9][0-9]-[0-9][0-9]%|%',@TestStr), 8) as CharDate,

...

Very good question. Had to really think about it before answering, and I got it right.

The sad part about this, "It works on my machine", is that I have seen. I have also the where the code changes work perfectly in development and during...