Forum Replies Created

Viewing 15 posts - 8,266 through 8,280 (of 9,399 total)

  • RE: Today's Random Word!

    Revenant (3/20/2014)

    Kurt W. Zimmerman (3/20/2014)

    TomThomson (3/20/2014)

    crookj (3/20/2014)

    Ed Wagner (3/20/2014)

    Stuart Davies (3/20/2014)

    BWFC (3/20/2014)

    Ed Wagner (3/19/2014)

    crookj (3/19/2014)

    Revenant (3/19/2014)

    Ed Wagner (3/19/2014)

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    Delimiter

    Pipe

    Plumbing

    Depths

    Charge

    Cash

    Dough

    Bread

    Truckin'

    Keep

    Seeker

    March 20, 2014 at 2:00 pm

    #1698882

  • RE: Need Script to Run in USER DB

    No problem. Glad to help.

    March 20, 2014 at 7:08 am

    #1698670

  • RE: Need Script to Run in USER DB

    Here's another approach that doesn't rely on dynamic SQL:

    declare @dbname sysname;

    select top 1 @dbname = name

    from sys.databases

    where database_id > 5

    order by database_id desc;

    select @dbname;

    March 20, 2014 at 5:40 am

    #1698640

  • RE: Summing - Adding a negative and a positive

    How about doing a CASE statement against the result? Then you can adjust what you subtract from what to get the answer you need. The one thing you...

    March 20, 2014 at 5:36 am

    #1698637

  • RE: Today's Random Word!

    Stuart Davies (3/20/2014)

    BWFC (3/20/2014)

    Ed Wagner (3/19/2014)

    crookj (3/19/2014)

    Revenant (3/19/2014)

    Ed Wagner (3/19/2014)

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    Delimiter

    Pipe

    Plumbing

    Depths

    Charge

    Cash

    March 20, 2014 at 5:27 am

    #1698634

  • RE: Today's Random Word!

    crookj (3/19/2014)

    Revenant (3/19/2014)

    Ed Wagner (3/19/2014)

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    Delimiter

    Pipe

    Plumbing

    March 19, 2014 at 8:53 am

    #1698404

  • RE: Today's Random Word!

    SQLRNNR (3/19/2014)

    parsename

    Quotename

    March 19, 2014 at 7:27 am

    #1698362

  • RE: Is it possible to use a parameter for csv values

    Another approach is to convert the list into a table and then run your query against the table. Here's an example using @strParams as your passed parameter string.

    declare @strParams...

    March 19, 2014 at 5:33 am

    #1698327

  • RE: Today's Random Word!

    DSP-120308 (3/18/2014)

    Again?

    EricEyster (3/18/2014)

    Stuart Davies (3/18/2014)

    BWFC (3/18/2014)

    SQLRNNR (3/18/2014)

    EricEyster (3/17/2014)

    Eric M Russell (3/17/2014)

    JAZZ Master (3/17/2014)

    Ed Wagner (3/17/2014)

    Eric M Russell (3/17/2014)

    JAZZ Master (3/17/2014)

    Daniel Bowlin (3/17/2014)

    Revenant (3/17/2014)

    Eric M Russell (3/17/2014)

    Ed Wagner (3/17/2014)

    Eric M Russell...

    March 19, 2014 at 5:07 am

    #1698315

  • RE: Are the posted questions getting worse?

    Sean Lange (3/18/2014)

    1 hour and 15 minutes until vacation. I am ready!!! We are taking the kids on a surprise trip to Branson for a few days. See you all...

    March 18, 2014 at 1:33 pm

    #1698172

  • RE: Permitted no of bytes per row

    Nice and easy question - thanks.

    March 18, 2014 at 6:35 am

    #1697966

  • RE: Today's Random Word!

    JAZZ Master (3/17/2014)

    Ed Wagner (3/17/2014)

    Eric M Russell (3/17/2014)

    JAZZ Master (3/17/2014)

    Daniel Bowlin (3/17/2014)

    Revenant (3/17/2014)

    Eric M Russell (3/17/2014)

    Ed Wagner (3/17/2014)

    Eric M Russell (3/17/2014)

    inauguration

    Start

    dissonance

    discord

    record

    breaker

    Peacemaker

    Cheesemaker (or any maker of dairy products :-D)

    Cheesecake

    Dasher

    March 18, 2014 at 6:33 am

    #1697963

  • RE: Today's Random Word!

    Eric M Russell (3/17/2014)

    JAZZ Master (3/17/2014)

    Daniel Bowlin (3/17/2014)

    Revenant (3/17/2014)

    Eric M Russell (3/17/2014)

    Ed Wagner (3/17/2014)

    Eric M Russell (3/17/2014)

    inauguration

    Start

    dissonance

    discord

    record

    breaker

    Peacemaker

    Cheesemaker (or any maker of dairy products :-D)

    March 17, 2014 at 10:32 am

    #1697729

  • RE: Today's Random Word!

    Eric M Russell (3/17/2014)

    inauguration

    Start

    March 17, 2014 at 8:21 am

    #1697656

  • RE: OPENQUERY-1

    A very interesting question. Good way to start the week. Thanks.

    March 17, 2014 at 5:45 am

    #1697600

Viewing 15 posts - 8,266 through 8,280 (of 9,399 total)