Forum Replies Created

Viewing 15 posts - 946 through 960 (of 1,248 total)

  • RE: Today's Random Word!

    Punched tape

  • RE: PIVOT

    sestell1 (8/25/2014)


    Does anyone actually use the PIVOT operator?

    I find it so limited that I almost always roll my own using GROUP BY and CASE.

    I used it for the first time...

  • RE: Some time Stored Procedure suddenly taking 10 seconds when we called through application.

    I also noticed that the OP doesn't mention the normal time it takes to run. It's possible that 10 seconds could actually be an improvement. Things inexplicably running...

  • RE: Are the posted questions getting worse?

    I feel that I should make some mention of this man's birthday today. I think without his work our lives may be very different\easier\harder, delete as appropriate.

  • RE: Is a foreign key constraint an index? If not, is an index automatically created in order to enforce it?

    Carlo Romagnano (8/4/2014)


    I read question and answers many times because of high score.

    I was searching for the swindle!

    But it's only a straightforward basic question.

    😀

    +1

    I thought I knew what the...

  • RE: Today's Random Word!

    Revenant (7/30/2014)


    SQLRNNR (7/30/2014)


    Sean Lange (7/30/2014)


    Ed Wagner (7/30/2014)


    SQLRNNR (7/30/2014)


    djj (7/30/2014)


    whereisSQL? (7/30/2014)


    Ed Wagner (7/30/2014)


    TomThomson (7/30/2014)


    SQLRNNR (7/30/2014)


    Ed Wagner (7/30/2014)


    Stuart Davies (7/30/2014)


    SQLRNNR (7/29/2014)


    aardvark

    Digger

    Hunting (for antiques)

    Pecheur

    é or ê?

    Tomato

    ketchup

    hot dog

    breakfast

    Dinner

    Bacon

    Pork Belly

    futures

    Markets

  • RE: One a Week

    Gary Varga (7/30/2014)


    BWFC (7/30/2014)


    I've even heard that some pubs allow self catering option.

    My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub...

  • RE: One a Week

    I've even heard that some pubs allow self catering option.

    My sister (actually my mum) did the catering for my nephew's Christening do herself. The pub made a nominal...

  • RE: Today's Random Word!

    Legs

  • RE: When Does Minimum not Mean Minimum?

    Grant Fritchey (7/23/2014)


    Thanks for posting your solution. Now when anyone searches for this same problem and finds it, they'll know what you did to solve it. That really helps.

    If it...

  • RE: When Does Minimum not Mean Minimum?

    I've solved it and it was pretty obvious in the end. My where predicate was excluding the rows with the earlier times from the query because I was only...

  • RE: Taking long time for a single table execution

    Do you know anything about your hardware set up? With the best will in the world, it's going to take a lot longer to run on a 386 than...

  • RE: Taking long time for a single table execution

    Hi Naveen, welcome to the forum.

    To help we're going to need a little bit more detail. When you say you're trying to retrieve them, what do you mean? ...

  • RE: Today's Random Word!

    SQLRNNR (7/21/2014)


    Revenant (7/21/2014)


    SQLRNNR (7/21/2014)


    EL Jerry (7/21/2014)


    Stuart Davies (7/21/2014)

    WOTD wood

    Hard (floor)

    impenetrable

    Adamantium

    fusion

    Cold

  • RE: Set datime and convert it

    hoseam (7/21/2014)


    @BWFC

    The code is this:

    declare @ToDate datetime

    declare @FromDate datetime

    set @FromDate = '01/02/20014'

    set @ToDate = '28/02/20014'

    SELECT EVENTDATE,'' AS BRANCHCD, BUSINESS_AREA, CREATE_DATE, WORK_TYPE, QUEUE, STATUS, CREATE_AGE, CATEGORYCD, DELAYREASON1,...

Viewing 15 posts - 946 through 960 (of 1,248 total)