Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 13,879 total)

  • Reply To: HASHBYTES giving different resaults than yesterday

    astrid 69000 wrote:

    Yes, but yesterday I was getting C0FB8B944A767E1AACE82F930D95E69ED912ADAD using the same, and today using the same SSIS process we also got C0FB8B944A767E1AACE82F930D95E69ED912ADAD.

    Are you suggesting that if you could go back...

    June 8, 2021 at 1:33 pm

    #3893421

  • Reply To: HASHBYTES giving different resaults than yesterday

    If I run this

    SELECT CurrencyHashKey = CONVERT(CHAR(40), HASHBYTES('SHA1', LTRIM(RTRIM(COALESCE('USD', '')))), 2);

    I get

    57814CFBAE5C6D00F5CAB49E34B9AA2CE8269EB9

    June 8, 2021 at 1:24 pm

    #3893414

  • Reply To: Error while altering SP

    Without knowing more about dbo.[spAmount_V1], I can't do that.

    Please post the 'signature' of that proc. That is, the following bit

    CREATE PROCEDURE <procname> <parameters>

    AS

    In particular, you should have an OUTPUT parameter...

    June 8, 2021 at 8:16 am

    #3893283

  • Reply To: Error while altering SP

    Stored procedures return results differently from functions. Here is an example proc and how to call it:

    CREATE PROCEDURE dbo.DuffProc @RetValue VARCHAR(50) OUTPUT
    AS
    BEGIN
        SET @RetValue...

    June 7, 2021 at 9:29 pm

    #3893135

  • Reply To: Insert data using view

    Try changing this part

    (SELECT BirthYear = n + 1921, Age = YEAR(GETDATE()) - n - 1921) calcs

    JOIN GroupInfo g

    ON calcs.Age

    BETWEEN g.StartAge AND g.EndAge

    ORDER BY Tally.n DESC;

    to this

    (SELECT...

    June 7, 2021 at 4:25 pm

    #3893042

  • Reply To: Insert data using view

    piu.scorpio wrote:

    Hi @SSC Guru

    I Just get a list of Distinct birth years from Customer table. So then based on that list I need to further calculate the other values

    June 7, 2021 at 2:48 pm

    #3893006

  • Reply To: Insert data using view

    As you have not provided any DDL or sample data, and your sample results do not appear to include a single reference to your customer data, I had to guess:

    June 7, 2021 at 2:05 pm

    #3892974

  • Reply To: Updating and Loading Data using SSIS

    I cannot not see any question here.

    June 3, 2021 at 8:41 pm

    #3891652

  • Reply To: How to Insert Column in and existing table

    OK, understood. Unfortunately, I do not have time today to help any further. If no one else answers in the meantime, I will try to get back to you in...

    May 28, 2021 at 4:03 pm

    #3889294

  • Reply To: SSIS Package loading CSV failing

    Are there embedded carriage returns in that file?

    Have you set a text qualifier? (")

    May 28, 2021 at 4:00 pm

    #3889279

  • Reply To: Invoking .dtsx file via Excel - different behavior

    As packages usually run within the context of an unattended process, message boxes within them should be avoided (unless developing or debugging).

    I notice you mentioned users running this. For them...

    May 28, 2021 at 1:26 pm

    #3889220

  • Reply To: How to Insert Column in and existing table

    Also, how is the value of ColumnType determined?

    May 28, 2021 at 1:13 pm

    #3889219

  • Reply To: How to Insert Column in and existing table

    OK, that helps.

    So you are looking for a routine which imports only the first row of a spreadsheet/CSV file, transposes that row of data into separate rows and adds them...

    • This reply was modified 5 years, 4 months ago by Phil Parkin.

    May 28, 2021 at 1:11 pm

    #3889217

  • Reply To: Invoking .dtsx file via Excel - different behavior

    How are you displaying the popup? You need to display it from Excel, not from within the package.

     

    May 28, 2021 at 12:13 pm

    #3889176

  • Reply To: How to Insert Column in and existing table

    The columns in the spreadsheet do not appear to correspond to the columns in your screenshot, making this a bit of a puzzle.

    Why not just hit 'TRANSPOSE' in the spreadsheet,...

    May 28, 2021 at 12:08 pm

    #3889175

    • Viewing 15 posts - 2,026 through 2,040 (of 13,879 total)