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!

  • 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. IronIke

    Pulling multiple rows of a table into one row

    Hi, I am having trouble figuring out how to retrieve the data I need from a SQL Server 2000 database. My table looks like the following: RecId Int, EmpID Int, StartDate datetime, Description varchar(30) There may be multiple records with the same EmpId. What I want to do is retrieve the...
  2. IronIke

    SQLServer 2000 and ADO Lock Types

    Terry, 1) Yes. The user does have update permissions. 2) I believe the answer is no to this one on both databases. I forgot to note that if the query is changed to the following: "Select * from table1", the recordset.locktype on the production system comes back as...
  3. IronIke

    SQLServer 2000 and ADO Lock Types

    I am developing a Visual Basic program that accesses a SQL2000 database. One of my queries is as follows: "Select * from table1 where id = " & n where n is selected by the user. When I open the recordset on my local system using ADO, the recorset.locktype comes back as...
  4. IronIke

    Insert Into error

    I have a stored procedure that I want to make a copy of a row in a table, except to change the key field and a couple of others. Here is what I have so far: Create Procedure procCreateAndCopy @smpId as int @smpNewId as int As Select * Into #tmpSample From Sample Where smpId = @smpId...
  5. IronIke

    Reporting off of FoxPro tables

    I have a Visual FoxPro application with several tables. These tables are created within the FoxPro application from other data sources, and will disappear when the FoxPro application terminates. I would like to use Crystal to report off of these FoxPro tables. Is there any way to use these...
  6. IronIke

    Result sets with nested stored procedures

    Is there a way, in SQL 7, to build a result set using calls to a stored procedure? I have a stored procedure that returns a result set using a Select statement based on input paramters. I want to have the calling stored procedure return a result set using data from multiple calls to the first...
  7. IronIke

    visual basic5 version of instr()

    What was the typo? It sounds interesting the Acess 2000 would accept it and Access 97 would not.
  8. IronIke

    Please, help me me with this SELECT statement!!!

    It looks like you might be missing a , after HumanRes.WeekHours. _ "HumanRes.LostTime, HumanRes.WeekHours " & _ "ModuleTime.ModulesCount AS Mod_Qty, " & _
  9. IronIke

    Saving window size in Enterprise Mgr on Windows 20000

    Windows in Enterprise Manager (SQL 7 and SQL 2000) forget their size on Windows 2000. This is especially irritating when editing stored procedures because the Ok button is off the screen and I have to resize and move the window to save. This is not a problem with Windows NT. Is there some...
  10. IronIke

    SQL Server 7 on Windows 2K?

    Yeah, it happens on SQL 2000 also.

Part and Inventory Search

Back
Top