gcopeland (12/17/2008)

---

Lynn Pettis (12/17/2008)

---

The .NET CLR was designed to work with any language, unfortunately SSIS and SSRS weren't written that way pre SQL 2008. In SQL Server 2005 and...

gcopeland (12/17/2008)

---

Jack Corbett (12/17/2008)

---

It also depends on what you are doing with the language as well. As I said in my original post, if you are using SSRS or...

Okay, I did say if you knew if your data was ALL numeric. You will need to analysis your data first and see what you have. Do you...

If this were the case, there would be no choice in language. Seems to be a bit of arrogance in this stance.

I am advocate...

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....