Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  Oracle sql to MS SQL

Author  Topic  abulloch Starting Member 1 Post Posted - 2010-02-03 : 08:18:47 Please could someone assist I need to convert the following piece of Oracle SQL to MS SQL. The KEEP FIRST part is teh confusing bit. Any suggestions ? MIN (COALESCE (A5.LINE_NUMBER, A6.LINE_NUMBER, A7.LINE_NUMBER, A8.LINE_NUMBER)) )KEEP (DENSE_RANK FIRST ORDER BY ISNULL(A10.T$SUBL,9) * 1000 + ISNULL (A11.T$SUBL, 9) * 10 + ISNULL (A12.T$SUBL, 9) ASC) LINE_NUMBER, regards Allan Bulloch