Forum Replies Created

Viewing 15 posts - 1 through 15 (of 140 total)

  • RE: looping help

    The final results will be below for table PolicyReviewLocks. PolicyNumber 10 and 14 doesn't exist so they are inserted. PolicyNumber 11 exists, so I need to be able...

  • RE: looping help

    anyone?

  • RE: help with effective dating logic

    Thank you everyone! I was able to use the Rank function to modify my script to account for all of the other records where the jobcode changes occurred not...

  • RE: help with effective dating logic

    Alan.B (8/10/2016)


    is250sp (8/10/2016)


    I have a table with the following records.....

    emplid effdt effseqjobcode

    00001068 3/27/200500241

    00001068 ...

  • RE: send mail stored procedure reply issue

    anthony.green (10/30/2015)


    Your ReplyTo is @To, that needs to be @From

    Also not a fan of sp_OA calls, they use memory outside of the SQL allocation, have you looked at converting this...

  • RE: multiple attachments

    Nevermind got it to work. Found the following script for multiple attachments. All I needed was to create a table-valued function called fn_split() based on this link

  • RE: pivot 3 columns

    Thanks Luis!

  • RE: pivot 3 columns

    Using this example, how do I UNION it to another similar script? If not is there a way to write the output to a temp table?

    DECLARE @SQL varchar(max)

    SELECT @SQL...

  • RE: pivot 3 columns

    Luis Cazares (8/22/2014)


    Something as simple as this:

    create table test

    (flsa_status varchar(30),

    bu_dept varchar(30),

    reg_temp varchar(5),

    ftpt char(2),

    value int)

    insert into test values ('Exempt Salaried','Corp','Reg','FT',43);

    insert into test values ('Exempt Salaried','Corp','Reg','PT',10);

    insert into test values ('Exempt Salaried','Corp','Temp','FT',12);

    insert into...

  • RE: pivot 3 columns

    Correct me if I am wrong but that example is doing a pivot on a single field. I am looking to pivot 3 fields.

  • RE: pivot 3 columns<!-- 864 -->

    That would work if my dataset was only those 4 records. In reality it's alot more and scripting a CASE for each one is not ideal. Also, if...

  • RE: output date to mm/dd/yyyy

    This is only my 2nd package so any help would be much appreciated. It's a very simple package consisting of a single Data Flow Task. Within the task...

  • RE: output date to mm/dd/yyyy

    anyone?

  • RE: output date to mm/dd/yyyy

    There is nothing between the source and target amd I am on 2005

  • RE: output date to mm/dd/yyyy

    I already have CONVERT( VARCHAR(10), column, 101) in my SQL command in my OLE DB Source. Also in my Flat File Connection Manager, the Properties for that column has...

Viewing 15 posts - 1 through 15 (of 140 total)