The delimited split function linked above is not necessarily the best, it is loop based.

Do a search of this site for delimited split. I know I have posted a...

I'll take this one.

Steve Jones - SSC Editor (10/27/2010)

---

I'll drop some topics out here for you. Here's a couple that I have saved up:

- Finding/changing the default backup location

- scheduling a trace

- duplicating...

This is the best I can do from my BlackBerry.

Read about stored procedures in Books Online, what you are looking for is the OUTPUT parameter in the parameter list.

Basically, your...

Okay, we think we solved the problem, but don't ask me why; especially since we couldn't rebreak it.

Using Oracle's SQL Developer stored procedures and functions are by default compiled for...

Thank you for the info Paul, but I have a feeling that isn't what I need in this case.

Here is the issue (without providing actual code, can't).

We have a stored...

WayneS (10/18/2010)

---

Steve Jones - SSC Editor (10/18/2010)

---

I'm with Lynn. I'm not sold that global warming, even if it is happening, is a bad thing. It might be part of a...

Stefan Krzywicki (10/18/2010)

---

You know, I'm not going to. I don't want to get into political arguments here. I shouldn't have said anything at all, but I'm not feeling well and...

Stefan Krzywicki (10/18/2010)

---

GSquared (10/18/2010)

---

Steve Jones - SSC Editor (10/18/2010)

---

Alvin Ramard (10/18/2010)

---

Jeff Moden (10/17/2010)

---

Steve Jones - SSC Editor (10/14/2010)

---

The green value, if there is one, comes not from you getting ebooks,...

Okay, here is one way of writing a stored proc to accomplish your task. It assumes that the month and year are passed as separate parameters.

create procedure dbo.MonthlyOrdersForCustomer (

...

What let down response Lennie gave. Makes walking away much easier.

WayneS (10/17/2010)

---

GilaMonster (10/17/2010)

---

Yes

Don't think so. More likely,...

Tom.Thomson (10/17/2010)

---

Well, that's a very snsible thing to tell him. But...

I think the...

Sorry, but I couldn't resist responding. We'll see how he takes my critizism (sp ?).

Can't provide a whole lot of help right now, reading this on my BlackBerry in the car.

First thing I'll tell you is that you are doing this wrong. You...