Looks to me like your data source is configured wrong on the report server.  The error (if I am reading it right... I only know english, so I am just...

Looking at that, the temp table is a heap, so unless tempdb is on slow disk OR tempdb is nearly full and your INSERT is causing a lot of auto-grow,...

My opinion - this is a data problem, not something to be solved in your ConStr variable.  I would fix this in the TCondition table as it contains the ">1000"...

@Erland - my mistake.  I had meant "SQL Server Management Studio presents the date in the format that is configured on the server", not SQL Server.  SQL Server stores the...

EDIT - disregard my post.  Everything I said has already been in previous replies.

If memory serves, SQL Server presents the date in the format that is configured on the server. ...

• This reply was modified 3 years, 10 months ago by Mr. Brian Gale.

Are you trying to install SQL fresh OR is this an upgrade of SQL 2012 to SP3?  Have you had SQL Server 2012 installed on that machine (and potentially the...

again, I would check the result of your print statement and see what is actually being executed and where the error likely is.

Running your query with the exec commented out...

I would start by taking out that "EXEC" line and use the PRINT line to see what is actually being run.  You are comparing OR inserting an NVARCHAR with an...

At my workplace, we actually use SSIS to pull data across from "live" systems into our reporting database.  SOMETIMES it is a 1:1 copy of the data, sometimes we transform...

That is on you to decide if it is a problem or not.  If it is, then you are going to need to come up with another solution.  If it...

To add to what everyone else has said, network performance could be a bottleneck too.  Those tables don't look like they hold that much data in terms of MB or...

I think my representation of SSIS was a bit off.  What I meant was that SSIS would be used for the data pull from source, the transform of the data...

Bruin's solution works with the exception that it doesn't capture error messages from the scripts.  But what you COULD do is a modified version of Bruin's script, but it does...

Personally, I agree with you Rod.  I think that report writing is more of a "business analyst" role than a DBA or DB Developer role.  BUT that being said, I...

I was just reading the error message as it says "The process encountered a deadlock and is retrying".  This is the expected behavior.

Now, as for long running blocking causing deadlocks,...