thank you so much for the reply

• This reply was modified 17 hours, 40 minutes ago by krypto69.
• This reply was modified 17 hours, 40 minutes ago by krypto69.

Thank you so much for the reply but I'm getting an error:

Msg 205, Level 16, State 1, Line 1

All queries combined using a UNION, INTERSECT or EXCEPT operator must have...

Ah I see the light!

Thank you SO much Scott - great explanation!

Thanks again!

HI Scott

yes, there is an MBI column in table PEC_RGT_EDI_834_Inbound_Exception.

Is there a better way to write this - guess Im still not fully understanding why it works and how I...

In case this helps someone else someday:

this works

ABC.mydomainfullyqualified.com\ABC

Thanks Jo.

I'm residential (local SAN - on premise) no cloud.

So the current recommendation is to not even do rebuilds?

ended up writing the results to a table in a different DB via a job and granted access to that table. works fine.

Thanks Perry/Fredrico.

Ahh great catch Jeffery! Much thanks!!

ahh persisted...hmm its not used that much so maybe overkill for this.

I like the two left joins - trying that now.

Thanks Phil - appreciate the help!

Kinda yeah - feel my pain

I know there is a translate function that can sometimes be used in place of 'replace' but I'm on v120. So no easy way out...

• This reply was modified 2 years ago by krypto69.
• This reply was modified 2 years ago by krypto69.

Yeah I tried the try cast - didn't work.

I just removed the formatting - fine for now.

Thanks guys!

this works - but I loose the formatting

SELECT
DISTINCT
    provTaxID
   ,provNPI
   ,provName
   ,provShortName
   ,'https://npiregistry.cms.hhs.gov/registry/provider-view/' + provNPI BillProvURL_NPPES
...

I think I just may be stuck with "it is what it is" - I know its a ton of records. Really just wanted to make sure I tried everything...

• This reply was modified 2 years, 1 months ago by krypto69.

Sure, logical assumption and my fault for not specifying

It returned in same time..