Because I don't have to know T-SQL inside out and upside down in order to use R for something that SQL won't even do.

flip it around, do IF  dbo.ISOyear(@DatumBegin) >=2018 BEGIN <select from the CTE as written with your SELECT right after> END ELSE BEGIN...

Stupid question maybe, but why bother? If you're converting it to junk data, then why not just convert to junk data, and stuff "lorem ipsum" into it or similar? Why...

Hi Ben, what are you trying to match up, exactly? You're trying to find out if a table is used within a view? You are saying the name and order...

I wouldn't say this is impossible, Diana, but it might be impractical. Reasoning - updates to ICD9, CPT and practice guidelines may mean that you have to redesign your "generic"...

can you post the formula you changed it to? Hard to troubleshoot the error if we can't see it

Is there a reason you want to split it? Are you splitting it on a value, or just trying to create a page break or something?

This is why I hate quantum computing

Can you add a table? Our system has audit tables that capture the before/after picture. Basically exact same columns as your actual project table, with Changetype and TimeOfChange columns added...

old thread, but I'll add my two cents. I have also corrected by opening the xml and fixing it in Notepad++ or similar, works fine that way too.