I have not modified the variables or filenames or folder locations since it was last working last week.  The file name is setup in the For Loop and now with...

I have taken the csv files that SSIS is supposed to import and manually imported into SQL.  I have a second SSIS pcakge that takes this data, manipulates it, then...

Holy crap it worked.  Thank you so much!!

Yes it's definitely SFTP. Will look into the alternatives you suggested thank you.

The order by column is in TableA as well. Think this is my issue.

I need to grab the sequence number from TableA not Table B.

I went into a completely different way and used variables.

ALTER proc [dbo].[SG_AddEmailSignaturesNewUsers]

as

DECLARE @SeqNo int, @DefaultSignature varchar(MAX)

SET @SeqNo=(select max(Sequence) from TableA)

SET @DefaultSignature=(select Signature from TableA where UserName='me' and IsDefault='Y')

insert into TableA

(Sequence,Title,Signature,IsDefault,UserName)

select...

My apologies. The reason I'm referencing Table A twice is that I need to insert the column values for Title and Signature to all the inserts from one specific...

I downgraded my Management Studio to 2012 and it's working now. Silly SSMS.

This is not my database, nor my tables. I cannot modify the existing table structure as that will have an impact on the application that updates this table. Plus...

What I ended up doing is making 2 selects (select monthlybalance up to @EndDate and then another from @EndDate to @StartDate+11 for a full year) then union'd the data. Now...

Everything worked great for this cross tab. I now have to modify it slightly, but it's now giving me multiple values per month because of my additional syntax.

Example @StartDate='2015-11-01',@EndDate='2016-05-01'

What...

I think I have it with the Cross tab. I added the additional fields, then a Group By as well as adding "as 'Nov' to the first Sum then...

I'm using the results of this sp on a Crystal Report. I'd like to simply drag in these 12 values onto the details of a report. I have...

I tried this code but the only results I get is a single line of 12 columns with $0 and (no column name) as the column name for each. Should...