Once I got your code to run, I do see a slight problem. I have three less values than you. So I am looking into why I missed...

Not sure this is correct, couldn't find any expected results based on the sample data provided, so you will have to tell me if it is okay.

USE Sandbox -- my...

TravisDBA (5/30/2012)

---

Now that is one powerful statement there. It makes all...

You may want to do some checking of the data. You may have unprintable characters embedded in som of your data. I just ran a test and everything...

Really? Although I may also agree to an extent (considering a COBOL application I helped support and extend for 11 years), but I...

From your post it is hard to give you an answer. The problem is that we can't sse from here what you see there. Just looking at the...

I think the following is a bit simpler:

DECLARE @MyDate DATETIME;

SET @MyDate = '2/28/2009';

SELECT DATEADD(mm, DATEDIFF(mm, 0, DATEADD(yy,-1,@MyDate)) + 1, -1);

Based solely on your post, no idea. The problem here is that we can't see from here what you see there. You need to help us understand your...

How does this do?

CREATE TABLE #ProductRate(

[ProductID] [int] NOT NULL,

[FromDate] [datetime] NOT NULL,

[Rate] [numeric](9,2) NOT NULL)

GO

INSERT INTO #ProductRate(ProductID,FromDate,Rate)

SELECT 1,'2012-05-23',100

UNION ALL

SELECT 1,'2012-05-26',150

UNION ALL

SELECT 1,'2012-05-28',1000

UNION ALL

SELECT 2,'2012-05-20',1500

UNION ALL

SELECT 2,'2012-05-25',2000

UNION ALL

SELECT 2,'2012-05-28',1000

GO

DECLARE @fromdate DATETIME;

SET...

Not sure what is wrong, but since you are using SQL Server 2008 (based on the forum you posted in) try this:

DECLARE @MMOrders TABLE (

order_no char(8),

oe_po_no char(25),

sf_order char(8),

item_no char(15))

-- Data...

tilew-948340 (5/29/2012)

---

I need to move a DB from SQL server 2008 R2 on a Window7_64 machine to a WindowXP_32 (not sure that the machine would survive to an update to...

May help if you also provide the code you have tried so far. Nothing like seeing what doesn't work to help look for what does work.

sql server developer (5/29/2012)

---

Thanks so much. I'm on SQL Server 2008 and decided to use Filtered Index on that column. However the issue i'm having is that i would like...

Has the entire IO Subsystem been checked, not just the disks? Drivers, hardware, etc.

Jeff Moden (5/29/2012)

---

Grant Fritchey (5/29/2012)

---

Piling on with Jeff, I'd rather enable the developers to keep them going as fast as possible in the dev environment. I've always had at least...