Hi,
this is simple - but i do not know how many values you have
if this is small count then
select
Fields
FROM
TABLE_NAME
ORDER BY CASE WHEN ID=1032 THEN 1 WHEN ID=624 THEN 2 WHEN ID=2841 THEN 3 END
and if this is big numer then add better temp table with order values
regards,
Karol Bienias
Hello Caroline
If you can read Spanish, then at this article:
http://firebird21.wordpress.com/2013/11/10/enviando-y-recibiendo-una-cantidad-variable-de-parametros-en-los-stored-procedures/
you will see a technique for achieving that you want.
Greetings.
Walter.
On Wed, Nov 19, 2014 at 5:50 P
I hope that someone can advise how I can efficiently arbitrarily select
data from a table. I am provided with a list of IDs to display, for
example:
Employee ID Numbers: 1032, 624, and 2841.
This would be the output (in the same order as the list above):
Employee ID FName LName