Search results for query: *

... Because it is a propritary ID that needs to be in the format normally given by the application itself, or other things will break. Internally (The app) when it creates IDs for the table it bumps a value in their Keys table for the given TableName. This is what I am having a problem doing...

...I would create it as a function but it modifies a Keys table, and functions will not allow for that (Unless there is a way around that?)

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

SwampBoggie/All, I'm trying to go with your solution but I hid some of the underlying SQL to simplify it and can't seem to get it to fully work. First of all I know the data structure is not optimal (If only you knew how far that rabbit hole goes) but this is an inherited project that already...

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