Forum Replies Created

Viewing 15 posts - 76 through 90 (of 202 total)

  • RE: long Date Problem - insert and search between tow dates

    hi but in the first you say to do this

    -----------------------

    SELECT * FROM SilokE WHERE ((SilokE.mhlka) Like ('3'))

    AND (((SilokE.id) Not In

    (select id FROM sn WHERE sn.fld2 in (1) and

    ((sn.fld1 >= '10/05/2006...

    May 12, 2006 at 6:29 am

    #637516

  • RE: long Date Problem - insert and search between tow dates

    THX

    but the main problem is how to insert properly ????

    i work  i web page (vbscript) the form of the insert is like this

    and i dont add the second +  millisecond

    -----------------

    May 11, 2006 at 1:35 pm

    #637385

  • RE: long Date Problem - insert and search between tow dates

    THX

    do you think thet like this it work ????????????

    ---------------------------------------

    SELECT * FROM SilokE WHERE ((SilokE.mhlka) Like ('3'))

     AND (((SilokE.id) Not In

    (select id FROM sn WHERE sn.fld2 in (1) and

    ((sn.fld1 >= '10/05/2006...

    May 11, 2006 at 12:54 pm

    #637374

  • RE: import a complex data from one table to another table

    this is a win format

    what is

    CR+LF ??????

    what to do ?

    ilan

    March 21, 2006 at 3:10 pm

    #627979

  • RE: import a complex data from one table to another table

     they  become like the example  above

    can you help me how to solve  the problem

    instead of  QUOTE  OR clue

    thnks

    ilan

     

    March 21, 2006 at 2:46 pm

    #627973

  • RE: import a complex data from one table to another table

    this is the problem whan i import from file with ROWTERMINATOR

    my  rows DONT become columns !!!!

    -----------------

    203,TYPE: SINGLE PARTY LINE  SNPA: 304   SIG: DT    LNATTIDX: 23                LINE EQUIPMENT NUMBER:     AKVA  07...

    March 21, 2006 at 7:20 am

    #627860

  • RE: import a complex data from one table to another table

    how to import from table with

    ROWTERMINATOR  ???

     

    did ROWTERMINATOR work only on file ?

    or i can use it on table in sql server ???

     

    ilan

    March 21, 2006 at 7:04 am

    #627850

  • RE: import a complex data from one table to another table

    i tray to import it with rowterminator

    but because the difference between one record to another

    i the the row number

    and because the line 'DN:'

    it appear evry 11 or 16 rows approximately

    thre...

    March 21, 2006 at 4:14 am

    #627820

  • RE: is possible to import from text file with cursor ??

    thnks

    how to insert each line to each filed in one table ??

    like this

    -------------------------------------

    table1

    DN:        |  TYPE: | SNPA: | LINE EQUIPMENT NUMBER: |  LINE CLASS CODE:

    6361002  |  aaa    |     bbb |cccc                               |    dddddddd

    999999   |ffffff   ...

    March 20, 2006 at 12:10 am

    #627503

  • RE: is possible to import from text file with cursor ??

    hi

    need help

    can you show me how to do it

    thnks

    ilan

    March 19, 2006 at 3:09 pm

    #627488

  • RE: how to count rows with Where

    yes yes

    it work

    thnks for all the wonderful group in this forum

     

    ilan

     

    March 14, 2006 at 7:01 am

    #626487

  • RE: how to count rows with Where

    yes i need to see the row number

    but how to do this with "WHERE" ??

    like this

    -----------------

    select a.au_fname, a.au_lname, a.state,

    (select count(1) from authors where au_fname <= a.au_fname and au_lname <=...

    March 14, 2006 at 5:16 am

    #626458

  • RE: how to count rows with Where

    so

    no one

    know

    to count rows with "Where "

     

    thnks

    ilan

    March 13, 2006 at 11:47 pm

    #626421

  • RE: how to count rows with Where

    no it not work ok

     i get

    1

    1

    2

    2

    3

    4

    4

    --------------------------------

    i need to cout the rows in the table

    like this

    1

    2

    3

    4

    5

    6

    ---------------------------

    March 13, 2006 at 6:53 am

    #626197

  • RE: How to PASTE a (value) to dts mail

    i am new in dts

    how i can add the option  to send the email

    profile name :

    To:

    CC:

    Message

    ----

    and with the ATTACHMENTS  (new file)??

    thnks

    ilan

    November 29, 2005 at 9:48 am

    #606449

    • Viewing 15 posts - 76 through 90 (of 202 total)