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 Mike Lewis 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: MaryJaneDoane
  • Order by date
  1. MaryJaneDoane

    error when running openquery

    Thank you genomon for getting back to me so fast. I will take a look at bol.
  2. MaryJaneDoane

    error when running openquery

    I have a stored procedure that runs based on an open query. I am getting an error I can't resolve. Below is the code calling hte stored procedure. The stored procedure runs fine by it self. Any ideas. select * from openquery(ccbdata01, 'SET FMTONLY OFF exec OREO.dbo.usp_GenerateTmpPivot')...
  3. MaryJaneDoane

    insert from one table into another

    Hi I am creting a DTS package to update, append and delete records from one table to another. Everything is worknig except the append. I removed 10 records from the table I am updating. My append statement isn't inserting the 10 records. The table it copies into is a history table that has...
  4. MaryJaneDoane

    add a sub query in a view to count properties per borrower

    That worked perfected. Thank You so much.
  5. MaryJaneDoane

    add a sub query in a view to count properties per borrower

    Hi Everyone - I am trying to do a count of properties by account. I tried the following field1, field2, field3, (select count(prop_id) from loanrev..collat group by loanrev..collat.note_id)as numprops, field4, field5 It compiles with no errors, but when i try to select the view i get the...

Part and Inventory Search

Back
Top