What, doesn't anybody want to use 'order by' anymore? -----Original Message----- From: Kamen Lilov [mailto:[EMAIL PROTECTED] Sent: Monday, July 26, 2004 10:45 AM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and SQL Server
Thomas, in this particular case Clemens is completely right. You are being obnoxious. Got a need to vent your anger at someone? Try some of the jerks on less advanced forums who ask for help (or, more like, handholding) without bothering to even read the documentation first. This is a serious forum, and the original poster explained the issue well enough so that we don't need to automatically assume he can't tell a bit from a byte. -----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Tomiczek Sent: Monday, July 26, 2004 5:05 PM To: [EMAIL PROTECTED] Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and SQL Server And in return I will refrain from telling you loudly what I think of people making posts such as yours. Very nicely, clemens. One of the most arrogant posts I read in the last weeks here. I was not insulting at all. All I did point oout is that someone had not done his homework (but came to an advanced forum) based on what turned out to be a total bad decsription of the error. What terms you associate with this I do not know. I consider incompetence not acceptable. Maybe in your ocmpany it IS acceptable. Your decision. That simple. Thomas > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of > Clemens F. Vasters > Sent: Montag, 26. Juli 2004 16:00 > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and > SQL Server > > It's a puzzle to me what sort of mental state would trigger > anyone being so arrogant (and insulting) just because someone > else has a bit of a misconception about how things work and > is therefore asking for help. > > I can think of a few terms I usually associate with folks > having such an attitude, but I think I will rather skip the > enumeration given that this is a public forum. > > -cv > > > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Thomas > Tomiczek > Sent: Monday, July 26, 2004 3:30 PM > To: [EMAIL PROTECTED] > Subject: Re: [ADVANCED-DOTNET] Common Sort Order for .NET and > SQL Server > > Ok, let's go. > > > -----Original Message----- > > From: Unmoderated discussion of advanced .NET topics. > > [mailto:[EMAIL PROTECTED] On Behalf Of Jon > > Stonecash > > Sent: Montag, 26. Juli 2004 14:13 > > To: [EMAIL PROTECTED] > > Subject: [ADVANCED-DOTNET] Common Sort Order for .NET and SQL Server > > > > I am having a problem getting SQL Server and .NET to agree > on the sort > > order for some data. > > Really? > > > My sort column in SQL Server is character data ([varchar] > > (255) COLLATE SQL_Latin1_General_CP1_CI_AS). As I understand this, > > the data sorts in dictionary order. Thus, a value of "F-SA" sorts > > between "FR" and "FT". > > Tip: you seem to haves kipped reading the beginner section of > your SQL documentation. Your understanding is totally unsubstantiated. > > > The problem is that .NET seems to think that the data is not > > in order. I > > And guess what, .NET is right with this. > > Beginner SQL: unless you explicitly sort the data, it is > unsorted in the returned data set. > > > have tried all of the CultureInfo settings that I can think of to > > convince .NET to see this as ordered. I have a need to > > Why not fix your bugs regarding any basick nowledge how SQL > works, instead of trying to get .NET agreeing? > > > process these rows and compare them to another sorted > stream of data > > and the comparison is going nuts when it gets to these "special > > cases". > > Then why do you not sort the data? > > > Is there a way to get SQL Server and .NET on the same (code) page > > without sorting the data internally after reading it from > SQL Server? > > No. SQL 101. Unless the SQL statement specifies a sort order, > sort order is random. > > That said - why do you not just specify a sort order in your > query? This is pretty simple, and you do not have to resort > on the client then. It just is not automatic. > > Note: SQL is SET ORIENTED. Sets do not have an intrinsic sort order. > > Thomas Tomiczek > THONA Software & Consulting Ltd. > (Microsoft MVP C#/.NET) > (CTO PowerNodes Ltd.) > > > > > Jon Stonecash > > > > =================================== > > This list is hosted by DevelopMentor(r) > http://www.develop.com Some > > .NET courses you may be interested in: > > > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > > http://www.develop.com/courses/gaspdotnetls > > > > View archives and manage your subscription(s) at > > http://discuss.develop.com > > > > =================================== > This list is hosted by DevelopMentor(r) > http://www.develop.com Some .NET courses you may be interested in: > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > http://www.develop.com/courses/gaspdotnetls > > View archives and manage your subscription(s) at > http://discuss.develop.com > > =================================== > This list is hosted by DevelopMentor(r) http://www.develop.com > Some .NET courses you may be interested in: > > NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles > http://www.develop.com/courses/gaspdotnetls > > View archives and manage your subscription(s) at > http://discuss.develop.com > =================================== This list is hosted by DevelopMentorR http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorŪ http://www.develop.com Some .NET courses you may be interested in: NEW! Guerrilla ASP.NET, 17 May 2004, in Los Angeles http://www.develop.com/courses/gaspdotnetls View archives and manage your subscription(s) at http://discuss.develop.com
