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

    Join Query Issue

    I have 2 tables in my database. Table A ProjectWeek Employee AllocationHours AllocationCost 1 Ian 2 222 1 Bob 3 333 1 Steve 1 111 2 Ian 9 999 Table B ProjectWeek Employee TimesheetHours...
  2. igrummett

    Stored Proc Auto Increment

    I have a stored proc that inserts data into the resource table. The key to the table is resource_id. The stored proc is set up to pass all but the resource_id as this is automatically generated. Initially I had a problem where the auto increment was not working as it could not set the...
  3. igrummett

    Conditional Stored Proc

    Hi, I am new to stored procedures and need some help is defining an SP where 3 variables are passed to a SP and a derived value is passed back. The table name is Resource_Auth with the following attributes:- Resource ID password resource_Active...

Part and Inventory Search

Back
Top