Are you seeing any CXPacket waits? I'm wondering if the upgrade has caused more parallel processing and this is causing issues?

Steve Jones - SSC Editor (10/21/2011)

---

Not...

Grant Fritchey (10/21/2011)

---

Throw out an old...

Brandie Tarvin (10/21/2011)

---

What sort of presentations...

No worries. We all forget the little things sometimes. That's why code reviews are so important, they catch the little things we can miss.

Did you add the parameter to the dataset query? THen you need to assign the report Parameter to the query parameter.

I'm not sure why you need the tax table. There is no relationship between inventory and tax without the taxapplies table, so the simple query I provided would show...

On a more serious note, I'd like to put together a new presentation, but I'm a bit short on ideas. Any suggestions?

Holy crap! Is that SNOW already? I was thinking...

What is the data type in the table? SmallDateTime's precision is to the minute and it rounds. See BOL here.

The only other time I've seen an issue where a log file couldn't be found, and in this case it was the only log file, was when the location was...

Brandie Tarvin (10/20/2011)

---

Brandie Tarvin (10/20/2011)

---

Jack Corbett (10/20/2011)

---

The only time I've seen this is with tempdb and a SQL Server Service restart fixes that.

A restart might fix this as well....

peterzeke (10/20/2011)

---

Chris -- interesting query. Looks like it's for SQL 2008?

So, if I understand it, the CROSS APPLY components transform a drug description into a comma-delimited array, which is then...

The only time I've seen this is with tempdb and a SQL Server Service restart fixes that.

A restart might fix this as well. This may not be an...

peterzeke (10/20/2011)

---

Makes sense to create a mapping table that can be leveraged for performance when doing reporting, but... doesn't the act of building such a mapping/crosswalk table return us back...