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 TouchToneTommy 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 rduncan10

  1. rduncan10

    How to use ADO SHAPE command with parameterized stored procedure

    Software: Microsoft Access 2000, SQL Server 2000 I’m trying to figure out how to bring data down from an SQL server into Access using an ADO SHAPE command against a stored procedure with up to 18 parameters. I played with this a bit in the Data Environment Designer. I came up with this SHAPE...
  2. rduncan10

    Copy DATETIME from one table to another

    Thanks. That's kind of embarassing. In my defense, the documentation I was using (O'Reilly MySQL pocket reference) showed brackets, though I now see the manual on MySQL.com does not. Rob
  3. rduncan10

    Copy DATETIME from one table to another

    I'm trying to copy a DATETIME field from one table to another using an INSERT statement like this: INSERT INTO table2 (value1, date1) SELECT (value1, date1) FROM table2; MySQL gives me this error: Error 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your...
  4. rduncan10

    Execute Stored Procedure in UPDATE statement

    I'm new to SQL Server and I am having some trouble with something that seems to me should be quite easy. I want to update a field to the return value of stored procedure. So the code looks sort of like this UPDATE table1 SET totHours = EXECUTE sp_calcHours @hours OUTPUT WHERE otHours > 16...
See more

Part and Inventory Search

Back
Top