Hi Marcia,
Have you reviewed our docs on stored procedures with regard to the ETL?
https://www.labkey.org/Documentation/wiki-page.view?name=etlsproc
https://www.labkey.org/Documentation/wiki-page.view?name=etlStoredProcMSSQL
https://www.labkey.org/Documentation/wiki-page.view?name=etlstoredproccheck
If you are asking about how to tell the stored procedure to work with the specific assay, you would need to specific the entire assay schema.
For example, if you created a GPAT assay called "myGenericAssay", the Schema Browser would allow you to access the assay schema structure as:
Assay > General > myGenericAssay
This is also shown as:
"assay.General.myGenericAssay"
So for the stored procedure example we have in our documentation that appears like this, where "schemaName" represents the schema:
CREATE procedure [schemaName].[queryName]
You would use "assay.General.myGenericAssay" as the schema name. Below starts out creating the stored procedure for the Assay Data (aka Assay Results) table for the "assay.General.myGenericAssay" schema:
CREATE procedure [assay.General.myGenericAssay].[Data]
Regards,
Jon