Forum Replies Created

Viewing 15 posts - 1,531 through 1,545 (of 3,957 total)

  • RE: Tally Tables

    sknox (9/3/2013)

    Wow.

    Nobody's mentioned what I consider to be the biggest problem with this question yet.

    I'm talking about the following two answer choices:

    The first query returns a Tally table and the...

    September 3, 2013 at 7:52 pm

    #1647173

  • RE: Variable Default Values to a Stored Procedure (SQL Spackle)

    And a general thanks to everyone that took the time to read and/or post a comment on this article. I'm seeing some great suggestions here and probably all of...

    September 3, 2013 at 7:36 pm

    #1647172

  • RE: Variable Default Values to a Stored Procedure (SQL Spackle)

    Jeff Moden (9/3/2013)

    venoym (9/3/2013)

    In order to bridge the gap between Mr. Hugo's excellent comments and other comments about multiple columns, I've seen systems that used a type specific column in...

    September 3, 2013 at 7:34 pm

    #1647171

  • RE: Variable Default Values to a Stored Procedure (SQL Spackle)

    Hugo Kornelis (9/3/2013)

    The basic idea is nice, but I have my doubts concerning the implementation.

    First of all - why is there no primary key defined on the table? And why...

    September 3, 2013 at 7:32 pm

    #1647170

  • RE: Tally Tables

    L' Eomot Inversé (9/3/2013)

    Nice clear and easy question (assuming the last option "no difference" means "no difference in what they the language specification says they return" - if it means...

    September 3, 2013 at 7:21 pm

    #1647169

  • RE: Is this a "gaps and islands" problem? Finding gaps in overlapping times.

    I was going to look up this thread but Michael saved me the trouble. Thanks Michael!

    What I wanted to say was, what happened to the OP? He promised...

    September 3, 2013 at 7:14 pm

    #1647168

  • RE: sql query

    Jeff Moden (9/2/2013)

    dwain.c (9/2/2013)

    Jeff Moden (9/2/2013)

    Same goes for another atypical method (the "Multi-Pass" update) that a chap by the name of "Hugo" wrote.

    My curiosity has been piqued. Would this...

    September 2, 2013 at 8:47 pm

    #1646845

  • RE: List objects to move

    Jeff Moden (9/2/2013)

    If they're moving the app to another server, I'd hope they'd be moving the data, as well. Why not skip all the work with scripts and just...

    September 2, 2013 at 8:04 pm

    #1646842

  • RE: fill the missing/incorrect values for the gender column

    In Thailand (where I live) there is a third gender: Kathoey

    How would you handle that?

    And what of those who are "undecided?"

    September 2, 2013 at 7:15 pm

    #1646839

  • RE: sql query

    Jeff Moden (9/2/2013)

    Same goes for another atypical method (the "Multi-Pass" update) that a chap by the name of "Hugo" wrote.

    My curiosity has been piqued. Would this be Hugo Kornelski...

    September 2, 2013 at 7:08 pm

    #1646838

  • RE: Are the posted questions getting worse?

    dwain.c (9/2/2013)

    dwain.c (9/1/2013)

    Brandie Tarvin (8/30/2013)

    YAY! I have a new computer at work.

    Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc....

    September 2, 2013 at 6:48 pm

    #1646837

  • RE: List objects to move

    Erland Sommarskog (9/2/2013)

    dwain.c (9/1/2013)

    Just a note that when I did this in SQL 2008 R2 a few months back, it did not include triggers.

    Possible I did something wrong.

    Tools->Options->Scripting

    Here you can...

    September 2, 2013 at 4:39 am

    #1646719

  • RE: Are the posted questions getting worse?

    dwain.c (9/1/2013)

    Brandie Tarvin (8/30/2013)

    YAY! I have a new computer at work.

    Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And...

    September 2, 2013 at 4:37 am

    #1646718

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (8/30/2013)

    YAY! I have a new computer at work.

    Which means I have just spent all morning recovering all my SSMS options, importing my email files, etc. etc. And now...

    September 1, 2013 at 7:34 pm

    #1646655

  • RE: List objects to move

    Sean Lange (8/30/2013)

    adonetok (8/30/2013)

    In one database(Order), all my objects (in this db, some objects are not my app) for a app have to move to another server.

    SQL server administrator want...

    September 1, 2013 at 7:04 pm

    #1646654

Viewing 15 posts - 1,531 through 1,545 (of 3,957 total)