Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 8,761 total)

  • RE: need help in converting nvarchar to datetime

    sree25 (7/24/2015)

    I have a column name DateofRecord and it is nvarchar type..all the values in this column are like this

    "04/24/2013'

    "05/01/2014"...etc...my requirement is to convert this column into Datetime..any suggestions?

    I tried...

    July 24, 2015 at 12:46 pm

    #1814883

  • RE: Today's Random Word!

    DonlSimpson (7/23/2015)

    Ed Wagner (7/23/2015)

    J Livingston SQL (7/23/2015)

    Revenant (7/23/2015)

    Eirikur Eiriksson (7/23/2015)

    SQLRNNR (7/23/2015)

    cowboy

    dichotomy

    Opposition

    antithesis

    Conflict

    Resolution

    Clarity

    July 23, 2015 at 2:42 pm

    #1814577

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/23/2015)

    PORN - Purchase Order Return Number

    That by itself raises "some questions":hehe:

    😎

    July 23, 2015 at 2:20 pm

    #1814564

  • RE: Rename a File in SSIS (SSDT) using an expression

    Quick thought, you can either do a copy/rename snd a delete with a file system task or a rename with a scipt task an file system objecr.

    😎

    July 23, 2015 at 11:30 am

    #1814477

  • RE: Today's Random Word!

    SQLRNNR (7/23/2015)

    cowboy

    dichotomy

    July 23, 2015 at 11:17 am

    #1814470

  • RE: Are the posted questions getting worse?

    Just a thought,but don't you love your job when:

    a) you observe your systems for a while, then make one small change that improves performance significantly and massively reduces the load...

    July 23, 2015 at 11:09 am

    #1814466

  • RE: Are the posted questions getting worse?

    GilaMonster (7/23/2015)

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Congratulations again Gail, good job indeed!

    😎

    July 23, 2015 at 10:57 am

    #1814462

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/23/2015)

    Steve Jones - SSC Editor (7/23/2015)

    Alvin Ramard (7/22/2015)

    Brandie Tarvin (7/22/2015)

    Gotta love it when someone schedules a software change/update at month end. Because "there's no impact to the business"...

    July 23, 2015 at 9:18 am

    #1814428

  • RE: Are the posted questions getting worse?

    Sioban Krzywicki (7/23/2015)

    Wondering what you all would say if you were presented with a NoSQL system being developed for all your data and were told "It isn't meant to be...

    July 23, 2015 at 9:12 am

    #1814424

  • RE: Today's Random Word!

    Ed Wagner (7/20/2015)

    whereisSQL? (7/20/2015)

    DonlSimpson (7/20/2015)

    crookj (7/20/2015)

    Gang

    Sam Cooke

    Sing

    Concert

    Instrument

    July 20, 2015 at 10:22 pm

    #1813769

  • RE: Today's Random Word!

    Revenant (7/20/2015)

    Luis Cazares (7/20/2015)

    Ed Wagner (7/20/2015)

    Eirikur Eiriksson (7/20/2015)

    SQLRNNR (7/20/2015)

    Ed Wagner (7/20/2015)

    BWFC (7/20/2015)

    Eirikur Eiriksson (7/20/2015)

    Ed Wagner (7/20/2015)

    djj (7/20/2015)

    Eirikur Eiriksson (7/18/2015)

    jasona.work (7/17/2015)

    djj (7/17/2015)

    crookj (7/17/2015)

    Ed Wagner (7/17/2015)

    Jeff Moden (7/16/2015)

    SQLRNNR (7/16/2015)

    clam

    fn_clam 😀

    Oyster

    Pismo (The Great...

    July 20, 2015 at 10:15 am

    #1813693

  • RE: Error in dbcc check table (please help me)

    andre1983 (7/20/2015)

    Hello people I'm new here ni SQLServerCentral my name and André'm from Brazil

    and I have some problems with a faulty basis. The situation and the following have a table...

    July 20, 2015 at 9:56 am

    #1813686

  • RE: Today's Random Word!

    SQLRNNR (7/20/2015)

    Ed Wagner (7/20/2015)

    BWFC (7/20/2015)

    Eirikur Eiriksson (7/20/2015)

    Ed Wagner (7/20/2015)

    djj (7/20/2015)

    Eirikur Eiriksson (7/18/2015)

    jasona.work (7/17/2015)

    djj (7/17/2015)

    crookj (7/17/2015)

    Ed Wagner (7/17/2015)

    Jeff Moden (7/16/2015)

    SQLRNNR (7/16/2015)

    clam

    fn_clam 😀

    Oyster

    Pismo (The Great Clam Festival)

    Geoduck

    Dirty

    Read

    Random

    Sequential

    Waterfall

    Cataract

    Stigmatism

    fn_eye

    tvfn_eyes

    July 20, 2015 at 8:50 am

    #1813672

  • RE: Why you are not getting error with this?????????

    dudekula.kareemulla (7/20/2015)

    DECLARE @@@Temp TABLE(ID INT IDENTITY,TempID BIGINT)

    SELECT * FROM @@@Temp

    It is a valid (table) variable name, no error in the code.

    😎

    For fun

    declare @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ int = 1

    select @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

    July 20, 2015 at 6:36 am

    #1813629

  • RE: Today's Random Word!

    Ed Wagner (7/20/2015)

    djj (7/20/2015)

    Eirikur Eiriksson (7/18/2015)

    jasona.work (7/17/2015)

    djj (7/17/2015)

    crookj (7/17/2015)

    Ed Wagner (7/17/2015)

    Jeff Moden (7/16/2015)

    SQLRNNR (7/16/2015)

    clam

    fn_clam 😀

    Oyster

    Pismo (The Great Clam Festival)

    Geoduck

    Dirty

    Read

    Random

    Sequential

    Waterfall

    July 20, 2015 at 6:11 am

    #1813624

Viewing 15 posts - 4,876 through 4,890 (of 8,761 total)