I wonder if it's a sign of the economic times we live in? Seems like I'm seeing more questions where the first sentence or two goes something like "I'm not...

Jeff,

You can also specify a proc/view name for your query. Such as:

EXEC msdb.dbo.sp_send_dbmail

@recipients = 'yourname@yourcompany.com',

@subject = 'Proc Test',

@body = 'Proc Test Results:',

@query = 'Yourdbname..yourProcOrViewName',

@importance = 'High'

Or a Proc With...

More than one way to 'skin' a string! 😉

CREATE TABLE #proditem (item1 VARCHAR(255))

INSERT INTO #proditem values ('CSCAR009/0001/001-PASPBD-Pedestrian automatic sliding door')

INSERT INTO #proditem values ('CSCAR009/0001/002-PASPBD2-Pedestrian automatic sliding double...

Try replacing your "If @@rowcount > ..." statement

with the following and see if it works for you:

(put this at top of your code before the select)

Declare @tblrows...

I'm sure issues such as 'performance' and 'input/output' rates will come 'up'...could cause a new 'process' to be 'spawned'?

:w00t:

Oops! Sorry...a little late to the game I guess.

Well here's one way to create a calendar that I believe I got from this site:

with mycte as

...

Play clarinet, tenor sax, bass clarinet...and sing in a 100-member classical music chorus acommpanied by local symphony.

Tried to learn guitar twice...not much luck (you know how it goes - you're...

Jumbo shrimp

I used to work in a building owned by Oxy Petroleum...a anti-social yet funny co-worker of mine called their employees Oxy morons...

Ok, thanks RM...that helped!

I guess the equivalent here for a Council House would be Section 8 housing (http://en.wikipedia.org/wiki/Section_8_(housing). In the town where I live, there are large apartment...

Ok, more education needed. What is a council house and why does that have negative connotations? Also, what is a ladette?

And wanted to mention that I have the English to thank for oh so many hours-upon-hours of good music. The classic stuff of course like Rolling Stones, Pink Floyd, Led...

I see....searching online for a good air fare now.:w00t:

What is a chav?

So what do the English have for breakfast? (Agreed, donuts aren't my favorite either.)

Here in the midwest, eggs (fried, scrambled, omelet), meat (bacon, ham, sausage, pork chop), bread (biscuits, toast)...

Kevin,

Very thorough explanation, thanks. Well, I have done SQL procs where I periodically have sent out emails to inform of progress. We use sp_send_dbmail here though. It usually involved a...