What did you upgrade the Reporting Server or the Database Server?

I'd do something like this:

INSERT INTO testProb1 (

col1,

col2

)

SELECT

TD.col1,

TD.col2

FROM

testprodD AS TD LEFT JOIN

testProb1 AS...

All the sample databases on are on CodePlex. SQL Server 2008 DB's are here.

I don't use prefixes on tables and stored procedures. I do tend to use prefixes on views (vw) and functions (fn) to differentiate them from tables and stored procedures....

I'm not a zealot either, but I prefer all lowercase with underscores instead of Pascal or CamelCase for object names, although I do like uppercase key words.

I don't like case...

What I have seen recommended in this case is to create a second table and load the data into it, then drop the source table and rename the new table...

With the code...

Can you isolate the index on which this occurring? Is CheckDB returning any errors?

Lutz has set you on the right direction, I think. Here is what Lutz was looking for and leading to, I think:

-- create test tables

DECLARE @tableA table

...

Duh, once again I make the question more complex than it needs to be. :w00t:

Thanks for clearing it up Lynn.

You need to use PATINDEX(). Something like this:

DECLARE @string VARCHAR(MAX)

SET @string = '

<>Agenda and Minute

<>Member Application'

SELECT

SUBSTRING(@string, PATINDEX('%32602%', @string),5)

Of course, since you already know what you...

What UI are using to display the data? If you are using SSRS I think a matrix would do want you want. You can also search for crosstab...

I have to say that I don't have any experience with clustering, but, based on what you are experiencing, I am wondering if the restart of the cluster services caused...

You might want to look at signing your procedure.

I have played around with EXECUTE AS trying to get access to the view and function you are interested in...

From the link in my previous post:

And

To specify the EXECUTE AS clause when...