SANCHIT SHARMA
Active member
- Joined
- Jul 15, 2005
- Messages
- 38
- Programming Experience
- 10+
we are executing the following sql statement succesfully in MS Access
SELECT DISTINCT LS_ATTO.ATTODescription AS UserName, LS_ATTO.ATTOID AS UserId,
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
FROM LS_ATTO LEFT JOIN Passwd ON LS_ATTO.UserID = Passwd.UserID
WHERE (((LS_ATTO.LogicalDelete)=0 Or (LS_ATTO.LogicalDelete) Is Null))
ORDER BY 1;
The same when we are using to create view in SQL 2005 it shows error
at
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
is there any equvalent of IIF in SQL 2005 , pls help
Regards
SELECT DISTINCT LS_ATTO.ATTODescription AS UserName, LS_ATTO.ATTOID AS UserId,
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
FROM LS_ATTO LEFT JOIN Passwd ON LS_ATTO.UserID = Passwd.UserID
WHERE (((LS_ATTO.LogicalDelete)=0 Or (LS_ATTO.LogicalDelete) Is Null))
ORDER BY 1;
The same when we are using to create view in SQL 2005 it shows error
at
IIf(PASSWD.Supervisor=0,3,PASSWD.SUPERVISOR) AS Supervisor
is there any equvalent of IIF in SQL 2005 , pls help
Regards