Forum Replies Created

Viewing 15 posts - 31 through 45 (of 45 total)

  • RE: Back Up restore

    John Mitchell-245523 (5/16/2012)


    There must be another database that's using the same physical file names. Use the WITH MOVE clause as the error message suggests, and it should work.

    John

    John the...

  • RE: How to Merge two rows into one?

    Wow, you taught me something new, though its been there and never used it before.

    But your query does not return all data, as my query returns a few records with...

  • RE: Result to display in Tex Mode.

    If by SSMS you referring to Sql Server Management Studio than follow this.

    On the tool bar point to Query --> Results To --> Result to Text

    Than your result will be...

  • RE: How to Merge two rows into one?

    Eugene Elutin,

    Just out Curiosity, what’s the difference between the two queries as they return the exact same set of results?

    selectt1.orig_branch_no,

    t1.acct_no,

    t1.amt as 'Transaction Amount',

    RoutingNo = NULL,

    t1.description,

    t1.tran_code, (select t2.tran_code from history as...

  • RE: How to Merge two rows into one?

    CREATE TABLE History

    (

    branch int,

    acct_no int,

    amt double,

    description varchar(255),

    Create_dt date,

    charge_code int,

    tran_code int

    )

    INSERT INTO History

    VALUES (410,1234567890,6000000.00,'DDACC IFO KAWASAKI','2011-08-02 00:00:00',756,262)

    INSERT...

  • RE: How to Merge two rows into one?

    Please post your results once more. I don't think what you posted was the right result.

    Ya its giving me weird results but I'm working around it, i will also appreciate...

  • RE: How to Merge two rows into one?

    Sorry Guys i got it right

    Here is the query

    selectorig_branch_no,

    acct_no,

    amt,

    description,

    create_dt,

    charge_code,

    tran_code, (select t2.tran_code from history as t2

    where t2.tran_code in (157)

    and t2.description like '%DDAC%'

    and t2.create_dt = '20110802'

    and t2.acct_no = t1.acct_no) as 'Charge Code',

    (select...

  • RE: HOT -- Multiple SUM, AVG on Multiple rows in an aggregated query

    Stewart "Arturius" Campbell (4/20/2012)


    shani19831 (4/20/2012)


    if you look closely you can see that some sums are computed for avg,...

    Yes, this would be a case of a single transaction meeting the...

  • RE: HOT -- Multiple SUM, AVG on Multiple rows in an aggregated query

    Wow Wow,

    I have made a few changes and added few things to your code and the results are amazing, cant ask for better than this.

    Thank you so much and wish...

  • RE: HOT -- Multiple SUM, AVG on Multiple rows in an aggregated query

    Ok im busy modifying it to accomandate the actual tables, i see you have missed the filter in terms of tran codes but i will add it and get back...

  • RE: HOT -- Multiple SUM, AVG on Multiple rows in an aggregated query

    Thanks Stewart "Arturius" Campbell

    My brain is frozen at the moment and cant think any further but will have a look at the code and see if does guide, nevertheless thanks...

  • RE: Selecting data from multiple tables

    Hi guruprasad1987

    Thank you, your help is very appriciated and thats really what i wanted.. i will just have to do the same the EFT and I will the other...

  • RE: Selecting data from multiple tables

    Hi Ramkumar.K

    Your query works fine and did 60% of what i want or needed.

    There are transactions missing or not retrieved by the query.

    I noted Rim_no 30734 which has only...

  • RE: Selecting data from multiple tables

    Hi Ramkumar.K,

    Yes im trying to write a query than save it a stored proc, than i will use management to create a DRL report wich calls the store proc.

    This is...

  • RE: Mulitple Saarch Criteria using ONE Column

    Dude your table is missing a unique column, but you could try a distinct fucntion. that should help you

    select distinct(*)

    from employees

    or you can use

    the 'IN' function

Viewing 15 posts - 31 through 45 (of 45 total)