Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Building a a List for IN predicate of a query in a Stored Procedure
OK Once I pass the String in to the SP how do I create the IN predicate within the query since it is expecting a list of INTegers? So if I passed '123,222,333' in how can I get th evalues into the query: select * from tablex where id in (xxx) -
Building a a List for IN predicate of a query in a Stored Procedure
I want to pass a number of Integers into a Stored Procedure that I can use in a query of the stored procedure. I am trying to figure out the best way to do this. The Query is something like this: Select * from xtable where id in (IDList) I want to be able to pass 1-x ID's into the Stored... -
DB2 Combine Columns from same table
Hello. I have this query: select distinct a.callid, case when a.appsequencenbr = 1 then char(a.appid) else ' ' end as appid1, case when a.appsequencenbr = 2 then char(a.appid) else ' ' end as appid2, case when a.appsequencenbr = 3 then char(a.appid) else ' ' end as appid3, case when...
