File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

equivalent query

 
Anandh Ramesh
Ranch Hand
Posts: 61
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic