query needed

[Ashok Nalam]

I have table data like this Id(PrimaryKey) Time Value Time Order 1 06:00AM 1 2 07:00AM 2 3 08:00AM 3 4 09:00AM 4 5 10:00AM 5 6 11:00AM 6 If I get query like select * from table order by Time Order then I will above data My requirement is if I have 2 customers • Customer1 configure start time as 08:00AM then I have to bind drop down first value as 08:00AM , 09:00AM, 10:00AM, 11:00AM, 06:00AM, 07:00AM • Customer1 configure start time as 10:00AM then I have to bind drop down first value as 10:00AM , 11:00AM, 06:00AM, 07:00AM, 08:00AM, 09:00AM So it has basically start from ( based on configuration by customer specific) to end time then start time onwards. Can you please how can we write SQL query above and how can I achive above requirement? Thank, Ashok

Ashok Nalam

[i j russell]

I wouldn't write this as SQL. I would populate the list that you use in the dropdown in c#/vb.net using data from the query that you already have.

[Not Active]

SELECT * FROM Table
WHERE TimeOrder >= @StartOrder

UNION ALL

SELECT * FROM Table
WHERE TimeOrder < @StartOrder

---

only two letters away from being an asset

[Ashok Nalam]

I need sql statement for reporting purpose also please provide the sql

Ashok Nalam

[Not Active]

And what they are not using a dropdown list? What if it is needed for a report or a view?

---

only two letters away from being an asset

[i j russell]

The initial request said "bind drop down" so I assumed that they wanted to populate a list to fill a dropdown.

[i j russell]

The only way to guarantee the order of a resultset is to use an ORDER BY clause;

SELECT Id, TimeValue, TimeOrder
FROM
(
SELECT Id, TimeValue, TimeOrder, 0 as result
FROM #data
WHERE TimeOrder >= @StartOrder
UNION ALL
SELECT Id, TimeValue, TimeOrder, 1
FROM #data
WHERE TimeOrder < @StartOrder
) as t
ORDER BY result ASC, TimeOrder asc

[Nisha Agrawal]

yes, you are right. If records are already not in order in what we need then we need to sort it as per the requirement.

[i j russell]

That's not what I said. I said that the only way to guarantee the order of the results is to use an ORDER BY clause. Without the sort, the results may or may not be returned in the order that you want depending upon how the query optimizer decides to handle your request.