Here is a sample where the file is attached - and it will be sent regardless of any results found:

Declare @tab char(1) = char(9)
   ...

Here is a template I use for sending email notifications.  This embeds an HTML table in the email message...

Set Nocount On;

Declare @body nvarchar(max)
    ...

You cannot use the same name - as that is going to be registered in DNS and you cannot have the same name with different IP addresses on the same...

You can try running this:

Declare @nOrgID int = 67
      , @startdate date = dateadd(wk, -1, dateadd(wk, datediff(wk, 0, getdate()), -1))-- for saturday
...

• This reply was modified 6 years, 3 months ago by Jeffrey Williams. Reason: Added semi-colon at end of declare

Personally, I'm REALLY happy that the whole world hasn't adopted EDI.  IMHO, it's another hierarchical nightmare of data that's even worse than things like "packed decimal".

This is what I'm...

When I reformat your code to be more readable - this is what I get:

Declare @nOrgID int
      , @startdate date
  ...

I would use a report database in all environments that contains the same code - and can easily be reconciled using any of the many available comparison tools.  And if...

Unfortunately - the answer to your question is 'It Depends' 😉

Since table 2 does not have a defined constraint then you can have duplicate values at any level.  How you...

To me, it doesn't matter what the data provider uses so long as it's correct and consistent.  Delimited data is cool, especially if they include column names on the...

One idea:

Add every server to a group in Registered Servers in SSMS.  Then, open a query from that qroup which will open the query connected to every instance.

You...

One idea:

Add every server to a group in Registered Servers in SSMS.  Then, open a query from that qroup which will open the query connected to every instance.

You can then...

From what I have...

Thanks for the helpful replies

I had time to do some more research on this and found out about the need to have the same SID on each server, and...

There isn't any native way to mask data - you either have to build it yourself of purchase a product.  You should take a look at: https://www.red-gate.com/products/dba/data-masker/

I would also recommend...