Forum Replies Created

Viewing 15 posts - 3,556 through 3,570 (of 9,399 total)

  • RE: how to avoid bad character in sql server

    If this is something you need to do frequently, you can create an inline table-valued function to do the cleaning for you. Here's one:

    CREATE FUNCTION dbo.CleanAlphaNumeric(@OriginalText Varchar(8000)) RETURNS TABLE...

    March 18, 2016 at 5:06 am

    #1866096

  • RE: Converting Questionable Dates

    Nice and simple, once you see the data type. That was probably the point. Thanks, Steve.

    March 18, 2016 at 4:58 am

    #1866093

  • RE: Today's Random Word!

    BWFC (3/18/2016)

    BL0B_EATER (3/18/2016)

    ThomasRushton (3/18/2016)

    Ed Wagner (3/17/2016)

    djj (3/17/2016)

    Grumpy DBA (3/17/2016)

    Manic Star (3/17/2016)

    Light

    Beer

    Ale

    Pub

    database

    page

    plant

    Zeppelin

    March 18, 2016 at 4:54 am

    #1866092

  • RE: Today's Random Word!

    djj (3/17/2016)

    Grumpy DBA (3/17/2016)

    Manic Star (3/17/2016)

    Light

    Beer

    Ale

    Pub

    March 17, 2016 at 1:53 pm

    #1865989

  • RE: Today's Random Word!

    DonlSimpson (3/17/2016)

    crookj (3/17/2016)

    Ed Wagner (3/17/2016)

    Luis Cazares (3/17/2016)

    Revenant (3/17/2016)

    DonlSimpson (3/17/2016)

    Ed Wagner (3/17/2016)

    crookj (3/17/2016)

    Manic Star (3/17/2016)

    Ed Wagner (3/17/2016)

    Grumpy DBA (3/17/2016)

    Ed Wagner (3/17/2016)

    ThomasRushton (3/17/2016)

    Grumpy DBA (3/17/2016)

    djj (3/17/2016)

    Terminator

    Genisys

    Sledgehammer

    Gabriel (Peter)

    Solsbury (Hill)

    Eyes

    Private

    Sergeant

    Colonel

    Kernel

    Windows (or any other OS)

    Doors

    Fire

    (the)...

    March 17, 2016 at 12:33 pm

    #1865968

  • RE: Today's Random Word!

    Luis Cazares (3/17/2016)

    Revenant (3/17/2016)

    DonlSimpson (3/17/2016)

    Ed Wagner (3/17/2016)

    crookj (3/17/2016)

    Manic Star (3/17/2016)

    Ed Wagner (3/17/2016)

    Grumpy DBA (3/17/2016)

    Ed Wagner (3/17/2016)

    ThomasRushton (3/17/2016)

    Grumpy DBA (3/17/2016)

    djj (3/17/2016)

    Terminator

    Genisys

    Sledgehammer

    Gabriel (Peter)

    Solsbury (Hill)

    Eyes

    Private

    Sergeant

    Colonel

    Kernel

    Windows (or any other OS)

    Doors

    Fire

    March 17, 2016 at 11:38 am

    #1865950

  • RE: The Math on Automation

    Gary Varga (3/17/2016)

    Steve Jones - SSC Editor (3/17/2016)

    Gary Varga (3/17/2016)

    Jeff Moden (3/16/2016)

    The drawing in the article is what I've seen a whole lot of automated testing do. People don't...

    March 17, 2016 at 11:14 am

    #1865939

  • RE: Today's Random Word!

    crookj (3/17/2016)

    Manic Star (3/17/2016)

    Ed Wagner (3/17/2016)

    Grumpy DBA (3/17/2016)

    Ed Wagner (3/17/2016)

    ThomasRushton (3/17/2016)

    Grumpy DBA (3/17/2016)

    djj (3/17/2016)

    Terminator

    Genisys

    Sledgehammer

    Gabriel (Peter)

    Solsbury (Hill)

    Eyes

    Private

    Sergeant

    Colonel

    March 17, 2016 at 9:34 am

    #1865906

  • RE: Today's Random Word!

    Grumpy DBA (3/17/2016)

    Ed Wagner (3/17/2016)

    ThomasRushton (3/17/2016)

    Grumpy DBA (3/17/2016)

    djj (3/17/2016)

    Terminator

    Genisys

    Sledgehammer

    Gabriel (Peter)

    Solsbury (Hill)

    Eyes

    March 17, 2016 at 9:09 am

    #1865896

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (3/17/2016)

    TomThomson (3/17/2016)

    mister.magoo (3/16/2016)

    I can only really get on board with the Empty Set, as both the other options, if COUNTed would tell me the string had split into...

    March 17, 2016 at 8:49 am

    #1865888

  • RE: Today's Random Word!

    ThomasRushton (3/17/2016)

    Grumpy DBA (3/17/2016)

    djj (3/17/2016)

    Terminator

    Genisys

    Sledgehammer

    Gabriel (Peter)

    March 17, 2016 at 8:46 am

    #1865887

  • RE: Today's Random Word!

    ThomasRushton (3/17/2016)

    Revenant (3/16/2016)

    Ed Wagner (3/16/2016)

    whereisSQL? (3/16/2016)

    Grumpy DBA (3/16/2016)

    DonlSimpson (3/16/2016)

    Basketball

    Madness

    Bracket

    Parenthesis

    Quote

    S'gonnercostyerguv'nor...

    Governor

    March 17, 2016 at 5:25 am

    #1865822

  • RE: Numeric or Decimal Data Type in SQL 2012?

    Jeff Moden (3/16/2016)

    It's been my experience that it's more important to front-enders than DBAs unless the DBA is also a "Portable Code" zealot. As BOL states, they are functionally...

    March 16, 2016 at 6:59 pm

    #1865770

  • RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

    Jeff Moden (3/16/2016)

    mister.magoo (3/16/2016)

    Jeff Moden (3/16/2016)

    So, what would you prefer to see with the following (using a cte as if a Table Source)...

    WITH cteTestData (RowNum,CSV) AS

    (

    SELECT 1, '1,2,3' UNION...

    March 16, 2016 at 6:47 pm

    #1865769

  • RE: Change t-sql 2012 to not use a cte

    However you approach it, the query should work fine from .NET. If you want to keep the query code in the database, turn it into a stored procedure and...

    March 16, 2016 at 6:37 pm

    #1865768

Viewing 15 posts - 3,556 through 3,570 (of 9,399 total)