I'm not sure the OP noticed, but I figured it didn't matter much, as that's the exact same kind of result I was getting. Some one of those records...

Sounds like you need to establish exactly what it means to have a date "one month from a given date", and while you're method for x number of days from...

I just tested a variation, where I moved the ORDER BY clause up into the SELECT INTO query, and it continues to produce a correct result, but apparently, only because...

It's time to post the contents of the sp that's timing out. Is this sp new, or has it been around awhile? If it's been around...

You haven't mentioned what kind of hardware this is running on, or how much RAM it has, or what else might be making use of the available resources. ...

The SQL Server is just tried your query on is as follows:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Enterprise Edition on...

Glad you have it working. Just a quick point - I realized too late in the day yesterday that I left in two SELECT statements in that list...

Because you've provided no ELSE clause for your CASE statement. The CASE statement in an ORDER BY clause, gives you the functional equivalent of adding a field to...

Hmmm... almost missed it... read only access to a database hosted on YOUR local machine? Has anyone considered the backup requirements for the data in this...

Oh, ok... sounds like maybe just getting a scheduled SQL Agent job to run and execute an SSIS or DTS package to copy the contents up to SQL Server, where...

I'd be more concerned about why you would continue to maintain the data in Access instead of migrating it up to SQL Server instead, and just letting Access be the...

Take a close look at the two case statements - they are NOT the same. The one in the select statement has an ELSE clause, while the one in...

Ok, here's the update I promised, and with your full set of requirements taken into account:

DECLARE @BP_READINGS TABLE (

MMID varchar(10),

MESDATE DateTime,

SYSTOLIC int,

DIA int

)

INSERT INTO @BP_READINGS (MMID, MESDATE, SYSTOLIC, DIA)

SELECT 'A006283',...

Ummm... I'll have something for you on Monday, as I don't have time today. No biggy, but if you needed the sequences to be grouped, you should have...

My Bad !!! I've goofed :w00t::w00t::w00t:. I was just looking at Jerry's response when I realized I could make my code better by eliminating yet another...