Thanks for your suggestions guys.

That's pretty much what that link suggests,...

Well..think I'm going to end up using scripting -

http://www.eggheadcafe.com/software/aspnet/29255866/copy-database-with-only-s.aspx

where you simply create a copy of the database structure. Not the ideal solution, cos it'll possibly be a pain...

hmm..that definitely sounds like a neat approach! Unfortunately I don't have any knowledge on creating triggers and advanced techniques like the ones you've suggested..but I'll certainly do a bit of...

That'll mean maintaining multiple copies of SQL eh? If we need to make a slight change to a script, or even add some new script, that means it needs to...

Oh sorry..I used this inside a UDF so that I can easily pass in different thresholds I need. Just use:

declare @minHighBpsReqd int = 3, @minSysThresh int = 130, @minDiaThresh int...

Well, we are doing retrospective quality audit..so it really depends on how far back we want to extract the data. At the moment it's a single practice with roughly 18-months...

Ah..great. Thanks Steve! It seems to work just fine. It was taking about 14s to run on the full table I've got with ~14k records, but then I filtered out...

Hi guys

Just letting you know that I did manage to write some sequential code to do this. Don't think you can simply do it in a single sql statement..so I...

Sorry for not explicitly stating my grouping requirements Steve. In the initial post I did mention:

I want to identify sequences where SYS>=130 and DIA>=80 for all the different patients. So...

Initially I was thinking of an output like:

ID, MESDATE1, SYS1, DIA1, MESDATE2, SYS2, DIA2, MESDATE3, SYS3, DIA3

but I'm thinking that's a bit harder to do in SQL itself. Will be...

Thanks guys. Appreciate your help.

hmm..I just tried both solutions and seems like both are close, yet there're a few issues 🙁

With Jerry's solution with temp tables, it kinda seems...

Oh..sorry for the confusion. It wasn't really a missing row as such..but just a blank line I added to show the end of that particular patient who had a bunch...

Thanks for the response Jerry. I'll try to clarify the problem further with a slightly different data set:

Here's some raw data:

DECLARE @BPTable TABLE (

MMID varchar(10),

MESDATE date,

SYSTOLIC int,

DIA int

)

INSERT @BPTable (MMID,...

Thanks for the quick feedback Matt. Your 1st suggestion certainly helps. The criteria table itself is not entirely static cos we want to be able to say "these are the...

Thanks guys. I wasn't exactly sure what Matt meant by a 'criteria' table though. The problem is the lists are created based on selected user inputs, which is why I...