Forum Replies Created

Viewing 15 posts - 136 through 150 (of 259 total)

  • RE: DTS Forum

    Great! Thanks a lot. 😀

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 21, 2008 at 9:02 am

    #780706

  • RE: Delete DTS package versions

    Thanks alot that did it.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 20, 2008 at 3:40 pm

    #780439

  • RE: Delete DTS package versions

    Yes I am.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 20, 2008 at 3:15 pm

    #780430

  • RE: Delete DTS package versions

    Would you know why I cannot see the sysdtspackagelog table? If I run the following command:

    SELECT *

    FROM sysdtspackagelog

    I get a empty recordset back. I am using the SQL...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 20, 2008 at 10:48 am

    #780313

  • RE: Narrow down the recordset

    After some exhaustive anaysis on the underlying data, I found that it was a data issue. Once I fixed that, these procs worked just fine. I would like to thank...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 20, 2008 at 6:27 am

    #780166

  • RE: DTS 2000 Active X Script file copies

    Can someone please help me on this?

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 19, 2008 at 5:51 am

    #779669

  • RE: Narrow down the recordset

    That is totally correct. I implemented the CASE statement and now I lost all the repromote flags.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 1:58 pm

    #778089

  • RE: Combing two dates into on column

    Correct,it for a report.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 1:36 pm

    #778069

  • RE: Narrow down the recordset

    Another though maybe this is a place for some sort of CASE statement like:

    CASE Repflag =

    WHEN RepFlag = (Select Repflag From #Temp WHere r.ConsultantID = d.COnsultantID )...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 1:36 pm

    #778067

  • RE: Combing two dates into on column

    I need to display the dates displayed in this format but they will not used for calculations.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 1:28 pm

    #778059

  • RE: Narrow down the recordset

    Can we do something along these lines although my logic is not right but may be it will help clarify what I am after (See Bold):

    Select 'OrigConsID' = @ConsultantID

    ,(Select ConsultantName...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 1:26 pm

    #778057

  • RE: Narrow down the recordset

    Yes I tried that code and the works fantastically in the Repromote Proc. I think the issue lies in the fact that in the Main proc, its not joined properly...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 12:36 pm

    #778024

  • RE: Combing two dates into on column

    This works great,thanks.

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 12:09 pm

    #778002

  • RE: Narrow down the recordset

    yes, everything from table d needs to come across. Maybe I don't need the LeftOuter Join to the #temp table but it was what I thought would work because that...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 11:58 am

    #777998

  • RE: Narrow down the recordset

    I think I found the issue, it is not the repromote procedure its in the main proc (See bold). I think it needs to be changed because it is looking...

    Thanks,
    Art
    Database Analyst
    Tastefully Simple, Inc.

    alorenzini@tastefullysimple.com
    " Some days, it's not even worth chewing through the restraints!

    February 13, 2008 at 7:43 am

    #777826

Viewing 15 posts - 136 through 150 (of 259 total)