Viewing 15 posts - 46 through 60 (of 103 total)
Thanks for replies.
i will always want to select previous 52 prior to the previous sunday in the current week.
thanks
July 5, 2012 at 5:27 am
Hi
Thanks for the reply. It works but assigns the same value to every row. I think now i have my query structure wrong.
Below is a sample data table script...
June 6, 2012 at 12:29 pm
Cheers I'll take a look tomoroow and let you know how i get on when using the main data set.]
Thanks again for your help.
February 7, 2012 at 3:40 pm
Thanks for your help,
the reason that on the 7th WC would count as 1 is because patient 5678 was on ward WC on the 6th , and 7th and then...
February 7, 2012 at 6:57 am
Right I have the expected results here, please ignore the ones in the original post.
The results should look as follows
DATE WARD...
February 6, 2012 at 2:50 pm
Hi,
Basically I mucked up a bit with the expected results. I will try and re-do and re-post expected results
Patient 5678 had 3 different wards. They started on WC (position 3)...
February 6, 2012 at 2:39 pm
Sorry my mistake.
As far as Ward = BB goes there shouuld only be patient CRN = "8888" in for one night on the 17th Jan and Patient "7777" in...
February 6, 2012 at 2:15 pm
Hi
Just to let you know i went with the linked access table solution as it works fine and also the maintenance if the data is done by the user...
December 28, 2011 at 8:47 am
OK thanks, I see what the Over is doing by counttng the rows depending on the grouping. This is fine.
Further to that I would like to also have an aditional...
October 4, 2011 at 2:21 am
They are, I'm trying to achive the results in my .txt file in one query.
The first part of my query is the bit i'm stuck with. It give sme the...
October 3, 2011 at 8:46 am
No, it's an addition. trying to work through this in stages. This is the last stage.
Sorry for the confusion.
October 3, 2011 at 8:32 am
Many Thanks for your reply
I have already added in your suggestion to the original query and it works fine.
I now need to add in the total numner of...
October 3, 2011 at 8:20 am
Many thanks for your speedy reply. Works fine.
The next think i was trying to achieve is to gain another column which has the total for each grouping period based on...
October 3, 2011 at 7:22 am
Hi,
Thanks for your reply and apologies for my poor exectution of this post.
Please find attached the Create table script below.
---------------------------------------------------------------------------------------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sample_data_for_SQL_Central](
[arrival] [datetime] NULL,
[atd_id] [float]...
September 27, 2011 at 2:54 am
Viewing 15 posts - 46 through 60 (of 103 total)