capn.hector (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

SQLRNNR (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

The Dixie Flatline (4/18/2012)

---

Lynn,

My wife is a special education teacher with a lot of training and experience in behavior...

PaulB-TheOneAndOnly (4/18/2012)

---

MySQL? do you realize this is the Oracle section of a...

Okay, I have tried.

You want help, you have to give us more than the little tidbit pieces you continue to post. I really want you to look at your...

Perhaps something like this?

CREATE TABLE #Testing

(

Location varchar(255),

...

riya_dave (4/18/2012)

---

OK. I PUT FETCH_NEXT LIKE THIS

STILL NOT WORKING GOING ENDLESS.

declare @P1 nvarchar(32)

declare @mtd2 float

declare c1 CURSOR FOR

select account, MTD from #temp2

open c1

FETCH NEXT FROM c1

INTO @P1,@mtd2

WHILE @@FETCH_STATUS...

Not enough information to really...

SkyBox (4/18/2012)

---

I've attached another file of indexes on a table that could use some consolidation.

I see a couple that are obvious, but would appreciate any feedback. Just a quick look...

Not enough information to really help.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ and follow the instructions on what information to post and how to post it. The more information you provide,...

OP has reposted in the Working with Oracle forum. Please post further replies here.

polkadot (4/18/2012)

---

There's my attachment. Bingo. Thanks Carpal.

Lyn, I've already provided the DDL, which is what I think you're asking me to do. If I could create a query that...

Not enough information to really help.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ and follow the instructions on what information to post and how to post it. The more information you provide,...

Evil Kraig F (4/18/2012)

---

Brandie Tarvin (4/18/2012)

---

How about a slight change of subject. Still "worst questions" but of the humorous sort.

We've all heard about the admin assistant who switched from typewriters...

What we are trying to tell you is to NOT use an image. Create a...

Then I guess I'm done. I can't see anything wrong with the stored procedure. There are several ways to rewrite it, but those are superficial when you look...

capn.hector (4/18/2012)

---

Lynn Pettis (4/18/2012)

---

Have you setup database mail for SQL Server Agent? IIRC, this is a separate step from just setting up database mail. Sorry if I'm not...