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

    SELECT @StoredProc, NextField1, NextField2 FROM ....

    I have a proprietary application that generates its own IDs internally. I have replicated the logic in a Stored Procedure. If I issue: EXEC MyNewID @TableName = 'Account' I get the ID correctly back. I now need to impliment this in an INSERT INTO .... I'm only trying to select the records...
  2. KPoggensee

    Max of multiple columns

    Say I have a SQL statement something like: Select Max(Col1), Max(Col2), Max(Col3) From Table1 The results are; Col1 Col2 Col3 3 8 5 I would like to return the Max of these columns so the only return is 8. Any Suggestions? Ken

Part and Inventory Search

Back
Top