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 John Tel 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 MaryJaneDoane

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

Part and Inventory Search

Back
Top