Hi Marcia,

My apologies, I was thinking in LabKey SQL terms and not Microsoft SQL terms.

The "assay.General.myGenericAssay" schema is a virtual schema that our API and queries understand and work with.

A stored procedure would have to work with the actual table on the database itself. So a GPAT assay would look something like assayresult.c1761228512Genotyping_Original in the actual database. However, we really don't recommend going against the DB directly for these specific tables since this would require you to figure out what assay is tied to which specific container, which is difficult considering the special numeric sequence that is used in the table name.

If you're looking to transform the information that enters into an assay, in lieu of an ETL, you might want to consider using Transformation Scripts for the Assay instead (https://www.labkey.org/Documentation/wiki-page.view?name=programmaticQC).

Regards,

Jon