Are you deploying the project every time you update the string format in the...

If you can't solve the problem with indexes or by using a partitioned heap, you can always switch the partition to an empty table and then truncate it. The table...

Fast load with table lock will attempt to insert with minimal logging, but there are requirements of the destination table. I believe that even in a full recovery model the...

Does it work when you run the procedure from SSMS? What error do get when it fails from SSIS? If the procedure has three parameters and the third one is...

Never mind, my message was 3727, not 3737.

Is there a lock on the table? I got the same message number when I cancelled a drop constraint query which was waiting...

• This reply was modified 3 years, 1 month ago by Ed B.

This is pretty ugly. I didn't want to hard code the column names so  used a dynamic sql output variable to get the list of ids to be updated. If...

try this. or NUMERIC

TRY_CAST(MASTER_BOL_NUMBER AS INT)

ISNULL(TRY_CAST(MASTER_BOL_NUMBER AS INT),0)

• This reply was modified 3 years, 1 month ago by Ed B.

Is this the output you want? I wrote a script to generate it, but it is ugly because I assumed the ID columns in the tables to be updated have...

Are you trying to identify the stored procedure that should insert data into your empty table "auditLevyBreakdown"?

Does this return anything? I see the procedure names start with sp, is there...

You said this expression is inside a Visible property of an object. So when the IIF expression returns True, the object is visible. When the IIF expression returns False,...

I think that the Visibility property has three options, Show, Hide, or Expression. If an expression is used the result determines whether to hide the object, not whether to show...

Can you CAST(ar.AR_STORE AS INT) to drop the preceding zeros and allow the join?

• This reply was modified 3 years, 1 month ago by Ed B.
• This reply was modified 3 years, 1 month ago by Ed B.

What do you want the job to so if the SSIS package fails? You can set the properties of FailPackageOnFailure and FailParentOnFailure to false for all objects within the package....

If the second table has a trigger that writes to itself, what would stop it running to infinity if it didn't error out at 32?

When the trigger does not generate...

The easiest approach is a recursive cte. I tried to come up with a non recursive solution. I found one that works with this data, but it makes assumptions about...