Well, Phil Parkin just because a word does not currently exist within any known dictionary does not mean it is not a viable word. In fact, Shakespeare is credited...

Then I cannot help, unfortunately.

Excuse my ignorance, but what is an EAP source?

No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol....

Correct.

If 'SerialNumber' is unique per employee, I suggest you add it to the local database and put a clustered index on it.

To do the sync, create a staging table locally...

As you suggest that there will be many queries on the local database which reference data maintained on the remote database, my advice would be 'sync' for sure. The lack...

As this is a SQL Server forum, you won't find many code-first people here. We like to design our DBs first 🙂

As you suggest, it seems that a good solution...

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