I'd ask:

I'd be looking for...

You can add a second group on Department within the Store group so your report would look something like this:

Store|sum of hours|sum of dollars

...

Sean Lange (5/6/2014)

---

pgmoschetti (5/6/2014)

---

You are right, that's a good solution. I've only an additional problem, I must think of: as you said, it is a bulk delete. This bulk delete...

I think you might want something like this:

DECLARE @orders TABLE

(

OrderNo INT,

ReceiptDate DATE

);

SELECT

...

The first thing I"d be concerned with is if you are executing the query in the right database. There is this parameter (from BOL):

[ @execute_query_database= ] 'execute_query_database'

Is the database...

Mark,

I did some asking around and it looks like you should contact CSS to get an answer as they may need a mini-dump of the SQL Server process.

Looks like this could be a bug. Check out this post for a possible workaround.

What SQL Server version and Service Pack is the server?

What SQL Server version and Service Pack of SSMS are you using?

Have you tried installing the latest...

You have to keep in mind that this value is an accumulation since the last server restart, so if your server has been up for months a wait time in...

Something like this should work:

=CSTR(CINT(Fields!FiscalYear.Value) - 3) + " Meal Count"

Since Windows is presenting these errors I'd look to get my SQL Files off that drive and then run CHECKDB against all the databases that were there. I'd also...

a4apple (5/2/2014)

---

Jack Corbett (5/2/2014)

---

Parameter sniffing won't cause the results returned to be incorrect it can cause a sub-optimal plan to be used skewing performance. If parameter sniffing...

Okay. Like I said, that was a guess based on the name. I'm not surprised I guessed wrong.

I just thought of something else. The connection settings can...

I believe this is stored in the registry. If you view the source of EXEC msdb.dbo.sp_set_sqlagent_properties all the properties are stored in the registry.

Have you uses sp_who/sp_who2/sp_whoisactive or queried sys.dm_exec_connections/sessions or run a trace to see what the SQLAgent session is doing?

Based on the fact that the sp starts with ssrs*...