@ peter SSC Enthusiastic

I apologise for the upper case letters in my last post,I was multitasking it wasn't meant to be rude

The ACTUAL PROBLEM IS GETTING A TABLE TO DISPLAY A 28 DAY READMISSION RATE, THE PARTITION DOES HELP IN SORTING THE DATES BUT HERE LIES THE PROBLEM WHEN YOU USE...

I just used the example of the data created by someone else, my query does use the actual field names and its about admissions and discharges. But there is a...

Hi

The table above identifies my problem, it reuses the end date and start date. Thus having multiple entries for a date instead of having a few entries only and...

ItemID OldPrice RangePrice ...

The code only takes into account one coulmn for dates, while I have two columns for date the first being an entry date the other being an exit date, I...

Hi

while the forum does try to aid things, some of us (me) are quite new to this, and would appreciate help. I have tried to tweak the code from the...

Thanks very much for the article I found it very useful,

I use data which has to do with readmissions, and I can figure out how to use the code for...

Hi

I have read the new link and still am slightly out of my depth, please could you just give pointers on how to get the table into the desired structure...

My apologies if it seems like I did not read the articles but I did read them but was out of my depth, while I have been learning the creation...

No idea about the clustering but my last post describes the national table

storeidstore_nameIT_Cluster_coderegional_codeAddress_Line_1Address_Line_2Address_Line_3Address_Line_4Address_Line_5zipcodeOpen_DateShorthand

Hi

pls clarify what you mean by table definitions

ta

typenumdenomratequarterstoreiddepartment

xps131250.104Q3 0910chixt1

xps181040.173Q4 0910losst1

xps2150.133Q1 0910atlat1

xps12550.218Q2 0910nycnt1

xps19830.229Q4 0910RXHrt1

and that gives something like this

the first table looks like this :specialist view

select type, num, denom,round(cast(sum(num)as float)/cast(sum(denom) as float),3) rate ,tab1.quarter, tab1.storeid,tab2. department

from

(select type,sum(product) num, storeid,department

,quarter

from normalising_births_table2 tab1,dbo.Lookups_NHS_National_Trust_Sites a

where provider = Organisation_Code

and ...