Forum Replies Created

Viewing 15 posts - 3,541 through 3,555 (of 8,731 total)

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/14/2016)

    Anybody coming to Nashville's SQL Saturday this weekend?

    Sounds tempting, but I'd have to miss the first 2 sessions and spend 10 hours on a bus for the round...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 1:48 pm

    #1852069

  • RE: LEFT JOIN

    Welsh Corgi (1/14/2016)

    Phil Parkin (1/14/2016)

    The WHERE NOT EXISTS () construction often performs better than using a LEFT JOIN – I would recommend a test.

    You should include table schemas in your...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 12:29 pm

    #1852039

  • RE: LEFT JOIN

    What's the problem?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 12:04 pm

    #1852026

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/14/2016)

    Luis Cazares (1/14/2016)

    Ed Wagner (1/14/2016)

    BL0B_EATER (1/14/2016)

    Grant Fritchey (1/14/2016)

    Ed Wagner (1/14/2016)

    Phil Parkin (1/14/2016)

    Grumpy DBA (1/14/2016)

    Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 10:14 am

    #1851998

  • RE: Access SQL to SQL

    wrightyrx7 (1/14/2016)

    Luis Cazares (1/14/2016)

    I'm not sure what's the problem. The code should be working and there's no missing parenthesis. That's just another reason why I hate Oracle.

    Maybe someone else can...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 9:07 am

    #1851970

  • RE: Access SQL to SQL

    I'm not sure what's the problem. The code should be working and there's no missing parenthesis. That's just another reason why I hate Oracle.

    Maybe someone else can help.

    By the way,...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 8:52 am

    #1851959

  • RE: Today's Random Word!

    crookj (1/14/2016)

    Ed Wagner (1/14/2016)

    SQLRNNR (1/13/2016)

    Ed Wagner (1/13/2016)

    SQLRNNR (1/13/2016)

    whereisSQL? (1/13/2016)

    jasona.work (1/13/2016)

    SQLRNNR (1/13/2016)

    Ed Wagner (1/13/2016)

    crookj (1/13/2016)

    Grumpy DBA (1/13/2016)

    djj (1/13/2016)

    DonlSimpson (1/13/2016)

    Girl

    Tatoo

    Dragon

    Tiamat

    Smaug

    Smog

    Los Angeles

    Rams

    RaidersShafted

    Referees (the always win)

    Cheats

    Dishonest

    Patriots (New England)

    Disgusting

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 8:42 am

    #1851954

  • RE: Are the posted questions getting worse?

    Phil Parkin (1/14/2016)

    Grumpy DBA (1/14/2016)

    Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 - oddly the same age as David Bowie....

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 8:38 am

    #1851950

  • RE: Are the posted questions getting worse?

    Ed Wagner (1/14/2016)

    BL0B_EATER (1/14/2016)

    Grant Fritchey (1/14/2016)

    Ed Wagner (1/14/2016)

    Phil Parkin (1/14/2016)

    Grumpy DBA (1/14/2016)

    Another death, actor Alan Rickman (of Professor Snape and Die Hard fame) died at the age of 69 -...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 8:29 am

    #1851944

  • RE: Access SQL to SQL

    wrightyrx7 (1/14/2016)

    Luis Cazares (1/14/2016)

    Oracle does not use TOP(n). One alternative is to filter by ROW_NUMBER().

    SELECT T1.*,

    (SELECT END_DATE

    FROM (SELECT T3.SMN_DATEC-1...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 8:04 am

    #1851935

  • RE: Result set should return all values inspite of a "Where clause"

    sqlnewbie17 (1/14/2016)

    If my result set has a million rows wouldn't a case statement be very slow than a where clause.

    Is there a better way of doing this.My environment is sqlserver...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 7:55 am

    #1851926

  • RE: Alternative to splitting text

    Once you get the splitter, you just need to pivot the data.

    CREATE TABLE #SplitTest( String varchar( 8000));

    INSERT INTO #SplitTest VALUES( '111#222#33333#44#555#66');

    SELECT MAX( CASE WHEN ItemNumber = 1 THEN Item END)...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 7:47 am

    #1851914

  • RE: Access SQL to SQL

    Oracle does not use TOP(n). One alternative is to filter by ROW_NUMBER().

    SELECT T1.*,

    (SELECT END_DATE

    FROM (SELECT T3.SMN_DATEC-1 AS END_DATE,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 7:38 am

    #1851910

  • RE: Result set should return all values inspite of a "Where clause"

    You just need to change the condition from the WHERE into a CASE statement in the column list.

    --From this

    SELECT ColA,

    ColB,

    ColC,

    ...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 14, 2016 at 7:19 am

    #1851898

  • RE: What is recursion?

    Orlando Colamatteo (1/13/2016)

    NineIron (1/13/2016)

    I'm running a procedure that I received from a vendor and I got a maximum recursion 100 error or something like that. So, this means that it...

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

    January 13, 2016 at 11:42 am

    #1851687

Viewing 15 posts - 3,541 through 3,555 (of 8,731 total)