Forum Replies Created

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

  • RE: coverting lower to upper case program in sql server 2000

    oracle plsql using on ms sql

  • RE: find max

    friends ,

    select top 2*

    from empy order by cast(sal as int)desc

    in these query has given first two max values, now i need the ouput while i am giving the position...

  • RE: find max

    ya its workin..... suppose i need the particular top 3rd postion of max salary means how to modify

  • RE: find max

    need the output in sql server 2000 friends

  • RE: find max

    not working the ROW_NUMBER(), and DENSE_RANK() function in server 2000

  • RE: convert row to column in plsql

    its k tell in server 2000 style

  • RE: repeatin value in my procedure

    for above that for E2674 account total value of credit, total value of debit for each month

  • RE: repeatin value in my procedure

    Hi,

    Above the my procedure query giving output,i m splitting the amount column has credit and debit,closing_bal column is sum of account is E=>debit-credit,

    ...

  • RE: repeatin value in my procedure

    hey friend my actual table ve lakhs of data per month,after making the query,I m expexting ve to display account only one time per month and its has been summarize...

  • RE: repeatin value in my procedure

    account PR_Mons credit debit closinbal

    =======================================

    E2674 apr 3000 00000 -3000

    R7890 jun ...

  • RE: repeatin value in my procedure

    create table report

    (

    account varchar(30),

    trans char(30),

    trans_date date,

    amount number(50)

    )

    insert into report(account,trans,trans_date,amount) values('E2674','Cr','02apr02',300)

    insert into report(account,trans,trans_date,amount) values('R7890','Dr','06jun11',5000)

    insert into report(account,trans,trans_date,amount) values('E9700','Cr','7feb09',5000).......

    insert into report(account,trans,trans_date,amount) values('R7890','Cr','06jun11',5900)

    insert into report(account,trans,trans_date,amount) values('E9700','Dr','7feb09',8000)

    now i need the output of display for...

  • RE: Date function

    hi friend.

    when i am using DATEPART() its shows the month number(april,4),But i need the month name..... while i m using DATENAME() function giving the same month number only in...

  • RE: Date function

    ya google it, was my query is correct or not???

  • RE: Date function

    hi ,

    I'm created procedure but doesnt given the expecting ouput,show sum errors

    MYQUERY:

    =========

    CREATEprocedure PP__POSTINGS

    (

    @x datetime,

    @y datetime

    )

    as

    begin

    select

    account

    ...

  • RE: Date function

    how can split month coumn from date...would please give me brief

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