atultiwari.eng06 (7/3/2014)
select empid from consumer where empid in (2323,1236,5623)I want result would be of same order as i put in IN operator.see output
Output
empid
2323
1236
5623
Is this possible???
Not without having another column to use as your ordering column. Remember that IN is used to filter your rows. It has nothing to do with the order of the results. If you want ordered results there is 1 and only 1 way to do that, with an ORDER BY clause.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/