I have a little bit of good news, sort of. I have managed to find work at Parsons that has extended my stay to the end of September.  Better than...

No promises but this should at least get you started.

-- The following table variables or for writing the code only, they should be replaced
-- with your tables...

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...

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...