Date: Thu, 25 May 2006 11:01:45 -0500 From: Numblock User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 Subject: Re: insert into tbl1 select * from tbl2order by field1 doesnt work! References: <1148487347.481389.262580@g10g2000cwb.googlegroups.com> <#$EXAg1fGHA.2456@TK2MSFTNGP04.phx.gbl> <#GXRej2fGHA.4892@TK2MSFTNGP02.phx.gbl> <1148499874.940345.294410@u72g2000cwu.googlegroups.com> <89p9721ung6nucnn489poe07mkicajmtim@4ax.com> <1148513105.708869.82060@u72g2000cwu.googlegroups.com> <#EgqCt4fGHA.2172@TK2MSFTNGP04.phx.gbl> <1148518374.130779.48890@i39g2000cwa.googlegroups.com> <1148567420.107757.323540@g10g2000cwb.googlegroups.com> <1148572175.925900.130060@i40g2000cwc.googlegroups.com> In-Reply-To: <1148572175.925900.130060@i40g2000cwc.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: Newsgroups: microsoft.public.sqlserver.programming NNTP-Posting-Host: adsl-sp3-cdale108.micgi.com 65.171.234.108 Lines: 1 Path: g2news2.google.com!news4.google.com!news.glorb.com!logbridge.uoregon.edu!canoe.uoregon.edu!newshub.sdsu.edu!msrtrans!TK2MSFTFEEDS01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl Get a grip, stu. My feelings are not hurt. In fact I am happy that someone (not you) was able to increase my knowledge and dispel a long held theory that myself and some experts other than you and your posse have held. I mean come on, the MS Press and the Sybex books were all certified by microsoft as training materials for their own MCP exam. I am sorry but I had to believe what I felt to be overwhelming evidence to the contrary of what you and the other experts were saying. Given the several BOL quotes and book references that I sited. Besides I paid money for the books, your advice is free (unless you are planning on billing me). If you want to continue the argument, take a look at my latest post about the physical ordering of data in a clustered index. The URL I posted completely contradicts Kalen's and other's assertion that a clustered index is not physically ordered on disk. While I agree that the MSDN2 documentation may be incorrect, it just illustrates that there is widespread misconception even within microsoft about the nature of a clustered index. BTW, what time do you get out of school :) Stu wrote: > OK, meet me outside after school so we can fight about it. > > geez. >