Professional Web Applications Themes

parsing data - Microsoft SQL / MS SQL Server

Hi, can somone please help me with this problem. I'm parsing a text file that holds call information. I've dumped the text file into a table and pd it the best that I know how. However, I'm having a problem getting the date on every call record because the date will only appear once and then you have all of the calls for that day. When the next day comes, you have the date stamped record and then call records. Here is an expample... CALL_DATE PHONE_NUMBER 8/15/2003 NULL NULL 555-555-5555 NULL 555-123-4568 8/16/2003 NULL NULL 123-678-9589 NULL 987-456-1234 NULL 567-897-1532 ...

  1. #1

    Default parsing data

    Hi, can somone please help me with this problem.

    I'm parsing a text file that holds call information. I've
    dumped the text file into a table and pd it the best
    that I know how. However, I'm having a problem getting
    the date on every call record because the date will only
    appear once and then you have all of the calls for that
    day. When the next day comes, you have the date stamped
    record and then call records.
    Here is an expample...

    CALL_DATE PHONE_NUMBER

    8/15/2003 NULL
    NULL 555-555-5555
    NULL 555-123-4568
    8/16/2003 NULL
    NULL 123-678-9589
    NULL 987-456-1234
    NULL 567-897-1532
    8/17/2003 NULL
    NULL 987-897-8888

    What I would like to do is have the date show up in the
    CALL_DATE field for every call. Any thoughts?

    Thanks in advance.

    Bruce
    borr Guest

  2. #2

    Default Re: parsing data

    OR something like this:

    select case dumy when 1 then orderdate else null end 'orderdate',
    OrderID,CustomerID, EmployeeID, RequiredDate
    from
    (select top 100 percent * from
    (select distinct 1 'dumy',orderdate,null orderid,null customerid,null
    employeeid,null requireddate from orders
    union all
    select 2,orderdate,OrderID,CustomerID, EmployeeID, RequiredDate
    from orders ) a
    order by orderdate,dumy)B

    --
    -Vishal
    "Vishal Parkar" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Vishal Guest

  3. #3

    Default Re: parsing data

     
    end 'orderdate', 
    customerid,null 
    RequiredDate [/ref]
    something similar with the [/ref]
    RequiredDate [/ref][/ref]
    I've [/ref][/ref]
    best [/ref][/ref]
    only [/ref][/ref]
    that [/ref][/ref]
    stamped [/ref][/ref]
    the 
    >>
    >>[/ref]
    >
    >
    >.
    >Hi, I've tried both of these and it still does not give[/ref]
    me the expected results. Any other ideas?
    borr Guest

Similar Threads

  1. Parsing data in XML doent
    By Rick in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: October 10th, 03:52 PM
  2. Parsing Data from a textarea
    By Paulie579 in forum Dreamweaver AppDev
    Replies: 11
    Last Post: June 15th, 04:30 PM
  3. Image data parsing
    By anatolym in forum PERL Modules
    Replies: 1
    Last Post: October 30th, 10:39 AM
  4. Parsing data
    By Luigi Rambaldi in forum PHP Development
    Replies: 3
    Last Post: February 14th, 08:43 AM
  5. Parsing XML Data to variable
    By Andrew Banks in forum PHP Development
    Replies: 9
    Last Post: August 19th, 09:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139