I'm glad we could help! The world is a better place with fewer headaches 🙂

Cheers!

If I understand that correctly, the logic is actually equivalent to the simpler looking:

WHERE StartDate<=@ToDt AND EndDate>=@FrmDt

However, note that when you add that WHERE clause, you won't be able to...

Heh, it looks like Lynn and I had identical thoughts 🙂

I originally didn't even mention this since the question was posted in the 2008 forum, but just on the off-chance...

That's definitely not normal.

I'd check into what that session is running and what isolation level it's running under..

Even with RCSI enabled, sessions can explicitly set other isolation levels, and DML...

Here's one way that could work:

CREATE TABLE AssetPlacements (

ID int,

AssID int,

LocID int,

PlacementDate date)

INSERT INTO AssetPlacements VALUES

(1,1,1,'2015-05-01'),

(2,1,2,'2015-05-06'),

(3,1,3,'2015-05-09'),

(4,2,1,'2015-05-03'),

(5,2,2,'2015-05-07'),

(6,2,3,'2015-05-11');

WITH CTE (ID, AssID, LocID, PlacementDate, RN) AS (

SELECT

ID,

AssID,

LocID,...

From https://technet.microsoft.com/en-us/library/ms189128.aspx:

When you are detaching or attaching a database, the Database Engine tries to impersonate the Windows account of the connection performing the operation to guarantee that the account has...

Yeah, to add on to what Lynn said, unless you absolutely need the drive space back (actually need, not just want :-)), it's generally best just not to shrink a...

Yeah, like Eirikur, I was a bit confused at first, since I looked at the question on the 22nd. I also wasn't sure what part of the date the number...

What exactly are the details you want copied? Could you post the expected results of the copy process based on the sample data you provided?

It seems that you just want...

When you say you couldn't attach it, what was the exact error you were getting?

Also, just so I'm clear, when connected via Windows Authentication, you could attach it from...

We have a bunch of Nimbles in our customers' environments, and depending on your performance requirements, they can be hard to beat for performance/price.

Having said that, there are not "tiers",...

I completely agree that there needs to be more of the scientific method applied to claims/questions about SQL Server, whether general (like Gail's example of joining on a string compared...

Well, if you wanted to make sure that changes to the data wouldn't result in the queries' returning an error because of using = with a subquery that returns more...

It really depends, and it's hard to avoid relying on intimate knowledge of the applications using the database.

In this case, that sounds like an excellent candidate for removal, but there's...

Ah, good point! I actually just looked quickly at what turned out to be the same article referenced in the answer, which I don't think mentions...