"Magy" <kixman@excite.com> wrote in message
news:OIKgvJJEEHA.1544@TK2MSFTNGP09.phx.gbl...
> I need some help with a case expression. I need to interpert the following
> statements into a case expression. The statements are from Access and I'm
> trying to do the same in a SQL stored proc.
> @cboagTypeGroup And @cboagType will be the parameters passed to my
> procedure. Normally they would represent controls on a form, but I
replaced
> them with the variable names to be more clear.
>
>
> IIf(@cboagTypeGroup & ""="*" And cboagType & ""="*",1,
>
> IIf(@cboagType] & ""<>"*",
>
> IIf([pkAgreementTypeID] & ""=@cboagType & "",1,0),
>
> IIf([fkAgreementGroupTypeID] & ""=cboagTypeGroup & "",1,0)))
>
>
> This what I came up with but it does not work like I would like it to:
>
> Field2 = case when @cboagTypeGroup = '*' AND @cboagType = '*' then 1 else
> case when @cboagType <> '*' then
> case pkAgreementTypeID when @cboagType then 1 else
> case fkAgreementGroupTypeID when @cboagTypeGroup then 1 else 0
> end end end end
>
> I really need help to accomplish this.
>
> Thank you sincerly,
> Magy
>
>