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!

Search results for query: *

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

    update record using loop not working

    some one out there help me please i've written a simple loop whereby i've inserted 1 rec into a #temp table using store procedure. Using the same rec, i attempted to update the fields named col2, col3 but the record dont seems to update the records in #TEMP_AGE IS REC_TYPE is varchar...
  2. crystaljen

    does not work as function / procedure..why

    hi, when i run this sql statement using ORacle 8...it works but when i use the same statement in a function and procedure i encountered error PLS:00103... statement as below (select field_name1 from (select DISTINCT field_name1 , ROW_NUMBER() over (partition by fld2, fld3 order by...
  3. crystaljen

    what tangible benefit does Crystal Enterprise have over Crystal Info

    hi all, at present we are thinking of migrating to Crystal Enterprise currently we are using Crystal Info 7. I need to know the tangible benefits i'll get out of it for my migration writeup (but i don't get much idea what to write). currently our reports are posted to Web for general access...

Part and Inventory Search

Back
Top