Welcome to the dBforums forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions, articles and access our other FREE features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload your own photos and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact support.

If you prefer not to see double-underlined words and corresponding ads, place your cursor
here for ContentLink opt out.

Go Back  dBforums > Database Server Software > Microsoft SQL Server > Strange View!!!

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-04-04, 18:36
GDMI. GDMI. is offline
Registered User
 
Join Date: Apr 2004
Location: LA, CA
Posts: 125
Strange View!!!

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

(see point number 8 in Brett's list)

Last edited by GDMI. : 06-14-04 at 18:14.
Reply With Quote
  #2 (permalink)  
Old 05-04-04, 18:43
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 10,129
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
Reply With Quote
  #3 (permalink)  
Old 05-04-04, 19:44
GDMI. GDMI. is offline
Registered User
 
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 18:15.
Reply With Quote
  #4 (permalink)  
Old 05-04-04, 20:50
AnSQLQuery AnSQLQuery is offline
Registered User
 
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?
Reply With Quote
  #5 (permalink)  
Old 05-05-04, 00:46
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 9,808
Maybe you should run a DBCC just to be safe...
__________________
If it's not practically useful, then it's practically useless.

blindman
http://sqlblindman.googlepages.com/main
Reply With Quote
  #6 (permalink)  
Old 05-05-04, 01:27
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 10,129
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
Reply With Quote
  #7 (permalink)  
Old 05-05-04, 06:41
AnSQLQuery AnSQLQuery is offline
Registered User
 
Join Date: Sep 2003
Location: Memphis
Posts: 62
Quote:
Originally Posted by Pat Phelan
Obviously not a Canada-weegian!

-PatP

Take off you hoser!
Reply With Quote
  #8 (permalink)  
Old 05-05-04, 08:54
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,183
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-)
My Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #9 (permalink)  
Old 05-05-04, 09:24
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 9,808
The Loch Ness Monster inhabits one of my databases.
__________________
If it's not practically useful, then it's practically useless.

blindman
http://sqlblindman.googlepages.com/main
Reply With Quote
  #10 (permalink)  
Old 05-24-04, 10:34
GDMI. GDMI. is offline
Registered User
 
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 18:15.
Reply With Quote
  #11 (permalink)  
Old 05-24-04, 10:47
Enigma Enigma is offline
The SQL Apostle
 
Join Date: Jul 2003
Location: The Dark Planet
Posts: 1,369
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
Reply With Quote
  #12 (permalink)  
Old 05-24-04, 10:47
Brett Kaiser Brett Kaiser is offline
SQLTeam Scrub
 
Join Date: Nov 2002
Location: Jersey
Posts: 9,183
It would be a big help if you scripted the view and posted the code....along with the base tables....
__________________
Brett
8-)
My Blog dbforums Yak CorralRadio 'Rita
dbForums Member List SQLTeam Member List
It's 5:00 Somewhere Pearls
The physical order of data in a database has no meaning.
Reply With Quote
  #13 (permalink)  
Old 05-24-04, 11:07
GDMI. GDMI. is offline
Registered User
 
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 18:16.
Reply With Quote
  #14 (permalink)  
Old 05-24-04, 11:31
GDMI. GDMI. is offline
Registered User
 
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 18:16.
Reply With Quote
  #15 (permalink)  
Old 05-24-04, 11:36
MCrowley MCrowley is offline
Wage drone 24601
 
Join Date: Jan 2003
Location: Massachusetts
Posts: 3,638
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 *".
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On