how can choose more than one parameter in one parameter
ejemp
id name
1 a
2 b
3 c
4 e
I would like can choice 1 and 3 and 4 and same time.
thanksThere is not a good way to do it with the default interface. (I think it's
coming with SQL 2005, though.)
Possible workarounds are:
* Build a custom user interface. See the samples that come with the
product.
* Have a text box and allow free-form entry (comma-separated). This is a
difficult one for users to get right, and works best when your input options
are integers.
With either of these, your SQL might be structured like so:
WHERE FieldName IN @.Parm
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"alf" <em_alf@.hotmail.com> wrote in message
news:ublOnDeHFHA.2744@.tk2msftngp13.phx.gbl...
> how can choose more than one parameter in one parameter
> ejemp
> id name
> 1 a
> 2 b
> 3 c
> 4 e
> I would like can choice 1 and 3 and 4 and same time.
> thanks
>
No comments:
Post a Comment