Forum Replies Created

Viewing 15 posts - 691 through 705 (of 880 total)

  • RE: How to find postcodes with two spaces in the middle?

    Luis Cazares (6/20/2016)


    HappyGeek (6/20/2016)


    EdVassie (5/27/2016)


    export it to Excel and do a simple find and replace

    What is wrong with

    UPDATE yourtable

    SET Postcode = Replace(Postcode, ' ', ' ')

    FROM...

  • RE: How to find postcodes with two spaces in the middle?

    EdVassie (5/27/2016)


    export it to Excel and do a simple find and replace

    What is wrong with

    UPDATE yourtable

    SET Postcode = Replace(Postcode, ' ', ' ')

    FROM yourtable

    WHERE postcode LIKE...

  • RE: search address records using addressline1

    I think what you are looking for is to set up a full text catalog and index on the address columns. There are many articles that show how this can...

  • RE: Today's Random Word!

    crookj (6/17/2016)


    djj (6/17/2016)


    Ed Wagner (6/17/2016)


    Hugo Kornelis (6/17/2016)


    Revenant (6/17/2016)


    Manic Star (6/17/2016)


    ThomasRushton (6/17/2016)


    Luis Cazares (6/17/2016)


    Manic Star (6/17/2016)


    Root

    Cause

    Consequence

    game

    Minecraft

    Xbox

    Controller

    Pneumatic

    Lift

    Ski

    Snow

  • RE: Checkpoints

    Good question, thanks.

  • RE: Database Documentation

    This has absolutely no relevance to SQL2016 per sa unless it happened the be the installation under consideration. I did think I put the question in the wrong place and...

  • RE: Today's Random Word!

    djj (6/15/2016)


    Ed Wagner (6/15/2016)


    Grumpy DBA (6/15/2016)


    crookj (6/15/2016)


    Family

    Guy

    Cable

    Larry

    Leisure Suit

  • RE: sql server 2014 installation issue

    expert 70637 (6/15/2016)


    2.A failed install can result in a restart pending state being an invalid condition.

    "

    This is true and normally requires delving into the registry to find the culprit. Have...

  • RE: Today's Random Word!

    TomThomson (6/13/2016)


    Ed Wagner (6/13/2016)


    Revenant (6/13/2016)


    ThomasRushton (6/13/2016)


    Ed Wagner (6/13/2016)


    Grumpy DBA (6/13/2016)


    Eating

    Meal time

    Epic

    Feature

    Bug

    Wiretap

    Hack

  • RE: Benefits of Resource Governor

    Good question thanks

  • RE: Default OPENJSON

    Wrong again, looked it up but obviously read the wrong bit!! Good question need 2016 I think to keep up!!

  • RE: Today's Random Word!

    Revenant (6/10/2016)


    djj (6/10/2016)


    ThomasRushton (6/10/2016)


    Ed Wagner (6/10/2016)


    djj (6/10/2016)


    Grumpy DBA (6/10/2016)


    Ed Wagner (6/10/2016)


    HappyGeek (6/10/2016)


    ThomasRushton (6/10/2016)


    Stuart Davies (6/10/2016)


    Ray K (6/9/2016)


    Hugo Kornelis (6/9/2016)


    Poke

    Owwww!

    Pain

    Neck

    Polo

    Horse

    Glue

    Gun

    Gatling

    Nerf

    Soft

    Ware

    Goods

  • RE: Today's Random Word!

    ThomasRushton (6/10/2016)


    Stuart Davies (6/10/2016)


    Ray K (6/9/2016)


    Hugo Kornelis (6/9/2016)


    Poke

    Owwww!

    Pain

    Neck

    Polo

  • RE: Remove the first two digit and change phonenumber format SQL

    Is this the same post as on the SQL 2012 forum?

  • RE: Stats_date()

    Good question thanks learnt something new.

Viewing 15 posts - 691 through 705 (of 880 total)