Forum Replies Created

Viewing 15 posts - 16 through 30 (of 51 total)

  • RE: ssis ftp task, can i transfer txt or jpg files ?

    opps.. it worked...

    Its just i was searching at the wrong folder...

    sorry..

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/8/2008)


    Change CONVERT(VARCHAR(20)... to CONVERT(VARCHAR(25)... Some of the converted date is getting cut off.

    Successfully applied !

    Thanks a lot !

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/7/2008)


    Apologies, this is more than a bit later...

    ........ It's not tested, cause I don't have any sample data. It does parse fine.

    [/code]

    Thats why i wanted to send you the...

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/8/2008)


    How are you trying to mail the files? I can't offer much help unless I know what you're doing...

    With SQL 2005, Database Mail's probably the easiest to set up...

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/8/2008)


    How are you trying to mail the files? I can't offer much help unless I know what you're doing...

    With SQL 2005, Database Mail's probably the easiest to set up...

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/8/2008)


    Hmm. If you look at the printed out dynamic string, what does that last part (with the dates) look like?

    Regardng attaching excel, it depends how you're doing the mailing...

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (4/8/2008)


    Hmm. If you look at the printed out dynamic string, what does that last part (with the dates) look like?

    Regardng attaching excel, it depends how you're doing the mailing...

  • RE: are there "arrays" in sql 2005 ?

    Hi Gail ,

    Despite what i had notify i couldnt deny checking your code. Attached is the first part of your code with the last row causes an error message. It...

  • RE: are there "arrays" in sql 2005 ?

    Ho Gail,

    Thanks a lot and you are looking great !

    I haven't checked all the in and outs of your code but i noticed it contains a half the size of...

  • RE: are there "arrays" in sql 2005 ?

    Hi Gail

    And thanks.

    You think i didnt try to convert into date ? I did (before i saw your notification) and then i went into scope problems and now i'm learning...

  • RE: are there "arrays" in sql 2005 ?

    GilaMonster (3/29/2008)


    I'm still curious what you're doing with these created tables. Are the sales people selecting from them (and if so, can you change the queries they use)? Are you...

  • RE: are there "arrays" in sql 2005 ?

    Hi,

    If the so called "array" contains 3 names for example, those 3 names (salsemen) will get in his/her mail box an excel sheet contains a list of phone numbers. All...

  • RE: are there "arrays" in sql 2005 ?

    I'll do, when i'm finished in a day or 2.

    Thanks

  • RE: are there "arrays" in sql 2005 ?

    Mahesh Bote (3/29/2008)


    🙂 Don't try to do the things you like to do in project. Try those which project like. (I am talking in performance context, as Jeff has mentioned...

  • RE: are there "arrays" in sql 2005 ?

    Hi Jeff

    Using XML is a satisfactory resolution for me.

    There could of course be better solutions which are above my present comprehension and i admit i didnt understand all the suggestions...

Viewing 15 posts - 16 through 30 (of 51 total)