If by "Base Date", you mean 0... 0 is shorthand for 19-01-01 00:00:00.000... aka midnight of 1/1/1900.
So DECLARE @t TIME = GETDATE(); SELECT DATEDIFF(MINUTE, 0, @t); is going to calculate...

Yea... It's damn near painful seeing people trying to do complex pivots using the PIVOT operator when it's so simple using the old cross tab method.
As far as using...

If anything, I'd verify with state/local HIPPA officials as there may be different rules at the state level that go beyond the federal rules. They should also be able to...

HIPPA's requirements for test data are no different than it is for your production data. If there's a data breach, Uncle Sam isn't going to care if the leaked information...

Jeff, It's always fun to see the same question posted on 2 different forums... Looks like out two solutions are pretty similar... At least in terms of the "CROSS APPLY...

Your WHERE clause isn't doing anything at all. It's literally checking to see if the date_last_updated is in the month that it's in.
Any idea what the calculated range is...

Something along these lines should do the trick...
SELECT
    cl.CustomerApplicationId,
    ApplicantName = MIN(cl.ApplicantName),
    FirstCallDate = MIN(CASE WHEN cl.CallResult LIKE '1st%' THEN cl.CreatedDateTime END),
    SecondCallDate = MIN(CASE WHEN...

What RDBMS are you using? ... AND a.FraudSpecialist = b.'Fraud Specialist'n isn't valid T-SQL syntax...
In any case, no matter what RDBMS you're using, it's typically helpful to script UPDATEs (and...

As others have stated, the objective isn't very clear... That said, I think the following may be what you're looking for...
WITH
    cte_Get20Questions AS (    
        SELECT TOP...

Here's a solution that only takes a single pass over the data an. I wish I could take credit for this solution but this is all Itzik... The Last...

Something like this?

WITH
    cte_OptionString AS (
        SELECT
            t1.OrderID,
            OptionString = STUFF(MAX(ox.OptionString), 1, 2, '')
        FROM
            #temptable t1
            CROSS APPLY (
                        SELECT
                            CONCAT(', ',...

I've been using SSMS 17.1 against SQL Server 2012 & 2014 instances w/o any issues.
Here is the download link: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms