William
Thu Nov 20 17:00:40 CST 2003
Yes, my "ugly" solution is explained in that article.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Mark" <anonymous@discussions.microsoft.com> wrote in message
news:02D970D7-93CB-49CD-865F-D2C1D0825693@microsoft.com...
> Hi Bill -
>
> As long as it doesn't require creation of tables/stored procedures, since
I don't want to give the ability for a general use to do that, I'll handle
the ugly way if need be. If you wouldn't mind sharing the other route
suggested, since I didn't locate any T-SQL information to go off of, I would
greatly appreciate it as I'll use that option. Is it referring to this link
below?
>
>
http://www.algonet.se/~sommar/dynamic_sql.html
>
> Thank you all for your knowledge.
>
> Mark
>
> ----- William (Bill) Vaughn wrote: -----
>
> Right. We've seen this before. Nope, you can't provide a Parameter to
an IN
> expression. It has to be present when the SP is created. There is a
> work-around, but it's ugly (using EXEC SQL).
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> MVP, hRD
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> __________________________________
>
> "Mark" <anonymous@discussions.microsoft.com> wrote in message
> news:3C0E3513-B84B-448F-AB25-365C95B99E04@microsoft.com...
> > Hello all -
> >> I've searched high and low to an answer to my question so I'm
posting here
> as my last option.
> >> I'm trying to use the IN keyword in my WHERE clause of the data
adapter to
> gather all IDs, separating them with commas, but I get an error that
states
> that it could not convert a varchar value (due to the potential comma
being
> there I needed to) to an int (which is what the ID field is defined
as).
> Does anybody know what I can do to get around this issue or is there
> something I'm doing wrong??
> >> Here's my query (@CustIDs can hold a value of 15, for example, or
> '15,16'):
> >> SELECT DISTINCT Customer.CustomerID, Customer.CompanyName,
Customer.City +
> ', ' + Customer.State AS CityState FROM Customer INNER JOIN
> ClientServicesTable INNER JOIN CompanyServicesTable ON
> ClientServicesTable.CompanyServiceID =
CompanyServicesTable.CompanyServiceID
> ON Customer.CustomerID = ClientServicesTable.ClientID WHERE
> (CompanyServicesTable.ServiceType = 'S' OR
CompanyServicesTable.ServiceType
> >> = 'B') AND (Customer.CustomerID = @ID OR Customer.CustomerID IN
> (@CustIDs)) ORDER BY Customer.CompanyName
> >> Much thanks!
> > Mark
>
>
>