Viewing 14 posts - 61 through 74 (of 74 total)
Yes it's definitely SFTP. Will look into the alternatives you suggested thank you.
September 5, 2017 at 8:38 am
The order by column is in TableA as well. Think this is my issue.
August 25, 2016 at 10:11 am
I need to grab the sequence number from TableA not Table B.
August 25, 2016 at 10:06 am
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...
August 25, 2016 at 9:46 am
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...
August 25, 2016 at 8:33 am
I downgraded my Management Studio to 2012 and it's working now. Silly SSMS.
August 25, 2016 at 8:07 am
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...
August 24, 2016 at 1:41 pm
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...
August 4, 2016 at 6:59 am
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...
August 3, 2016 at 12:33 pm
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...
August 2, 2016 at 2:15 pm
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...
August 2, 2016 at 2:05 pm
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...
August 2, 2016 at 1:58 pm
That's actually my post that I initiated but didn't get a response that worked for me. Still have the issue. I've tried 4 other forums.
December 15, 2015 at 9:51 pm
Viewing 14 posts - 61 through 74 (of 74 total)