If you are sure that the values are all numeric, you can do this:

ORDER BY

CAST(YourColumn as INT)

Not sure. I did a lot of COBOL programming at my previous employer and I think moving to an OO environment where I could continue to use the skills...

EXISTS is available in SQL Server 2005 CE, so I'd hope it was also available in earlier versions. Have you checked BOL for your version?

Actually, they have made this COBOL pretty much OO. I have been looking at the web site, and it looks like there is a lot of effort behind it...

If you have been COBOL shop for years, why not look at Fujitsu NetCOBOL for .NET?

You may still need VB.NET for SSIS, SSRS, et al.

Well, it is still alive and kicking. My co-worker was taking a C class in college, wrote his programs using Power Basic first and got it working, then ported...

It would help if you could provide the table DDL (create statement), some sample data (in the form of insert statements), and what your expected results would be based on...

Co-worker at my previous employer really like Power Basic. Creates extremely fast and tight code. They recently added a /bloat switch that makes the executable bigger, but still...

You will have to test the following code as I am currently applying SP3 to my system here at home.

;with MyData (

rownum,

colA,

...

Just to be sure, as this is posted in a SQL Server 2005 forum (we have had SQL Server 2000 posts here), that you are using SQL Server 2005. ...

This could be as easy as a simple pivot or a more complex dynamic pivot. Based on your data provided, it is a little difficult to know for sure....

Now that makes total sense. Here is some code:

create Table #temp1

(

id int,

Rno int,

sno int

)

insert into #temp1 values(10,125,32)

insert into #temp1 values(20,145,32)

insert into #temp1 values(10,125,32)

insert into #temp1 values(30,125,32)

insert into...

Steve Jones - Editor (12/16/2008)

---

I'm happy to entertain moderator nominations. It helps to have others that can move threads if they're in the wrong spot. I hate to have people...

I'm sorry, but I'm confused as to what you want as a result set based on the sample data. Your verbal discription is confusing, and your answer to Barry...

david.c.holley (12/16/2008)

---

Been busy...

For the record, the discussion groups that I have been apart of do not have stringent rules as to what needs to be included and what does not....