I've done something like thisrequest, but via powershell; you have a lot more versatility there than pinging stuff via xp_cmdshell
regardless of where you do it, the logic is basically...

I didn't have your real table structure, but this is a best guess on if you HAVE to have a static table
CREATE PROCEDURE [dbo].[UpdatePayout]
@accountID uniqueidentifier
AS

my first reaction is thinking outside the corner you are painting yourself in.
a balance like that should be calculated on demand, as a query or as a view, so...

if you are only removing repeating header, you might consider using a  conditional split that tests the string;
then the conditional split can redirect the headers, or maybe do nothing...

the FK's point to the object_id of that lookup table,and not the name. you can see that is some of the sys views, like select * from sys.foreign_keys; the name is...

there are a number of "StripNonNumeric" functions here on SSC scripts section:
http://www.sqlservercentral.com/search/?q=StripNonNumeric

I would strongly recommend either of the inline table value function that Sean Lange or Alan...

Like Sue suggested, i use Powershell, as a scheduled job step to remove any abf files older than x number of days.
not sure how you are backing up, in...

is there any chance that when you installed Developer2016, you didn't install Integration Services? this screenshot shows the checkbox unchecked; i'd suspect that that might be issue. SSDT is the...

sounds like an order-of operations issue, right? insert into the parent tables, first, then move on to the tables that are FK'd to the tables.
the built in microsoft procedure...

you are probably looking to move an object to the other schema. THERE ALTER SCHEMA command lets you move a schemaname.object name into a specific schema.

if i "develop"...

not sure if it is related, but back when i had 2008/R2 instances, i had the built in procedure sp_spaceused return the same error, because i had some very large...

Just checking the basics, but is there any chance that the server you are connecting to is an Express instance, and not Developer/Standard/Enterprise?
If it were express, I'd expect a...

he said he is getting this error:

that means he's successfully connected to an instance.
so that...

Luis you posted your solution between the time i looked again; your's works as well, thank you!

OK walking away and doing a mental reset let me see my issue, or at least come up with a working solution
i *think* i had two things going on.