IIRC, there is also a difference in the dates in Excel and SQL Server.  Only problem is that I don't quite remember what the problem, had I haven't had much...

I have a standing offer on LinkedIn to promote anyone looking for work. I'll double down on that for Threadizens. I can actually say I know that you know...

Wow, sqlservercentral doesn't like MS Edge as a browser. You don't get the drop down from the Forums to let you select active threads or the like plus you get...

Well, I guess it's time to tell the community what I have known for about 8 months.  At this moment it looks like my last day at Parsons is definitely...

Where is the query plan?

USE [OTandE_Dev]
GO

/****** Object:  Trigger [heartbeat].[HeartBeat_SendEmail]    Script Date: 7/10/2020 10:00:28 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [heartbeat].[HeartBeat_SendEmail]
ON [heartbeat].[HeartBeat]
AFTER INSERT
AS
BEGIN
  /**********************************************************************************************************************************************************************************************
Trigger:  ...

Not sure why since you are using Database Mail, which uses STMP.  I have a trigger on a database...

I am curious why you want to convert the procedure to an SSIS package? Is the procedure not working as needed?

Business rule column in not a consistent one. I have given two columns as example. But it may contain 2, 3 or more column names under business_rule.

Yes, I tried...

I am going to take swag at why you see the what happens to a variable length nullable column created on an existing table with no default value.  The initial...

Using Mongo is a possibility, and JSON can be fairly easy to use. I personally have not used MongoDB but the product is used in development for a product we...

Also, when you have columns that have the same names except ending with a 1 or a 2, you may also want to look at normalizing the data into multiple...

Unfortunately, the only reply I see is Phil's latest one.  The one before that was flagged as SPAM.

But Phil is well known on this forum, so I doubt his...

Or this, hopefully I wrote it correctly as I currently don't have access to a SQL Server database to test:

select
  tab.name as 'TableName'
, ca.RowCnt as 'RowCount'
from
sys.tables...

Here is my first suggestion, load the output of the view IMPORT_RUN_EMPLOYEE_ATTRIBUTE_VIEW into a properly indexed temporary table and use that temporary table in the query since that view is...