Results 1 to 15 of 15
  1. #1
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662

    Unanswered:

    My God! What happens if I miss a step, or put it in a different order??? I know I can specify ORDER BY StepID, but what about a missing step? I do have "missing ranges" script, but posting questions filtered through the script process may become a full-time job in itself...What to do, what to do...
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    now now trotsky. that'll do pig. that'll do.

    I hate to say it but i have to agree with Brett. Partially because he's right but mostly because it will upset you.

    it would help if some people were more clear with their questions and descriptions of issues. but many a time that is due to:
    1. A lack of understaning of the concepts required to ask the questioni
    2. A lack of understanding of english
    but so what?

    it just makes it less likely that they will get their question answered.

    I'll leave you with this.
    when and if i ever have a question for this site, i will try to be as clear and forthcoming with information as possible as my post languishes in the unanswered pile.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Never mind

    EDIT: Note to self...don't post when a). It's near midnight, and b). You've been "entertaining"
    Last edited by Brett Kaiser; 09-28-05 at 10:03.
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Ruprect
    now now trotsky. that'll do pig. that'll do.
    I love that movie

    I hate to say it but i have to agree with Brett. Partially because he's right
    A slap and a compliment...ahh, just like when I was dating...I wouldn't have it any other way......

    ummm...what do you mean partially? I usually completely satisfy my dates....

    No need for debates...the whole goal here is to provide solutions...no?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    how about we try this.
    anytime you dont like the way someone asks a question, answer the question as yoda


    "correlated subquery. you should not use".

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Wouldn't that be...

    "Use, you should not"

    But what's wrong with a coorelated sub query?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    isnt that correlated?
    see you are already on your way to helping people find the way.

    There is nothing "Wrong" with CSubs per se but you will have to acknowledge that they come with performance issues because of back and forth negotiation between the inner and outer queries. and Microsoft suggests in the KB that there are a few issues with them (having pushed out a few hotfixes just for CSubs).
    while they may be neccessary at times I have always tried to rewrite them if at all possible.

  8. #8
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    guys, do you realize that if your objective is to get newbies to read the guidelines for how to post a question, that the more bumph you add to the thread, the less likely they are to read it

    sticky threads should (unless they are "resource" threads, i.e. lists of links, etc.) be limited to one brief post, the briefer the better
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Ok, I know that in the long lost Corral I wrote a post that said I had a real problem with editing threads, but I'll make an exception in this case because this is a sticky thread. Threads like this are intended to convey specific, highly focused information, particularly for new users that won't take time to wade through interesting but off-topic commentary that really belongs in the Corral.

    Rudy: I'd appreciate it if you'd actively prune all off topic (not directly related to post #1) postings from this thread. I understand that implies pruning this posting, since it doesn't directly contribute to what this thread is about. If possible, I'd also "lock" the thread to prevent off topic posts.

    -PatP

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    brett, this is your thread, any objections to pat's recommended pruning?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    but i digress...

    Kill it!

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    prune away, and lock it.

    Thanks
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You Can Do Transplants?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  14. #14
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That's what "pruning" is... Cutting divergent posts to a different (possibly disposable) thread.

    Now we can yammer all we like without diulting the value of the sticky post. If somebody comes up with something useful to add to the original post, Rudy can prune it from here back into the (now locked) thread for reference.

    -PatP

  15. #15
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    hey brett, in your sticky, you have instructions for how to script the table in EM

    have you seen how to do it in QA?

    http://searchsqlserver.techtarget.co...129984,00.html

    some people don't like EM, does they
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •