So what? The original poster actually misrepresented his case totally.
Not my fault, really, you know. HE had the guts to stand up and excuse himself for this. Everyone else acctually, despite this, seems to think that I do something wrong? Do you guys eat arrogance for breakfast or what? In the OP's answer to my post he actually made an explanation of his problem that was totally different than his original post. So much for his "telling a bit from a byte". Thomas > -----Original Message----- > From: Unmoderated discussion of advanced .NET topics. > [mailto:[EMAIL PROTECTED] On Behalf Of Kamen Lilov > Sent: Montag, 26. Juli 2004 16:45 > 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(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Ū 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
