General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a table and I need to determine if there is more than one record for an employee. Is it faster to set a filter based on that employee and check the record count or create a query into a cursor?
Also if I filter based on the employee, will that affect the sort order? Will the first record for the employee that appears in the table as it is sorted still be the first one?
If I query into a cursor, there is a chance that it may not be sort the same way unless I specify a sort order, correct?
Thank you
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only