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 IamaSherpa 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: *

  1. robfromuk

    reported to have a DBTYPE of 130 at compile time and 5 at run time

    ... hmm not sure how to edit my post there. Tried setting NULL and NOT NULL ... same thing either way.
  2. robfromuk

    SQL Server Linked Server + Query using existing recordset

    Much appreciated James! I have another problem now (http://www.tek-tips.com/viewthread.cfm?qid=1069729&page=1) but at least this one is out of the way! Thank you again.
  3. robfromuk

    reported to have a DBTYPE of 130 at compile time and 5 at run time

    I've researched this thoroughly and just can't find the answer. I'm trying to execute the following linked server query: ______________________________ INSERT EditReportReal(pid, seq, action_date, clientno) SELECT t2.pid, t2.seq, t2.action_date, t2.clientno FROM EditReportWorking t1 JOIN...
  4. robfromuk

    SQL Server Linked Server + Query using existing recordset

    Environment: SQL Server 2000, Linked server setup to an Oracle 9i DB. I have a results set in SQL Server. It has a column called pid. pid has many more entries in the Oracle DB (also in a column called pid), spanning across many dates. The one I have in SQL Server is just one of those...
  5. robfromuk

    SQL - split a result, add a character then rejoin

    Hi folks, I have a complex query which I need to split, add a character in the middle, then rejoin. Here is an example: SELECT DISTINCT ROB.CLIENTNO FROM ROB, CLIENTINFO CL, ITFOLDERS IT, XWALK X WHERE (ROB.CLIENTNO NOT LIKE '6%') AND (ROB.CLIENTNO LIKE...
  6. robfromuk

    Crystal Reports in a Microsoft SQL Server environment

    Hi Etienne, many thanks for replying. I'm wondering if there's anything from a technical point of view, either on the Crystal side or SQL Server that I would need to be aware of (that is worthy of note). For example caching of the data if you save the report outside of the sql server...
  7. robfromuk

    Combining Projects into 1 project file, assigning permissions

    Hello, Version: Microsoft office 2000 (not server, just standalone) I currently have 5 project files for 5 projects. In these 5 projects I have 3 resources who are my programmers. I wish to: a) combine the project files into 1 file b) assign the projects such that the programmers may only...

Part and Inventory Search

Back
Top