Forum Replies Created

Viewing 15 posts - 4,756 through 4,770 (of 8,753 total)

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (8/11/2015)

    Ahh, 50,000 posts. Off doing real work and missed it. Amazing. Lots of forums don't have 50,000 posts in total.

    Would have been more if "someone"...

    August 11, 2015 at 12:52 pm

    #1819094

  • RE: Pull top 3 max values for each account

    Quick alternative to Luis's fine solution

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @SAMPLE_DATE TABLE (account INT ,dates DATE);

    INSERT INTO @SAMPLE_DATE(account,dates)

    VALUES

    (1234565, '2015/01/01')

    ,(1234565, '2015/02/15')

    ,(1234565, '2015/02/16')

    ,(1234565, '2015/08/01');

    SELECT TOP (3)

    SD.account

    ...

    August 11, 2015 at 12:47 pm

    #1819091

  • RE: Are the posted questions getting worse?

    SQLRNNR (8/11/2015)

    Grant Fritchey (8/11/2015)

    Lynn Pettis (8/11/2015)

    Can't place the movie or show that came from, but love the editing!

    Big Trouble in Little China.

    That was quick.

    Nothing better than a whole hog chop...

    August 11, 2015 at 12:31 pm

    #1819088

  • RE: Today's Random Word!

    eccentricDBA (8/11/2015)

    whereisSQL? (8/11/2015)

    Revenant (8/11/2015)

    Ed Wagner (8/11/2015)

    Luis Cazares (8/11/2015)

    Ed Wagner (8/11/2015)

    djj (8/11/2015)

    Eirikur Eiriksson (8/11/2015)

    Ed Wagner (8/11/2015)

    TomThomson (8/10/2015)

    SQLRNNR (8/10/2015)

    centrifuge

    acceleration

    Velocity

    Inertia

    Energy

    Force

    Dark Side

    Sith

    Emperor

    Darth Sidious

    Dark Helmet

    Asthma

    August 11, 2015 at 12:02 pm

    #1819077

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/11/2015)

    Ed Wagner (8/11/2015)

    Sean Lange (8/11/2015)

    Grant Fritchey (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with...

    August 11, 2015 at 11:35 am

    #1819070

  • RE: charindex/substring to replace varying amounts of '/'

    Quick suggestion

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    DECLARE @sourcedata TABLE(STR_DATA VARCHAR(100) NOT NULL);

    INSERT INTO @sourcedata(STR_DATA)

    VALUES

    ('/@836d254c/v1/HOME/INDEX' )

    ,('/@836d254c/v1/ASSIST/SPECIAL' ...

    August 11, 2015 at 11:25 am

    #1819067

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    Sean Lange (8/11/2015)

    OMG. I just ran across this in a database from a 3rd party. There are actually 50 nvarchar(1) columns with names 1 - 50. :w00t:

    ATTRIBUTE1 nvarchar(1)

    ATTRIBUTE2...

    August 11, 2015 at 10:18 am

    #1819051

  • RE: Are the posted questions getting worse?

    Grant Fritchey (8/11/2015)

    Eirikur Eiriksson (8/11/2015)

    0xC34F0xC350 Missed it:pinch::-D

    😎

    ... by that much.

    It was truly a "near miss":-D

    😎

    August 11, 2015 at 6:51 am

    #1818912

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/11/2015)

    Koen Verbeeck (8/11/2015)

    jasona.work (8/11/2015)

    Where are the balloons from the ceiling? Confetti?

    Cake?

    This has been quite the disappointment.

    I thought we all would get 50,000 extra points.

    Ah well, up to...

    August 11, 2015 at 6:44 am

    #1818902

  • RE: Are the posted questions getting worse?

    0xC34F0xC350 Missed it:pinch::-D

    😎

    August 11, 2015 at 6:38 am

    #1818894

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/11/2015)

    Only 10 posts to go...

    Correction, only 7 posts to go...:-D

    😎

    August 11, 2015 at 6:23 am

    #1818881

  • RE: Today's Random Word!

    Ed Wagner (8/11/2015)

    TomThomson (8/10/2015)

    SQLRNNR (8/10/2015)

    centrifuge

    acceleration

    Velocity

    Inertia

    August 11, 2015 at 5:41 am

    #1818865

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (8/11/2015)

    ChrisM@Work (8/11/2015)

    Koen Verbeeck (8/11/2015)

    You mean something like this?

    Seems like a very serious injury...

    That's him! Very talented actor, not afraid to get down and dirty.

    And despite his successes, he...

    August 11, 2015 at 4:09 am

    #1818849

  • RE: How to set BOL to local once set to online?

    peter 82125 (8/10/2015)

    Thanks! Where is that Help option located, please?

    Few options in SSMS:

    1) press ALT + H, Down arrow, Enter

    2) Left click on the [HELP] menu and...

    August 11, 2015 at 1:47 am

    #1818811

  • RE: Are the posted questions getting worse?

    I lose!:pinch:

    😎

    August 10, 2015 at 11:06 pm

    #1818796

Viewing 15 posts - 4,756 through 4,770 (of 8,753 total)