Forum Replies Created

Viewing 15 posts - 226 through 240 (of 389 total)

  • RE: subquery

    harri.reddy (8/22/2012)


    hi

    can we user order by inside subquery?

    Hi Harri,

    As suggested by drew give it a try and you will come to know your own the result and the solution for...

  • RE: Extract string between delimiters

    sanjay831 (8/21/2012)


    HI

    I want to extract string between the delimters where data is as follows:

    abc_def_cet_qwe output required in only def , how to extract...

  • RE: Today's Random Word!

    bcsims 90437 (8/21/2012)


    crookj (8/21/2012)


    SQLRNNR (8/21/2012)


    Warble

    weeble

    Weevil

    WOTD: YUCK

    Reveal

  • RE: Cannot get Left JOIN to work correctly

    Ok..so if am not wrong then dealer code is in the first table and you are looking for all the records in second table.

    If this is the case then I...

  • RE: Cannot get Left JOIN to work correctly

    tshad (8/20/2012)


    I have 2 tables in my database and am RIGHT JOINING the tables and it is acting like an inner join

    SELECT [DealerCode]

    ,iis.[ForecastSegmentId]

    ...

  • RE: Today's Random Word!

    Cliff Jones (8/20/2012)


    Scott D. Jacobson (8/20/2012)


    SQLRNNR (8/20/2012)


    Ray K (8/20/2012)


    Manic Monday

    The Bangles

    Susanna Hoffs and Matthew Sweet.

    Ming Tea

    Green Tea

  • RE: Insert into one table from multiple tables

    daftmoo (8/18/2012)


    Hi All,

    Just needed a bit of help with an insert query.

    I have 3 tables that I need data from each to populate a 4th master.

    Table1 = Risk Data, this...

  • RE: New to SQL Server 2008

    Thanks to all for your valuable input 🙂

  • RE: find max

    raghuldrag (8/17/2012)


    hi friends,

    create table emp(ename varchar(34),job char(33),sal varchar(22))

    insert into emp values('sa','sales','400')

    insert into emp values('ka','manager','4000')

    insert into emp values('sam','Markting','2500')

    insert into emp values('sabu','system','3900')

    in these table model i ve a report now i...

  • RE: Today's Random Word!

    JAZZ Master (8/16/2012)


    Cliff Jones (8/16/2012)


    Daniel Bowlin (8/16/2012)


    Cliff Jones (8/16/2012)


    Ray K (8/16/2012)


    rhythmk (8/15/2012)


    Daniel Bowlin (8/15/2012)


    content

    Satisfied

    Satiated

    Saturated

    Color

    Scheme

    Plot

    Story

  • RE: While Loop into a Set Based Insert

    Richie T (8/15/2012)


    Thanks for that guys much appreciated.

    That link you provided is very useful and exactly what I was looking for, should be able to rewrite the proc using this...

  • RE: Today's Random Word!

    Daniel Bowlin (8/15/2012)


    content

    Satisfied

  • RE: Today's Random Word!

    crookj (8/10/2012)


    Revenant (8/10/2012)


    Cliff Jones (8/10/2012)


    crookj (8/10/2012)


    Scott D. Jacobson (8/10/2012)


    SQLRNNR (8/10/2012)


    Brandie Tarvin (8/10/2012)


    Drama

    QUEEN

    Freddie Mercury

    Another One Bites the Dust

    Kessy and Ross

    Silver

    The Lone Ranger

    Avenger

  • RE: Today's Random Word!

    SQLRNNR (8/7/2012)


    Lynn Pettis (8/7/2012)


    Lynn Pettis (8/7/2012)


    Monty

    Python

    Flying

    Aeroplane

  • RE: Today's Random Word!

    Cliff Jones (7/26/2012)


    jasona.work (7/26/2012)


    Ray K (7/26/2012)


    crookj (7/26/2012)


    Revenant (7/26/2012)


    SQLRNNR (7/26/2012)


    opc.three (7/26/2012)


    Daniel Bowlin (7/26/2012)


    Begin

    TRY

    catch

    END CATCH

    Catch-All

    Catch 22

    Ketchikan

    Alaska

    Himalaya

Viewing 15 posts - 226 through 240 (of 389 total)