You are on the right track.

SELECT t.Testid
     , t.Status
     , t.Startdate
     , EndDate = DATEADD(dd,...

Your expected output is inconsistent.

That said, I believe that you need to look at the LAG function.

I would add a priority field and add it to the order  by.

So, using Scott's code, it would now look like this ...

SELECT d.ID, ca1.Amt, ca1.AmtReason
FROM #data...

I know nothing of JSON, but this looks like it is doingwhat you are trying to do

https://docs.microsoft.com/en-us/sql/t-sql/functions/json-modify-transact-sql?view=sql-server-ver15

This looks like you are trying to create a catch-all query.  You are on a slippery slope.

I have never worked with geometry data types before, but after a quick google,...

Functionally, there is no...

In order to help us to help you, please provide data in readily consumable  format (like this)

IF OBJECT_ID( 'TempDB..#Data', 'U' ) IS NOT NULL
  DROP TABLE...

You need to GROUP BY v.PatID, v.ProcValDate

Below is an expanded data set, with options to add "RN" by both the DateTime, and just the Date

IF OBJECT_ID( 'TempDB..#value',...

The only way to get rid...

• This reply was modified 3 years, 6 months ago by DesNorton. Reason: Code blocks 2 and 3 updated

Thanks will do... sorry for the delays in getting this info...

What about comment: from --frederico_fonseca " you are never going to go past that error - you are converting...

For starters, MAX ([Date_Started]), MAX([Time_Started]) needs to be modified to MAX([Date_Started]) + [Time_Started]).  The actual calculation will depend on the data types of the 2 fields.

Also, be aware that UNION will be much slower that UNION ALL, as it will only return a DISTINCT result, which requires an additional sort operation

You could find all of the columns sys.columns, but there is no way to know which ones are alligned.

So, as far as I know, you have to do it manually.

select...

As a perf update, you can use the following code for extracting Title.

C.x.value( '(title/text())[1]', 'varchar(100)' )

I am not an XML expert, but this was a tip that...

I seem to recall a rule in place that if 3 posts for the same user are flagged as spam, the user automatically gets disabled.  Is that rule still in...