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: RickyC1
  • Content: Threads
  • Order by date
  1. RickyC1

    Need help with OpenXML in SQL

    Getting only one record back from OpenXML... Why???? When I run Select XMLString From CAPSProgram I get my expected results.. Expecting to get 250 below is the code from QA: EXEC sp_xml_concat @hdl OUT,'(Select XMLString From CAPSProgram)a','XMLString' SELECT x.* FROM OPENXML (@hdl...
    • RickyC1
    • Thread
    • Replies: 0
    • Forum: XML
  2. RickyC1

    Need help with SQL select

    All, Have an account balance table with fiscal year and period. Need to create a trail balance file from this table. All I have to do is add all debits then all credits for the account from the beginning of time to the specified month, there is the problem. Cause the there is a (fiscal...
  3. RickyC1

    Not srue what to do next?

    All, Have several 8.5 reports that are driven from a VB 6 app and shown through the cr viewer control. I need to webify the reports so we can see them over our intranet. Just installed crystal 10 and Enterprise embedded. My question what do I do now? Do I create a web page and use the viewer...
  4. RickyC1

    I would like to query to see if a record already exists

    I have a screen which saves the content of the screen to a table. I would like to put in some functionality before the record is appended to see if it already exists. Any ideas?

Part and Inventory Search

Back
Top