Okay, you can add the report manager site to the trusted sites in IE without going to that page so just run IE as an administrator and go to bing...

I'm assuming you are using the GUI table designer to make these changes, which means, since the query is running on the same thread as the GUI it has to...

lduvall (5/30/2013)

---

I think the logic should be to count the ones that are >60 min from "the last one that counted."

Does that make sense? Am I thinking about it...

Are you using Excel to open the csv?

If the user only enters one parameter why are there 3 on the report?

If the user doesn't need to enter data for the last 2 parameters you can make them...

Saturnem31 (5/30/2013)

---

please where do i find "site setting" in step3 ??

the probleme is when I enter http://servername/reportserver I receive a pop up where i should put username and password,...

rochesterd (5/29/2013)

---

Thanks for pointing out I had these events sorted by type of event instead of event start time. I sorted them by event start time, so they make...

Sean,

I think your choices to produce N rows from 1 row are some type of explicit loop or a triangular join. I think the triangular join will outperform an...

Wait, I made I...

Okay. I can never remember the steps exactly to fix this, but eventually I get it right, so this should get you started:

1. Run IE as Administrator

2. ...

You should be able to setup a SQL Agent Alert based on the error number that fires when the error occurs. I'm pretty sure SQL Agent will have a...

I'd also consider event notifications.

Applications using OLE DB/ODBC/ADO.NET can use prepared sql statements and that's what sp_prepexec is essentially. The output parameter is the handle for the prepared sql statement so that if...

Okay, so you want to divide a single row into multiple rows based on the max quantity a single row should contain, 30 in your case. That's an interesting problem...

I don't know what you want to divide by. Do you want to total the Quant column and then divide by a count of rows to get an...