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 Westi 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. 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...

Part and Inventory Search

Back
Top