Forum Replies Created

Viewing 15 posts - 61 through 75 (of 103 total)

  • RE: grouping issue (I think?)

    Hi

    Following on from R.P.Rozema's post I have attached a copy of the data I'm working with.

    Also below is my original query based on the attached dataset.

    R.P.Rozema is correct...

  • RE: grouping issue (I think?)

    Thanks for your speedy reply.

    I've tried to be clever ( i should know better by now, not to go for shortcuts) and give you sample data, when perhaps i should...

  • RE: I need to improve this query I have attached here

    could you not use the ICD10 and or OPCS codes. I'm presuming you work in a Hosp.

    Thanks

  • RE: 95th percentile

    Hi, I back and and I think I'm 95 percentile there. (excuse the pun!!!):-)

    I have needed to replicate the percentile function in EXCEL which uses interpolation which gives slightly different...

  • RE: 95th percentile

    Ignore my reference to median ( i was thinking about another query i'm struggling with )

    I need to get the 95th percentile for each months figures.

    Thanks

  • RE: 95th percentile

    struggling with this one now.

    I have taken the script supllied earlier in thread and added some month_names to the figures in the test data.

    I have also removed the declaring of...

  • RE: 95th percentile

    Thanks to Davin21 (and everyone elses comments) That seems to work fine.

    I need now to add group the result by a month and/or field.

    I am a bit unsure as...

  • RE: 95th percentile

    Thank you all for your replies.

    I now have the definition from which i am expected to work to.

    "The 95th pecentile is taken as the value at position "0.95 x(number...

  • RE: 95th percentile

    OK, perhaps my sample data wasnt the best example I could have used. I found this which i think may help.

    "The algorithm is as follows: collect all the data...

  • RE: 95th percentile

    cribbed this from another web page but feel that it explains it fairly well.

    "Basically the 95th percentile says that 95% of the time, the usage is below this amount. Conversely...

  • RE: median calc?

    Many Thanks

  • RE: 2nd highest value in dataset

    Many, Many Thanks

    Works a treat.

  • RE: 2nd highest value in dataset

    My mistake, I have put the wrong date in the expected reuslts.

    should read as follows.

    your solution does the job but i need to exclude any rows where the datediff...

  • RE: Internal clock times and datediff query

    Many Thanks. All sorted now.

    Dont ask about the key, we're linking to a very old system and thats the key it uses. it is a one off job so performance...

  • RE: Text to Columns in SQL

    Many Thanks to everyone

Viewing 15 posts - 61 through 75 (of 103 total)