As I said before, clean up the data before it goes into AgencyDB so that it doesn't violate the constraints. If you need more detailed help than that, please...

Is there a PRIMARY KEY or UNIQUE constraint on account.account_id? If there is, that'll be why the execution plans are identical.

John

How are you restoring the information from one database to the other? You can't insert any rows into AgencyDB that would violate any constraints in that database. If...

You can't do much with the results of a stored procedure, other than insert them into a table. You'd be better rewriting the procs as functions, the results of...

Just remove the second "w:\dir\" from your command.

A good search term would be "ren command syntax".

John

I use the script below for setting up Database Mail. It's useful if you regularly build new servers or set up Database Mail on existing ones. You should...

m.rajesh.uk (4/25/2013)

---

Hi all.

I found there was fragmentation in my server and i rebuild the indexes to remove fragmentation. But even after rebuilding the...

What happens when you run the SELECT statement from Management Studio?

John

DevDB (4/24/2013)

---

Its running fine for me. It returned 29877 when I added CONVERT(numeric(14,2),Value) > 0 in where Clause.

My machine is

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)...

Here we have an object lesson in why EAV tables are not a good thing. If you can't change the database structure, this should work for you:

SELECT DataId, PathId,...

I suspect this is because it's attempting to do the conversion in the WHERE clause for all values, not just those with PathID 30 and 31.

Try something like this:

WITH MyValues...

Does the same thing happen if you put your hex values in quotes in the first query?

John

The original backup.

John

OK, you should be in business. Back up your transaction log. Restore your full backup (preferably not overwriting the existing database) with no recovery. Restore the log...

You're setting the value of @strFind to a single character, yet you're then testing to see whether that value is in a list that includes strings of more than one...