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.
| Author |
Topic |
|
asad.lte
Starting Member
32 Posts |
 Posted - 2010-06-21 : 09:43:04
|
| hi experts,i am new to sqlserver i need ur support to convert a oracle query to sqlserver.ur support wud b appreciated as m learning.the query is thanx in advanceSELECT DISTINCT D.DEALERID, D.LENDERID, D.STATUS , L.LENDERNAME FROM -(SELECT DISTINCT DEALERID, LENDERID, STATUS FROM dbo.DEALERS_BY_LENDER) D, (SELECT LENDERID, LENDERNAME FROM dbo.LENDERLIST) L WHERE D.LENDERID = L.LENDERID(+) |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-21 : 09:59:45
|
| select DISTINCT D.DEALERID, D.LENDERID, D.STATUS FROM dbo.DEALERS_BY_LENDER D INNER JOIN dbo.LENDERLIST L ON D.LENDERID = L.LENDERIDLimitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
Devart
Posting Yak Master
102 Posts |
Posted - 2010-06-21 : 10:46:40
|
| You can try it:SELECT DISTINCT D.DEALERID, D.LENDERID, D.STATUS , L.LENDERNAMEFROM dbo.DEALERS_BY_LENDER D LEFT OUTER JOIN dbo.LENDERLIST L ON D.LENDERID = L.LENDERIDDevart, Tools for SQL Serverhttp://www.devart.com/dbforge/sql |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-06-21 : 13:19:34
|
"i am new to sqlserver i need ur support to convert a oracle query to sqlserver.ur support wud b appreciated as m learning.the query is thanx in advance"Text-speak is not permitted on this forum, please refrain from using it. Thank you  |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-06-22 : 02:48:32
|
quote:
Originally posted by KristenText-speak is not permitted on this forum, please refrain from using it. Thank you
I never came through such forum rule.I to have a habit of using it sometime.  Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
|
|
|
|
|
oracle to sql server convert