Forum Replies Created

Viewing 15 posts - 8,566 through 8,580 (of 9,399 total)

  • RE: Need help to split Data

    Sean Lange (12/19/2013)


    abhas (12/19/2013)


    Hi,

    Sorry Sowbhari,

    its working.

    DECLARE @StartTime VARCHAR(MAX),@X XML

    SELECT @StartTime = '7:00 AM <br/> 12:30 PM'

    SELECT @X = CONVERT(XML,'

    ' + replace(@StartTime,'<br/> ','</br>

    ') + '</br>')

    SELECT x.i.value('.','varchar(max)') AS [StartTime]

    FROM @X.nodes('//br') x(i)

    Thanks.

    I...

  • RE: Backup question

    Keep in mind that the development server is just that - development. The developers should be able to rebuild anything they lose from the previous day if they're scripting...

  • RE: Today's Random Word!

    crookj (12/19/2013)


    Ed Wagner (12/19/2013)


    Stuart Davies (12/19/2013)


    JAZZ Master (12/18/2013)


    Ed Wagner (12/18/2013)


    SQLRNNR (12/18/2013)


    Stuart Davies (12/18/2013)


    Cliff Jones (12/18/2013)


    sing4you (12/18/2013)


    JAZZ Master (12/18/2013)


    crookj (12/18/2013)


    Ed Wagner (12/18/2013)


    sing4you (12/18/2013)


    Ed Wagner (12/18/2013)


    BWFC (12/18/2013)


    EL Jerry (12/17/2013)


    Revenant (12/17/2013)


    Ed Wagner (12/17/2013)


    Trek

    Star

    Wars

    Flame

    Thrower

    pitcher

    Beer

    ...

  • RE: Running a sqlcmd from Remote Machine

    When you write to the output file using a UNC path, make sure that the account you're running under has permission to write to the network folder you specify. ...

  • RE: Today's Random Word!

    Stuart Davies (12/19/2013)


    JAZZ Master (12/18/2013)


    Ed Wagner (12/18/2013)


    SQLRNNR (12/18/2013)


    Stuart Davies (12/18/2013)


    Cliff Jones (12/18/2013)


    sing4you (12/18/2013)


    JAZZ Master (12/18/2013)


    crookj (12/18/2013)


    Ed Wagner (12/18/2013)


    sing4you (12/18/2013)


    Ed Wagner (12/18/2013)


    BWFC (12/18/2013)


    EL Jerry (12/17/2013)


    Revenant (12/17/2013)


    Ed Wagner (12/17/2013)


    Trek

    Star

    Wars

    Flame

    Thrower

    pitcher

    Beer

    Belly

    dancer

    prancer

    Donner

    Kebab

    venison

    shot

    gun

    Slinger

    Revolvers

  • RE: Today's Random Word!

    SQLRNNR (12/18/2013)


    Stuart Davies (12/18/2013)


    Cliff Jones (12/18/2013)


    sing4you (12/18/2013)


    JAZZ Master (12/18/2013)


    crookj (12/18/2013)


    Ed Wagner (12/18/2013)


    sing4you (12/18/2013)


    Ed Wagner (12/18/2013)


    BWFC (12/18/2013)


    EL Jerry (12/17/2013)


    Revenant (12/17/2013)


    Ed Wagner (12/17/2013)


    Trek

    Star

    Wars

    Flame

    Thrower

    pitcher

    Beer

    Belly

    dancer

    prancer

    Donner

    Kebab

    venison

    shot

  • RE: Today's Random Word!

    sing4you (12/18/2013)


    Ed Wagner (12/18/2013)


    BWFC (12/18/2013)


    EL Jerry (12/17/2013)


    Revenant (12/17/2013)


    Ed Wagner (12/17/2013)


    Trek

    Star

    Wars

    Flame

    Thrower

    pitcher

    Beer

  • RE: Today's Random Word!

    BWFC (12/18/2013)


    EL Jerry (12/17/2013)


    Revenant (12/17/2013)


    Ed Wagner (12/17/2013)


    Trek

    Star

    Wars

    Flame

    Thrower

  • RE: Are the posted questions getting worse?

    mister.magoo (12/17/2013)


    Good day Threadizens 🙂

    I have written an article (my first) on how to get help with SSRS reports.

    It was inspired by Jeff's classic "Forum Etiquette: How to post data/code...

  • RE: Are the posted questions getting worse?

    Sean Lange (12/17/2013)


    jcrawf02 (12/17/2013)


    Sean Lange (12/17/2013)


    Stefan Krzywicki (12/17/2013)


    Sean Lange (12/17/2013)


    Ed Wagner (12/17/2013)


    jasona.work (12/17/2013)


    Ed Wagner (12/16/2013)


    jasona.work (12/13/2013)


    Ed Wagner (12/13/2013)


    jasona.work (12/13/2013)


    OK, where did the year go?

    I mean seriously, 12 days until X-Mas?...

  • RE: Today's Random Word!

    JAZZ Master (12/17/2013)


    Ed Wagner (12/16/2013)


    crookj (12/16/2013)


    jasona.work (12/16/2013)


    bcsims 90437 (12/16/2013)


    Revenant (12/16/2013)


    Daniel Bowlin (12/16/2013)


    Ed Wagner (12/13/2013)


    crookj (12/13/2013)


    SQLRNNR (12/13/2013)


    peer

    pier

    Walk

    duck

    quack

    Doctor??????

    Who?

    Daleks

    Tribbles

    Trouble

    Trek

  • RE: Extract the data based on the present quarter and last quarter

    You're going to need to use the DATEPART function to determine the quarter for the date on which you're basing the distribution. http://msdn.microsoft.com/en-us/library/ms174420%28v=sql.100%29.aspx. Other than that, Luis is...

  • RE: Are the posted questions getting worse?

    jasona.work (12/17/2013)


    Ed Wagner (12/16/2013)


    jasona.work (12/13/2013)


    Ed Wagner (12/13/2013)


    jasona.work (12/13/2013)


    OK, where did the year go?

    I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago...

  • RE: Are the posted questions getting worse?

    jasona.work (12/13/2013)


    Ed Wagner (12/13/2013)


    jasona.work (12/13/2013)


    OK, where did the year go?

    I mean seriously, 12 days until X-Mas? It feels like it was only a couple weeks ago I was starting...

  • RE: Are the posted questions getting worse?

    WayneS (12/16/2013)


    Jack Corbett (12/16/2013)


    WayneS (12/13/2013)


    Greg Edwards-268690 (12/13/2013)


    jasona.work (12/13/2013)


    Ed Wagner (12/13/2013)


    jasona.work (12/13/2013)


    OK, where did the year go?

    I mean seriously, 12 days until X-Mas? It feels like it was...

Viewing 15 posts - 8,566 through 8,580 (of 9,399 total)