Most likely then either you haven't configured the mail server correctly or for some reason it is not up at that time. GMAIL should work (I use it here)....

Could you do something like this?

;WITH Strings (s) AS (

SELECT '000' UNION ALL SELECT '0000000' UNION ALL SELECT '00000000000'

UNION ALL...

When you execute for 200 emails, do you see "Mail queued." appear in the Messages pane for each call to EXECUTE msdb.dbo.sp_send_dbmail?

Try adding the code in bold, adjusting the length of the quantity CAST to VARCHAR as necessary:

SELECT oi.ItemCode + ' X ' + CAST(oi.Quantity AS VARCHAR(5)),

oi.ItemCode, oi.ItemDescription, oi.Quantity, oi.UnitPrice, oi.UnitWeight,...

Thanks Alan!

One further point of note. Because of the fact there are...

Greg Snidow (1/3/2013)

---

Not the code for percentile, but if you can figure out a way to use OPENROWSET with...

I get 324 unique, fruity combos!

While I could have done this as a single query, I think it will be slightly more efficient using a divide and conquer approach. ...

I just love having something in my toolbox to deal with stuff like this. Refer to the 4th link in my signature to find PatternSplitCM and then try this:

;WITH...

About a week and a half ago, I bought my wife a...

Bhuvnesh (1/2/2013)

---

tbmabry (1/2/2013)

---

I tried this but it didn't work. I don't know what the emails are going to be they are from all over the U.S. There are over 4000...

tbmabry (1/2/2013)

---

I tried this but it didn't work. I don't know what the emails are going to be they are from all over the U.S. There are over 4000 records...

Instead of write-only code, I've always found it immensely helpful to split up complex string manipulations for readability into individual parts using cascading CROSS APPLYs like this:

;WITH Notes (Note) AS...

RamSteve (1/2/2013)

---

Hi I am Trying to Build Dynamic Where Clause for Multiple Parameters and they could be Null Also .Please find my

Query as Below and I need to make...

Joe - Please excuse me for jumping in and interpreting for you. If you feel I'm in error, I know you won't hesitate to correct me. 😀

kwoznica (1/2/2013)

---

Joe,

You...

To get a working query out of the volunteers on this forum, you'll need to provide more in the way of DDL and consumable sample data. This article explains...