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

    Join Query Issue

    Hi, Thanks for the feedback. I have tried this SQL and it almost works. The only problem is that it does not bring back and results for Derek in week 3 who only has an entry on Table B. Any further ideas would be great.
  2. 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...
  3. igrummett

    Stored Proc Auto Increment

    Hi - I have managed to solve this so thanks for your help.
  4. igrummett

    Stored Proc Auto Increment

    Hi, if I run the following query:- Yes the insert and select are separate stored procs. The insert appears to work OK. If i run the following SQL : SELECT resource.* FROM resource I get the following results: - Resource_id EntityID Name Email 1 1...
  5. 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...
  6. igrummett

    Conditional Stored Proc

    Thats great - thanks I will give it a go.
  7. 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