Forum Replies Created

Viewing 15 posts - 1 through 15 (of 27 total)

  • RE: query - sum of column

    Ok, end up with peoples advice,

    I will try to do it at front end.

    before I thought that abit easy to get the result with query 😀

    Thanks for the advice 😉

  • RE: problem with white space at the end of char column

    thank you, it works. 🙂

  • RE: how to join two store procedure together

    Iam using datatable from .net app connect to database,

    once click [ok] the app calls a store procedure(the 1st step),

    to insert all the rows to a table in the database

    (one...

  • RE: how to join two store procedure together

    my 1st procedure will repeat many time, until all rows been insert to a table.

    if I put the 2nd procedure into 1st, how to know when the last row is,...

  • RE: question with output the number of rows insert

    the point is the output variable return the number of row been insert is 500.

    my .net app only return the @insertRowCount one time, that is how many rows been added

    there...

  • RE: the auto increament ID not in order

    Thank you for the answer. I get it.

  • RE: the auto increament ID not in order

    Thank you all answerd the question.

    ok, what I understand from the posts, if I want to display the order of the rows as what I enterd, I have to use...

  • RE: improve the query performance

    The thing I didnt do at the beginning, was test the query in a very large database, was large enough I thought, then the process timeout in the application. This...

  • RE: improve the query performance

    I understand your query now, I know its abit late to say that.

    Related question about the code below

    select *

    from tblCallLog r

    Where DateCall =

    (

    ...

  • RE: improve the query performance

    DateCall >=@callFrom and DateCall < @callTo <<< does this part of code already set the range of dateCall

    without

    not exists

    (

    select 1

    FROM tblCallLog

    WHERE phNu=r1.phNu

    AND DateCall > @callTo

    )

    also it select all of the...

  • RE: improve the query performance

    yes, ur right i only want the phone number within the rang,

    so DateCall >=@callFrom and DateCall < @callTo

    is alreadly set the rang,

    one thing here iam not understand, do we need...

  • RE: improve the query performance

    mister.magoo (1/19/2011)


    Is it safe to say that the latest call for any phone number will also correspond to the highest "id" for that phone number?

    quote]

    No, the high 'id' doesn't mean...

  • RE: improve the query performance

    below is the table and some data

    tblCallLog

    id (int, not null)PK

    DateCall(datetime, null)

    logStatus(nchar(10), null)

    phNu(int, not null)

    pplName(nchar(100), null)

    id, DataCall, logStatus, phNu, pplName

    400123, 2011-01-10 15:15:00.000, n, 31695555, b johnson

    400124, 2011-01-10 15:16:00.000, b, 46555501, c...

  • RE: improve the query performance

    thank you for the reply

    but something are not understand

    like the union part, and why inner join with the logStatus.

    WITH S As (select max(DateCall) MaxDateCall from tblCallLog where phNu=r.phNu group by...

  • RE: what size should i set on the comment column

    yes, you answered the question completely. thank you.

    the reason i asked this, buz the table will go large, "IF" i set the size large, and waste it, then slow down...

Viewing 15 posts - 1 through 15 (of 27 total)