hi The_Doc_Man,
thank you! Nice approach.
if i will set up flag how can i set this record as first?
for example it will be ID = 987 with flag = "Yes".
What is working for me is:
I will get here Tab3 as first occurence.
Jacek
thank you! Nice approach.
Then make its record ID the first record using that order.
if i will set up flag how can i set this record as first?
for example it will be ID = 987 with flag = "Yes".
What is working for me is:
SELECT 1 AS SortKey, Table1.TableName
FROM Table1
ORDER BY Table1.TableName
UNION
SELECT 0 AS SortKey, "Tab3" AS TableName FROM Table1
order by SortKey
I will get here Tab3 as first occurence.
Jacek