> when the @iKundTjanstID > 1 then should the subquery not run

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:YdydnTSTxIcVUqncRVn-hA@giganews.com...
>A fragment of code like this doesn't give us much to go on. At a guess, I'd
> say that sUserID isn't unique in the table tblUsersMemberKundTjanster,
> which
> would explain the error message "Subquery returned more than 1 value". If
> you need more help: http://www.aspfaq.com/5006
>
> --
> David Portas
> SQL Server MVP
> --
>
>

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:2budncB0i9TDRqncRVn-iw@giganews.com...
>> when the @iKundTjanstID > 1 then should the subquery not run
>
> You can't rely on that. It depends on the execution order of the
> predicates,
> which you can't control. Try this:
>
> ...
> WHERE tblTjanster.iKundID = @iKundID
> AND tblTjanster.iHsID = @iHsID
> AND tblTjanster.btAvslutad = @btAvslutad
> AND (tblTjanster.iKundTjanstID IN
> (SELECT iKundTjanstID
> FROM tblUsersMemberKundTjanster
> WHERE sUserID = @sUserID
> AND @iKundTjanstID = 1)
> OR tblTjanster.iKundTjanstID = @iKundTjanstID)
> AND tblTjanster.blKasserad = 0
> AND tblTjanster.iUppehallID = 0
>
> --
> David Portas
> SQL Server MVP
> --
>
>