Forum Replies Created

Viewing 15 posts - 5,146 through 5,160 (of 8,753 total)

  • RE: REPLACE & PATINDEX issue

    Another attempt using Lynn's fine code

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    IF OBJECT_ID(N'dbo.SystemsRE') IS NOT NULL DROP TABLE dbo.SystemsRE;

    CREATE TABLE dbo.SystemsRE (SystemID INT NOT NULL, IpAddress VARCHAR(200) NOT NULL);

    INSERT INTO dbo.SystemsRE(SystemID,IpAddress)

    VALUES

    (10001,'132.135.3.100,...

    May 29, 2015 at 1:27 pm

    #1801718

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/29/2015)

    We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

    < rant >

    I am still amazed at how many people have to...

    May 29, 2015 at 1:16 pm

    #1801711

  • RE: Ye Old Shrinkfile

    Steven W (5/29/2015)

    152 tables....

    But with only 20g free... I don't think I would have room to move the other tables over... The next smallest table is 40g....

    Then the approach has...

    May 29, 2015 at 1:06 pm

    #1801709

  • RE: Ye Old Shrinkfile

    Quick question, how many tables are in the database?

    My normal approach to this kind of problems is to add a filegroup / data file, move the data to the new...

    May 29, 2015 at 12:53 pm

    #1801704

  • RE: REPLACE & PATINDEX issue

    TJT (5/29/2015)

    I am trying to get this to work without sample data and I get IP_ADDR is not recognized. I really appreciated everyone's patience on this.

    SET NOCOUNT ON;

    WITH SAMPLE_DATA(IP_ADDR)...

    May 29, 2015 at 12:46 pm

    #1801702

  • RE: If Celko was a rock star, which one would he be?

    Luis Cazares (5/29/2015)

    thisisfutile (5/29/2015)

    jshahan (5/28/2015)

    Just picked up from The Thread that old Joe has been banned from SSC.

    You picked up from this thread that Joe is banned? Maybe I...

    May 29, 2015 at 12:45 pm

    #1801701

  • RE: Today's Random Word!

    eccentricDBA (5/29/2015)

    whereisSQL? (5/29/2015)

    hughmanning (5/29/2015)

    Artifical

    Intelligence

    research

    Topic

    May 29, 2015 at 12:40 pm

    #1801697

  • RE: REPLACE & PATINDEX issue

    Lynn Pettis (5/29/2015)

    < friendly rant >

    Eirikur, really, ;; and then the WITH for the CTE?? Semicolons are terminators not begininators. Microsoft documentation in BOL is WRONG to...

    May 29, 2015 at 12:39 pm

    #1801696

  • RE: REPLACE & PATINDEX issue

    TJT (5/29/2015)

    OK I tried the example below and I get 'Invalid object name 'dbo.DelimitedSplit8k''

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SAMPLE_DATA(IP_ADDR) AS

    ( SELECT * FROM (VALUES

    ('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

    ,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

    )...

    May 29, 2015 at 12:37 pm

    #1801694

  • RE: REPLACE & PATINDEX issue

    Quick suggestion, use dbo.DelimitedSplit8K on the comma

    😎

    USE tempdb;

    GO

    SET NOCOUNT ON;

    ;WITH SAMPLE_DATA(IP_ADDR) AS

    ( SELECT * FROM (VALUES

    ('132.135.3.100, fe90::bu54:e9z5:61a9:5003')

    ,('132.235.219.113, fe80::28d9:l69a:5bbd:gr2f')

    ) AS X(IP_ADDR)

    )

    SELECT

    SP.Item

    FROM ...

    May 29, 2015 at 12:17 pm

    #1801686

  • RE: Today's Random Word!

    DonlSimpson (5/29/2015)

    Ed Wagner (5/29/2015)

    TomThomson (5/29/2015)

    Revenant (5/29/2015)

    Ed Wagner (5/29/2015)

    cunningham (5/29/2015)

    Ed Wagner (5/29/2015)

    hughmanning (5/29/2015)

    Centipede

    Millipede

    arthropod

    Management (Couldn't resist :-D)

    disaster

    recovery

    Restore

    Habitat

    Boundries

    May 29, 2015 at 11:31 am

    #1801669

  • RE: Today's Random Word!

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    crookj (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    Races

    Horse

    Mouth

    Mister (Ed)

    Misses

    Hits

    Charts

    Course

    Lost

    May 28, 2015 at 2:08 pm

    #1801398

  • RE: Today's Random Word!

    Ed Wagner (5/28/2015)

    crookj (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Ed Wagner (5/28/2015)

    TomThomson (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    djj (5/28/2015)

    Revenant (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    crookj (5/28/2015)

    Ed Wagner (5/28/2015)

    djj (5/28/2015)

    Ed Wagner (5/28/2015)

    cunningham (5/28/2015)

    session

    Server

    SQL:-D

    Performance

    Recital

    Piano

    Guitar

    Tune

    Engine

    Running

    Races

    Horse

    Mouth

    Mister (Ed)

    Misses

    Hits

    May 28, 2015 at 12:44 pm

    #1801365

  • RE: The Scientific Method: a call to action

    Lynn Pettis (5/28/2015)

    meilenb (5/27/2015) ...

    Oh and we don't need to sit here and sling insults. You've got 2 under your belt.

    Only problem here, I haven't slung ANY insults. ...

    May 28, 2015 at 12:37 pm

    #1801361

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/28/2015)

    Eirikur Eiriksson (5/28/2015)

    Brandie Tarvin (5/28/2015)

    Well, unless someone used DBCC Timewarp() on it, the last I checked there was only one. But then again, someone did say DBCC Timewarp()...

    May 28, 2015 at 12:26 pm

    #1801357

Viewing 15 posts - 5,146 through 5,160 (of 8,753 total)