So you are able to change the index on the table and not a query? If you knew for a fact that changing the query will not break anything else...

siugoalie78 (11/25/2015)

---

I am not sure if this is the exact same issue, but I was getting the same error. In my organization, every time there is a schema change we...

Having before and...

You mentioned you have tons of indexes. I hope on of them is a clustered? Lots of indexes ( lets say half the number of columns on the table) can...

I dont know what qualifies as "most queries."...

From MSDN,

"STATIC

Defines a cursor that makes a...

Glad that you were able to get a resolution. Only that uninstalling apps and the pain that goes with all that might get irritating if you run into this situation...

Thanks Ed, I had to look at it for a minute to figure it out. It looks like that single quote is closing the first one in front of ren.....

I dont work with this a whole lot so I was wondering if the single quote closing the double quote is valid, or if it is just covering the...

Are you referring to exporting the data in a SSRS report to Excel ? OR are you referring to a report subscription ?

Please see if the below link helps...

I would approach this by using the SQL in your report (preferably the stored procedure that the report calls).

WITH myTop5 as (

select top 5 customer

from...

Typically a SCD type 2 has those validFrom and validTo fields in the dimension table. You can create your DSV by filtering on only those that have the validTo be...

Good concept and idea. I had implemented something similar. I am sure we have all seen the choose a month to report from . In these cases I instructions in...

Try to start clean,in these cases. Create a SSRS project named like TempSSRShold for example. Then Right click the Reports node, add > existing item. From here navigate to the...

Just to add a little here, recall that a FACT is just that. It captures something that happened at a point in time. There is really no updating here (unless...