The database we use at the hospital that I work for is over 50 years old and is still being developed! Does this make it one of the oldest database...

Hi. What are the advantages of this approach as opposed to using a MERGE statement?  We use MERGE statements extensively as part of our data warehouse's ETL processes and I've...

Hi Des,

Sorry, I got the left join to Fact_Referral in the wrong place in the code I posted.  I've changed the order in my post.

I tend to use left joins...

Hi Jeff,

Hi took a four column data set containing waiting times measurements with 1,006,934 rows and then used the median function to calculate the median wait.  The query execution took...

• This reply was modified 5 years ago by  stephen.lightfoot.

Wouldn't let me upload file so here is the code:-

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using System.Collections;
using System.Collections.Generic;
using System.IO;

[Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedAggregate(
        Format.UserDefined, //Binary...

• This reply was modified 5 years ago by  stephen.lightfoot.

Hi,

I'm a bit late to this discussion but we had a requirement to work out median values in SQL this week so I was looking for a method to achieve...

Hi,

You're wrong on point 4.  There is a central database for medical records in the shape of the Secondary Uses Service (or SUS for short).  This database is managed centrally...

I too have struggled with this in the past.  The easiest and fastest way I have found to do this is by using the function below.  It works every time,...