Viewing 15 posts - 1,546 through 1,560 (of 2,452 total)
SELECT houseno
FROM <yourtable>
ORDER BY houseno
however...I have a suspicion that you have over simplified your requirements .......???
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 15, 2014 at 8:55 am
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 10, 2014 at 2:10 pm
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
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 10, 2014 at 1:26 pm
maybe of some use
with cte_names as
(
SELECT StudentID, MAX(StudentName) AS StudentName
FROM lcdscores
GROUP BY StudentID
)
SELECT lcdscores.StudentID
...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 10, 2014 at 1:22 pm
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 10, 2014 at 12:33 pm
ChrisM@home (12/15/2013)
select quarie between houseno ..........
select only up to first '-' only
display order by like 1,2,3,4,5...............plz write quarie
relate...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 16, 2013 at 10:33 am
yantonyam (12/2/2013)
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...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
December 2, 2013 at 9:54 am
some scripts to define table along with example data and expected output from example data will help considerably please.
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
November 4, 2013 at 1:17 pm
nitinuniyal (10/27/2013)
Example: - My Column is 2345678987654321 and it can be any number, So I want to put...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 27, 2013 at 1:39 pm
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 =...
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 22, 2013 at 11:24 pm
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')
)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 21, 2013 at 3:13 pm
what version of Progress(Open Edge) are you running?
what version of ODBC driver have you installed?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2013 at 1:18 pm
shashi_1409 (10/20/2013)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2013 at 9:51 am
where are your scripts stored?
can you open them in notepad from the drive?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 20, 2013 at 9:02 am
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 🙂
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 16, 2013 at 12:26 pm
Viewing 15 posts - 1,546 through 1,560 (of 2,452 total)