The example makes what you need much clearer. Neither my nor David's code does exactly what you are looking for. I believe that this is what you want...

Unique values in sys.partitions are defined by object_id, index_id, partition_number. There is at least one row in sys.partitions for each table and index on the table.

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...