Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: NikkieG
  • Content: Threads
  • Order by date
  1. NikkieG

    Picking Row with earliest date for each person

    Hi, Sorry if this is a really simple question, but it's been driving me mad all morning. I have a table where the data is in 4 columns: Person ID, Appointment Date, Postcode & Estate in which that postcode lies. I have several rows for each person because the postcode & estate change from...
  2. NikkieG

    SQL - Duplicate Rows

    Hi! I'm hoping someone can help with this as I am at the end of my tether! I have a table that contains patient data and each record has a cost attached to them. By looking at the patient ID, the date they were admitted and their treatment I have created a unique ID that can identify those...
  3. NikkieG

    Using results from a temporary column to calculate next column

    I am trying to get SQL to help me with age standardisation and confidence intervals, by 5 year age bands. I can get the data in to 5 year age bands, but as I use the count(*) function to get the number of cases I am finding I can't manipulate this column further. From the cases I need to...

Part and Inventory Search

Back
Top