Need to query an SP to determine its version number
Posted on 2014-07-16
I have a StoredProc which returns data to a sheet in an Excel file in a library on a Sharepoint.
I would like some method for the Excel file to determine if it is running the latest version of the StoredProc, the purpose of this is for when a user downloads a copy of the StoredProc to their local machine, so it may be the case that at some time they may not be using the latest version of the file since they are not accessing it from the Sharepoint.
As a side note: When changes are made to the StoredProc (eg; if a column is added in the middle of the existing columns), for some reason the column is added at the end of the returned Excel table as opposed to where the StoredProc advises where it should be.
If I remove the query and re-add it to the Excel, then the correct column order is preserved.
Anyway, I need the StoredProc to be updated in some way that when it executes with a certain flag/parameter set (eg; @VerInfo) then it returns a line of text advising the Version Info of the StoredProc.
Just not too sure of the best method to do this or whether you guys have some better suggestions.