No time outs or errors yet, fingers crossed, knock on wood, salt...

Just dawned on me, kind of a deja vu, here is around six years old thread on the same subject.

😎

Quick thought, is it this you are looking for?

😎

SELECT DATEADD(HOUR,735510.40461,'1900-01-01 00:00:00.000')

Result

1983-11-28 06:00:00.000

The time element

SELECT CONVERT(TIME,DATEADD(HOUR,735510.40461,'1900-01-01 00:00:00.000'),0)

Result

06:00:00.0000000

Looks good to me, you might want to construct the filename in the same procedure, i.e.

DB_NAME() + NCHAR(44) + OBJECT_SCHEMA_NAME(ASM.object_id) + NCHAR(44) + OBJECT_NAME(ASM.object_id) + N'.sql'

😎

Quick question, any functions or operators used in the code? Many do have 8K limits. Also look out for implicit casts.

😎

Quick thought, Task Manager is lying.

😎

Chipping in my 2 Cents, it is close to impossible to validate a phone number without a geographical reference, with it, it can still cause an headache.

On the OP,...

Quick though, use COUNT with the same OVER clause as the row number (here in pietlinden's code)

😎

SELECT [groom_first_name]

,[groom_last_name]

,[bride_first_name]

,[bride_last_name]

,[wedding_date]

,[contact_email]

FROM (

SELECT

[groom_first_name]

,[groom_last_name]

,[bride_first_name]

,[bride_last_name]

,[wedding_date]

,[contact_email]

,ROW_NUMBER() OVER (PARTITION BY [contact_email] ORDER BY [contact_email]) AS rn

,COUNT(*) OVER...

Quick thought, you can use something like the relevant part in this script

😎

SELECT

DB_NAME() ...

Adding a little bit of tinkering based on the operator cost results in the previous post, mainly changing from the CASE to a WHERE clause for filtering. Not a big...

You should still change the data type...

If you do then the trigger should work. Can you post a DDL (create table) script for the table?

😎

Quick question, can you change the data type for the commenthtml column from TEXT to NVARCHAR(MAX)?

😎

Quick thought, normally would do this using VBA function wrapper, especially if the output spans multiple cells and/or the procedure has parameters. Very powerful stuff if done properly.

😎

Chipping in my 2 cents, using a version / source control is good where it is applicable or possible but when it isn't, a combination of bcp and a simple...