SourceCode/PROMS/SQL Data Tools/for Byron RO issue.sql
2023-05-09 18:21:47 +00:00

8 lines
354 B
SQL

----Get the VersionID for EOP Rev 3 +
--select * from vefn_GetVersionNames()
----On the next line Use The VersionID from EOP Rev 3
--select * from Associations where VersionID = 14
----Use the ROFSTID for the results
--Select * from ROFSTS where DTS IN(Select DTS From ROFSTs Where ROFSTID = 164)
----Get the RODBIDs for PROMS Data
--Select * from RODBs