Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 15,381 total)

  • RE: Are the posted questions getting worse?

    Chris Harshman (11/23/2016)

    robert.sterbal 56890 (11/23/2016)

    What is on your menu for Thanksgiving?

    looks like SQL Server Central is having spam for thanksgiving :crazy:

    That is on the menu every day. We don't need...

    November 23, 2016 at 8:30 am

    #1914244

  • RE: app development - sql backend.

    snomadj (11/23/2016)

    I need to give a client some options for creating a front end interface for a sql backend. What they currently have is a series of lame old access...

    November 23, 2016 at 6:58 am

    #1914219

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (11/22/2016)

    Have to drop this here, since I'm proud.

    My son completed his Board of Review last night to earn his Eagle Scout rank. It's been a...

    November 22, 2016 at 12:10 pm

    #1914098

  • RE: running SP from dotnet code takes much longer than running it in SSMS

    I doubt this is "solved", it has only gone away for the moment. It will come back again. This has the classic signs of parameter sniffing gone bad.

    Check out Gail's...

    November 21, 2016 at 8:50 am

    #1913762

  • RE: how to retrieve numbers from a string

    If your string pattern is consistent and you are 100% certain you will never have any decimal points you can do something like this.

    Thanks to Lowell for turning this into...

    November 21, 2016 at 8:47 am

    #1913761

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (11/16/2016)

    So I did a quick google on polenta and found this interesting article.

    That's interesting. I have never heard most of those "rules" about polenta.

    November 16, 2016 at 10:12 am

    #1912863

  • RE: Temp tables in transaction

    Nice straight forward question Sergiy. And something that many people don't know.

    November 16, 2016 at 8:39 am

    #1912821

  • RE: Are the posted questions getting worse?

    Ed Wagner (11/15/2016)

    Y.B. (11/15/2016)

    Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

    That being said I did recently try an Irish Cheddar which was excellent. ...

    November 15, 2016 at 12:29 pm

    #1912642

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/15/2016)

    VARCHAR(1) is my favorite data type of all time... Well, behind VARIANT, but hopefully that's going to be on the ash heap soon.

    Even better when it is defined...

    November 15, 2016 at 8:00 am

    #1912522

  • RE: Performing union data with null values

    Budd (11/15/2016)

    While an ORDER BY clause will guarantee an order of results, I thought I read somewhere (long ago) that with out ORDER BY, the order or results can be...

    November 15, 2016 at 7:45 am

    #1912513

  • RE: Are the posted questions getting worse?

    WayneS (11/11/2016)

    "safe" keeping? More like ransom.:w00t:

    Nah a ransom would indicate a possibility of parole. :hehe:

    November 11, 2016 at 1:50 pm

    #1912002

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/11/2016)

    Marbles?

    Pretty sure I lost them years ago.

    Yeap...it was right around the time I said "I do". 😀 Last I knew she still kept my marbles locked away for...

    November 11, 2016 at 1:02 pm

    #1911999

  • RE: Dropping a view

    Ed Wagner (11/11/2016)

    A good, straightforward question is a nice way to end the week. Thanks, Steve.

    Agreed!!! Good question Steve!!

    November 11, 2016 at 10:43 am

    #1911958

  • RE: Update duplicate keys

    Matt.Altman (11/11/2016)

    Sorry, I didnt realize the ON DUPLICATE was mysql. Should have seen that. I am using T-SQL. And I will look at changing the name of...

    November 11, 2016 at 10:23 am

    #1911951

  • RE: Update duplicate keys

    Matt.Altman (11/11/2016)

    So I have a stored proc

    INSERT INTO dbo.Table2 (Application, Timestamp, Performance, Availability)

    SELECT

    Application,

    CAST(Timestamp AS DATE) as Date,

    AVG(CAST(Performance AS decimal(6,2))) as Average_Performance,

    AVG(Availability) as Average_Availability

    FROM dbo.Table1

    GROUP BY CAST(Timestamp AS DATE), Application

    END

    It...

    November 11, 2016 at 10:03 am

    #1911946

Viewing 15 posts - 1,126 through 1,140 (of 15,381 total)