Viewing 8 posts - 1 through 8 (of 8 total)
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...
December 9, 2020 at 9:37 am
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...
April 15, 2020 at 7:33 am
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...
December 16, 2019 at 11:39 am
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...
December 13, 2019 at 4:51 pm
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...
December 13, 2019 at 2:26 pm
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...
December 13, 2019 at 2:25 pm
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...
September 30, 2019 at 12:53 pm
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,...
March 28, 2017 at 3:48 am
Viewing 8 posts - 1 through 8 (of 8 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy