Is this a direct query or are you using a stored procedure? Can you modify the stored procedure if that is what you are using?

tulips

Because it is an older, more...

Long time no see Barry! Glad to see you back!

Oliiii (10/15/2010)

---

Usualy a DBA does not work in "Project" mode, so once they start somewhere they usualy work there for some time (years).

So in the end finding a SQL DBA...

kurtwest (5/10/2012)

---

I have one database on my server that has more than just mdf and ldf files. There is a bunch of files with a .db extension. I...

I worked for two different companies that had annual picnics for employees and families. One was a small company and the other a large privately held (at the time)...

SQL_path (5/10/2012)

---

thank you,

that worked for the data I posted, I guess I still have some bad data, as I still get the same error any tips on how to...

The following works on my pc.

create table #123

(dates varchar(25) null);

go

INSERT INTO #123 (dates)

SELECT '1/4/1996'

UNION ALL

SELECT ' 10/11/1996'

UNION ALL

SELECT '1/1/08'

UNION ALL

SELECT '12/16/11'

UNION ALL

SELECT '5-02-11'

union all

SELECT...

WayneS (5/10/2012)

---

Lynn Pettis (5/10/2012)

---

Well, you all know me, as much as I want to give up, I feel like I have to try again.

Unfortunately looks like others are starting to...

Thanks guys and gals. I removed the cursor code from my post. I moved it over to that other thread in hopes that he-who-is-without-clues may see it.

riya_dave, Here is the code I wrote. To make it work with Waynes test suite either modify it to create a table named dbo.Emps or change the references...

Brandie Tarvin (5/10/2012)

---

Wow. I come back to The Thread and find the lot of you talking blasphemy.

I think I shall strap myself to the porkchop launcher and launch myself out...

Jeff Moden (5/10/2012)

---

Lynn Pettis (5/9/2012)

---

Jeff Moden (5/9/2012)

---

Wow! Working...

Koen Verbeeck (5/9/2012)

---

Is this an Oracle thing? I've seen this a lot lately in Oracle code.

(and unfortunately, also in...