You're welcome, 'glad to help.

sethu raman (8/3/2011)

---

Here is what I do :

On step 3 ( Create a data-driven subscription)

select * from table

On step 5 ( 2 parameters) are set.

Name

State

For Step 5 parameters...

Yes, it works that way for all versions as far as I know.

A data driven subscription doesn't send out emails when there are no rows returned. So just write the procedure so that results are returned only when you want to...

So Tom, it sounds like what you're saying is, American beer is terrible. Well, I know that I tend to buy imported beer most of the time (and I'm...

LutzM (8/3/2011)

---

Back at the time I spent in the U.S. we (a few Germans that just arrived and been there for the first time) wondered why we received a weird...

Kenneth Wymore (7/28/2011)

---

My team usually uses Windows Live Communicator and we do screen sharing while on a conference call to visually walk through more complex items. I will say that...

cengland0 (7/28/2011)

---

What would you say if I told you when someone calls me and wants me to do something, I tell them I'll do it but that they need to...

Sometimes being able to go talk to someone in person is just easier to do. There are times, for example, when I start to type an email, but decide...

Well,...

I think we just visited the "Some things you just don't wanna know" domain. :sick:

Actually, bacteria gas. (CO2) Delightful, isn't it? And I like swiss cheese.

So I guess Baby Swiss uses mini-bacteria?

I like the way you think Steve, but you are much more informed than I am.

Would a ROWID save us from those dastardly heaps? So a heap would no...

When you INSERT with an EXEC like that, the column names have to be exactly the same and in exactly the same order.

Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master" or...