Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: HHMMSS int field to human-friendly time?

    Plenty of solutions already in place and I tried to built something from all:

    select next_run_date,next_run_time,

    CONVERT(CHAR(8), next_run_date, 112)+

    CONVERT(datetime,STUFF(STUFF(RIGHT('000000' + CONVERT(VARCHAR(8), next_run_time), 6), 5, 0, ':'), 3, 0, ':'),108) next_datetime

    from dbo.sysjobschedules

    But, every...

    May 3, 2013 at 7:52 am

    #1612214

  • RE: Create dynamic feeds using SSIS

    Yes the format is same, using pipe separator.

    But its dynamic thing, based on table, there will be enabled flag, if its 1 then only pick up those queries to export...

    July 30, 2012 at 8:25 am

    #1519165

  • RE: Create dynamic feeds using SSIS

    Yes I think this should work out with BCP Utility

    And Yes this is recurring process, with same table from where queries and destination path will be picked up dynamically and...

    July 27, 2012 at 6:57 am

    #1518466

Viewing 3 posts - 1 through 3 (of 3 total)