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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kolla123

  1. kolla123

    Help me with the procedure

    I have a stored proceduer in SQL Server 2000. It does the following things, 1) Get All the withdrawl Dates on some business Logic. 2) Get all the clients with the the withdrawl dates in step1. This procedures uses temp tables. I have to write the same procedure in oracle without using the temp...
  2. kolla123

    Problem identifying USB

    Hi, Recently I have installed Win2000 Professional. I have a problem with USB. My system is not able to detect USB (SiS 7001 PCI to USB). I deleted this device and reinstalled it again. It works fine. But when I restart the computer, it failes to detect the USB. Again I have to reinstall it...
  3. kolla123

    Calling Stored Procedure which has temp table

    I am calling a stored procedure from VB using OLEDB. The stored procedure is getting some data from 4 tables and inserting into a #tmp table. After that it is doing some processing on the data in the #tmp table. Last statement in the stored procedure is select * from #tmp. When I call this...
  4. kolla123

    SQL Statement without Cursor

    Could some please help me to write a SQL statememt to run a user defined stored procedure for each row in a table. I don't want to use cursor. Thanks, kolla123
  5. kolla123

    How to Write SQL Statement???

    Hi, I have a table like this. ClientID Code Amount 10 UTIL $20 10 RENT $40 20 UTIL $60 10 EXPENSE $40 ..... ..... I have to write an SQL statement to get all clientids on Rows and Codes on columns For Examp...
See more

Part and Inventory Search

Back
Top