Forum Replies Created

Viewing 15 posts - 61 through 75 (of 85 total)

  • RE: Index seek and Index scan

    Thanks Roy.

    What about (b) and (c).?

    Thanks

    L

  • RE: Index seek and Index scan

    Hello Brandie,

    But i did not understand...

    Please explain in Detail.

    I have created indexes today so i want to make sure I am right or not ?

    Thanks

  • RE: SSIS Deployment

    Thanks for your reply 🙂

    I am looking for solution ....So i have so many to thing to figure it out.....

    Anyways.....Thanks again,,,

    Thanks

    L

  • RE: File System Task

    Thank for replying me ,..

    but you can do it by for each container and file system task ....

    Thanks

    L

  • RE: SSIS Deployment

    Thanks for replying me.:-)

    So can i upgrade sql server 2005 to sql server 2008.

    I have 8-10 different Databases and they are used by others,

    I am using only one database ....can...

  • RE: File System Task

    THanks for replying me

    but I need a specific example.

    please any one can provide me Detail.

    THanks

  • RE: calling SSIS package

    Thanks.:-)

    I also want to know how to do with sql server agent Job ?

    can you provide me complete Details ?

    Thanks

    L

  • RE: calling SSIS package

    Thanks for your reply....:-)

    I want to run 10 packages and they are different and not depend on each other.

    So if one package fails in sequence container but i want to...

  • RE: calling SSIS package

    Thanks You so much for replying me 🙂

    @tom you were saying that I have to create another package(12th package)....In this package , I have to wrap all...

  • RE: Duplicate

    You are saying that sql server generate a query randomly

    like

    ACCT_ID ACCT_NO ACCT_NAME ACCT_ROW

    1 11 ABC 100.......................................(yesterday)

    1 11 ABC 101.......................................(today)

    2 12 XYZ 102.......................................(yesterday)

    2 12 XYZ 103.......................................(today)

    or

    ACCT_ID ACCT_NO ACCT_NAME ACCT_ROW

    1...

  • RE: Duplicate

    Can i know how to add extra field and how can i identify today_acct_id.

    Thank

    L

  • RE: Duplicate

    ACCT_ID ACCT_NO ACCT_NAME ACCT_ROW

    1 11 ABC 100.......................................(yesterday)

    1 11 ABC 101.......................................(today)

    2 12 XYZ 102.......................................(yesterday)

    2 12 XYZ 103.......................................(today)

    I don't want pick acct_id rendom.

    I want acc_id updated one.

    like ouput

    1 11 ABC...

  • RE: Duplicate

    I want my output based on acct_id

  • RE: Duplicate

    I want to make acc_id as primary key so i need to remove duplicate...

    as per my rek,,,

    I want only latest one( last row)

    like ..

    acct_id

    1--1st row

    1--2nd row

    and I want a...

  • RE: REMOVE DUPLICATE

    Thanks:-)

Viewing 15 posts - 61 through 75 (of 85 total)