They are different characters and therefore multiple nested REPLACE commands would be required.

DECLARE @x VARCHAR(50) = CONCAT ('Some''', CHAR (96), CHAR (145), CHAR (146));

SELECT @x
  ...

• This reply was modified 3 years, 3 months ago by Phil Parkin.

First of all, I have some suggestions for your existing query.

• To obtain a DATE from a DATETIME, simply use CAST(x as DATE). Try to avoid using number-to-character-to-number conversions, because...

As you already have the results in #temp, the query can be written as follows

WHERE contains(c.partitionKey, "BillingEncounter/17792") 
AND EXISTS (SELECT 1 FROM #temp t where t.EncounterId =...

So, in your example, you'd have

D, 60, CDT

entered automatically.

How is this row going to be used in future? Is there anything special about this row which identifies it as a...

I thought that someone else would pick this one up as a nice challenge, but you've been unlucky! Here is some code which should help you progress. I've used a...

Thanks, Dennis... that was my exact first impression and for the very reason you stated... The word "but".

How about the rest of you good folks... did anyone else have...

I don't think that is going to work. The only items I can add to an SSRS project are reports, data sources and datasets. I can't even create a folder.

One...

Check this link: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

and look...

Seems clear enough. What is your question?

Here is an example of a post which does what I am asking, for info:

https://www.sqlservercentral.com/forums/topic/sum-2-column-by-group

OK, but no one outside of your company can run that. The reason for my specific request was so that anyone can paste the CREATE TABLE / INSERT commands into...

Can you provide DDL (ie CREATE TABLE commands) for the source and target tables, please?

Can you also provide INSERT statements which will populate your source table with the sample data...

That looks impossible to me, based on that table structure, because it is only recording a partial history of what happened.

For example: if an employee starts in div A, moves...

Here is one way

SELECT TOP (1) <column converted to date>, other columns
FROM table
ORDER BY <column converted to date> DESC

The only rows you will be able to delete are those which have no 'children'.

DELETE EVACUATION E2 
WHERE NOT EXISTS 
(
SELECT 1 from EVACUATION E WHERE E.COD_EXP_CHG...