hiding the row does work.

works for me. Thank you peitlinden 🙂

I switched to using INSERT OPENDATASOURCE instead of OPENROWSET since the former doesn't require having a linked server set up. 
Process involves creating a template excel that is permanently...

Thank you Scott Coleman, I'm following the instructions  within link. 
I haven't succeeded yet, because I need a linked server and I need someone with Admin permissions to create...

yes, this is good advice.  From now on I will use DELETE TOP (10) .....usually I do the SELECT first before I run the DELETE but *this time* for some...

I hate WHERE EXISTS.  I have always had trepidation with it.....!

the UPDATE should happen if a NULL is found, which should be all records on the join (they are harvested into the reporting 'stg' table on the basis that they...

michael.cole 47030 I like the update statement you suggest and...

Hi sgmunson , thanks for replying.
Yeah, but @ReportDate is

@ReportDate ...

Chris Wooding
No, not all possible that the ShipmentsClaims table is empty.

One change I made yesterday was to add an ELSE statement to the UPDATE, and I included...

this is a discouraging. Everyday there is data in the #temp table (verified because the SSRS report is sent out with data (SELECT * FROM #TEMP)
Daily I am having...

Lynn Pettis thanks.
 I've added
CREATE NONCLUSTERED INDEX ix_ChubSContact_RowId ON [dbo].[CHUB_S_CONTACT](ROW_ID) INCLUDE...

Jeff Moden 
This simple query I shared in opening post is being used as a *subquery* in a view,...

Jeff Moden  regarding the "NCI_CHUB_S_CONTACT_01" is crazy.  Shy two columns, it basically covers all columns and every time I run...