ORACLE KEEP FIRST to MS SQL [message #441851] |
Wed, 03 February 2010 06:50  |
abulloch
Messages: 1 Registered: February 2010 Location: South Africa
|
Junior Member |
|
|
Hi .
I am currently converting some Oracle SQL to MS Sql and have a problem with the following:
What / how can I replace the KEEP section :
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
|
|
|
|
Re: ORACLE KEEP FIRST to MS SQL [message #441898 is a reply to message #441851] |
Wed, 03 February 2010 14:09   |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
You will also find that there are MANY things that can be done in oracle that are not available in other databases. Just curious, why are you converting from a first class database to an inferior one.
|
|
|
|