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!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bnp1
  • Content: Threads
  • Order by date
  1. bnp1

    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...
  2. bnp1

    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...

Part and Inventory Search

Back
Top