Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • Reply To: How To Avoid MERGE in SQL Server

    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...

  • Reply To: A genuine use for a SQL CLR Aggregate

    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...

  • Reply To: A genuine use for a SQL CLR Aggregate

    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...

  • Reply To: A genuine use for a SQL CLR Aggregate

    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...
  • Reply To: A genuine use for a SQL CLR Aggregate

    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...

  • Reply To: Using Big Data to Improve Health

    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...

  • RE: Performing a Right and Comprehensive Age Calculation

    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,...

Viewing 7 posts - 1 through 7 (of 7 total)