Forum Replies Created

Viewing 15 posts - 1,021 through 1,035 (of 3,543 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/23/2011)


    And now for the public flogging moment of The Thread as I post a semi-technical question that is sure to get me lynched.

    We have a Word 2003 document...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/22/2011)


    W00t! This is my 3000th forum post!

    Nice and well done 😀

    And to make it count:

    Wibble.

    Thats OK then, it makes all 3000 posts valuable and worthwhile 😛

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/21/2011)


    Ah, well. I'm sure I screwed the pooch on some of those questions, but here's my launch buddy link. Anyone care to click for me?

    http://www.launchbuddi.es/5OHbk

    +1

    p.s. my buddies link...

  • RE: Are the posted questions getting worse?

    Lynn Pettis (11/11/2011)


    SQLRNNR (11/11/2011)


    Lynn Pettis (11/11/2011)


    What other Threadizins are participating in the DBA in Space contest? Looking for launch buddies!

    So does that mean you are in the front running?

    I...

  • RE: Format date time

    CONVERT(char(10),GETDATE(),101)+' '+STUFF(REPLACE(STUFF(CONVERT(char(26),GETDATE(),109),1,12,''),' ','0'),9,4,' ')

  • RE: Are the posted questions getting worse?

    Jeff Moden (11/4/2011)


    Brandie Tarvin (11/4/2011)


    SQL Kiwi (11/4/2011)


    So, it depends

    Someone so needs to come up with an interview question where this is the exact answer that's needed.

    @=)

    No problem... "I'm old... what...

  • RE: Are the posted questions getting worse?

    Jim Murphy (9/12/2011)


    In fact, I define "hardware" as the part of the computer that you can kick.

    Be careful, some people may consider your a$$ as your "hardware" and treat it...

  • RE: union all and ordering the data

    piet.kouwer (9/6/2011)How can I solve this problem ?

    There are several ways of achieving this but we need more information

    DDL to create tables

    Sample data (INSERT statements)

    Expected results

  • RE: system stored procecures

    I found this interesting

    use master

    go

    create procedure sp_one

    as

    select 'this'

    go

    use test2

    go

    create procedure sp_one

    as

    select 'that'

    go

    drop procedure sp_one

    go

    drop procedure sp_one

    go

    will drop the procedure in test2 and master :Wow:

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/22/2011)


    Really? I can hear a beer coming on!

    Sounds good :smooooth:

  • RE: Are the posted questions getting worse?

    ChrisM@Work (8/22/2011)


    ... Swindon ...

    Really :Wow:

    My neck of the woods 😀

  • RE: Hidden RBAR: Counting with Recursive CTE's

    Another great article Jeff 🙂

    Jeff Moden (8/8/2011)


    ... some would say that I, indeed, have no taste buds

    Surely you meant 'no taste' 😛

  • RE: Getting data within a time period

    pwalter83 (8/5/2011)


    I tried your query but its displaying data for ARRIVAL_SCHEDULE_DT 3 months prior to todays date now.

    My mistake I thought the date test was for BEZEE only

    WHERE MG_VESSEL_PARTICULAR.VESSEL_TYPE_CD =...

  • RE: Getting data within a time period

    OK understand the status for arrived but still not sure about the 'arrived first' bit.

    This will select all ports except 'BEZEE' which will only be selected if the ship has...

  • RE: Getting data within a time period

    Now all that needs to be done is just include the condition that the above scenario will apply only if the ship reaches the port(PORT_CD) 'BEZEE' first.

    How do you determine...

Viewing 15 posts - 1,021 through 1,035 (of 3,543 total)