Page 1 of 3 123 LastLast
Results 1 to 15 of 34

Thread: Strange View!!!

  1. #1
    Join Date
    Apr 2004
    Location
    LA, CA
    Posts
    125

    Unanswered: Strange View!!!

    NO MIRACLES !!!!!!!!!!!!!!

    (see point number 8 in Brett's list)
    Last edited by GDMI.; 06-14-04 at 19:14.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Did you notice a lot of giggling going on at lunch, and were people looking at you strangely? Was someone "playing" with your food by any chance?

    I'll byte... That one is quite weird!

    -PatP

  3. #3
    Join Date
    Apr 2004
    Location
    LA, CA
    Posts
    125
    NO MIRACLES !!!!!!!!!!!!!!

    (see point number 8 in Brett's list)
    Last edited by GDMI.; 06-14-04 at 19:15.

  4. #4
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62

    Strange View?

    Wasn't that the name of a movie about two guys who drank beer all the time?

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Maybe you should run a DBCC just to be safe...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by AnSQLQuery
    Wasn't that the name of a movie about two guys who drank beer all the time?
    Obviously not a Canada-weegian!

    -PatP

  7. #7
    Join Date
    Sep 2003
    Location
    Memphis
    Posts
    62
    Quote Originally Posted by Pat Phelan
    Obviously not a Canada-weegian!

    -PatP
    Take off you hoser!

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Damn miracle thing again...

    Would have liked to have you script the view BEFORE your drop and create...

    Did you look at it...

    No proof now.....
    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.

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The Loch Ness Monster inhabits one of my databases.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Apr 2004
    Location
    LA, CA
    Posts
    125

    Strange View Again!!!!

    NO MIRACLES !!!!!!!!!!!!!!

    (see point number 8 in Brett's list)
    Last edited by GDMI.; 06-14-04 at 19:15.

  11. #11
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Can you post the code of the view ???
    Get yourself a copy of the The Holy Book

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

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    It would be a big help if you scripted the view and posted the code....along with the base tables....
    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
    Apr 2004
    Location
    LA, CA
    Posts
    125
    NO MIRACLES !!!!!!!!!!!!!!

    (see point number 8 in Brett's list)
    Last edited by GDMI.; 06-14-04 at 19:16.

  14. #14
    Join Date
    Apr 2004
    Location
    LA, CA
    Posts
    125
    NO MIRACLES !!!!!!!!!!!!!!

    (see point number 8 in Brett's list)
    Last edited by GDMI.; 06-14-04 at 19:16.

  15. #15
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Maybe you should replace the "*" with the field list? If you can prove it out, then Brett can add this to his list of reasons to not use "select *".

Posting Permissions

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