File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes equivalent query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "equivalent query" Watch "equivalent query" New topic
Author

equivalent query

Anandh Ramesh
Ranch Hand

Joined: Dec 15, 2004
Posts: 61
hi all,

i have to write a sql server query equivalent to the query given below. i am totally stuck at what to do... can someone help me out???, esp with that iif?
[ March 11, 2005: Message edited by: Anandh Ramesh ]

cheers,<br />Anandh
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

That's a very ugly query. But as far as I am aware, that is in a syntax SQL Server will understand. Someone may correct me, but IIF will only work on SQL Server.

Perhaps you can describe "Maintable" and what you are trying to select from it, then maybe someone can offer a suggestion of a better wayt of doing it.
[ March 01, 2005: Message edited by: Paul Sturrock ]

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: equivalent query
 
Similar Threads
EJB QL
assigment order and post increment
How to iterate a Set (2 steps once)
A little SQL help with SUM()
migrating code from hibernate 2 to hibernate 3.0