SELECT houseno

FROM <yourtable>

ORDER BY houseno

however...I have a suspicion that you have over simplified your requirements .......???

what happens for line 18?

SELECT 17, 84019, 2057.00, '20121031 00:00:00.000', 17, 16 UNION ALL

SELECT 18, 84019, 2054.00, '20121108 00:00:00.000', 18, 15 UNION ALL

SELECT 19, 84019, 2070.00, '20121126 00:00:00.000', 19, 17...

care to share some DDL for your tables / sample data / and expected results from your sample data....would help us all in providing assistance.

kind regards

maybe of some use

with cte_names as

(

SELECT StudentID, MAX(StudentName) AS StudentName

FROM lcdscores

GROUP BY StudentID

)

SELECT lcdscores.StudentID

...

care to share some of the "differences".....and provide an idea of what the exg db tables/columns map to in the new db.

whatever process you use....you will need to map these.

also...

ChrisM@home (12/15/2013)

---

Each one of your five current threads

select quarie between houseno ..........

select house_no order

select only up to first '-' only

display order by like 1,2,3,4,5...............plz write quarie

display order by houseno

relate...

yantonyam (12/2/2013)

---

Hi Manish,

Did you get the solution of the issue?

I am facing the same issue and not sure what to do with it.

If you have the solution, please share it...

some scripts to define table along with example data and expected output from example data will help considerably please.

nitinuniyal (10/27/2013)

---

While upload I want to replace ‘*’ in one column which is varchar.

Example: - My Column is 2345678987654321 and it can be any number, So I want to put...

does this work for you ...?

with cte as

(

SELECT iphone_id, MAX(date_assigned) AS Maxd

FROM location_history

GROUP BY iphone_id

)

SELECT iPhones.iphone_id,

iPhones.seriel_number,

cte.Maxd,

locations.Emp_name,

locations.Department

FROM iPhones

INNER JOIN cte ON iPhones.iphone_id =...

SELECT invoice_id

FROM <YOURTABLE>

WHERE LEFT(invoice_id, 6) NOT IN

(

SELECT DISTINCT LEFT(invoice_id, 6)

FROM <YOURTABLE>

WHERE (RIGHT(invoice_id, 4) = '0001')

)

what version of Progress(Open Edge) are you running?

what version of ODBC driver have you installed?

shashi_1409 (10/20/2013)

---

my scripts are on the filesystem and it opens in notepad but I don't see any code in it ,they are all empty. strange is that the filesizes is...

where are your scripts stored?

can you open them in notepad from the drive?

SELECT CONVERT(VARCHAR(10), DATEADD(mm, DATEDIFF(mm, 0, FlightDate), 0), 102) AS FlightMonth,

COUNT(PaxNum) AS TotalPassengersCount

FROM FlightDetails

GROUP BY DATEADD(mm, DATEDIFF(mm, 0, FlightDate), 0)

ORDER BY DATEADD(mm, DATEDIFF(mm, 0, FlightDate), 0)

another idea 🙂