Ray Abram

here is a version without the DECLARE, which LabVIEW's Database tool kit can execute using the "Conn Execute.vi" Here is how to use the query with LabVIEW's Database toolkit Here is the updated query SELECT RTRIM(ur.UUT_SERIAL_NUMBER) AS UUT_SERIAL_NUMBER, RTRIM(CONVERT(varchar(23), ur.START_DATE_TIME, 121)) AS START_DATE_TIME, RTRIM(ur.USER_LOGIN_NAME) AS USER_LOGIN_NAME, RTRIM(ur.STATION_ID) AS STATION_ID, RTRIM(ur.UUT_STATUS) AS UUT_STATUS, sr.ORDER_NUMBER, RTRIM(sr.STEP_GROUP) AS STEP_GROUP, RTRIM(sc.SEQUENCE_NAME) AS SEQUENCE_NAME, RTRIM(sr.STEP_NAME) AS STEP_NAME, RTRIM(pnl.COMP_OPERATOR) AS COMP_OPERATOR, RTRIM(sr.STEP_TYPE) AS STEP_TYPE, RTRIM(sr.STATUS) AS STATUS, RTRIM(pr.DATA) AS RESULT, CAST(pnl.LOW_LIMIT AS nvarchar(50)) AS LOW_LIMIT, CAST(pnl.HIGH_LIMIT AS nvarchar(50)) AS HIGH_LIMIT, sr.MODULE_TIME AS MODULE_TIME, RTRIM(sc.SEQUENCE_FILE_PATH) AS SEQUENCE_FILE_PATH, RTRIM(pnl.UNITS) AS UNITS, ur.EXECUTION_TIME AS EXECUTION_TIME, sr.ERROR_CODE AS ERROR_CODE, RTRIM(sr.ERROR_MESSAGE) AS ERROR_MESSAGE, ur.UUT_ERROR_CODE AS UUT_ERROR_CODE, RTRIM(ur.UUT_ERROR_MESSAGE) AS UUT_ERROR_MESSAGE FROM dbo.UUT_RESULT AS ur JOIN dbo.STEP_RESULT AS sr ON ur.ID = sr.UUT_RESULT JOIN dbo.STEP_SEQCALL AS sc ON sr.STEP_PARENT = sc.STEP_RESULT LEFT JOIN dbo.PROP_RESULT AS pr ON sr.ID = pr.STEP_RESULT LEFT JOIN dbo.PROP_NUMERICLIMIT AS pnl ON pnl.PROP_RESULT = pr.ID WHERE sr.UUT_RESULT = '%s' ORDER BY sr.ORDER_NUMBER;

I was unable to run the query in MSSQL... Copilot was able to rearrange a few things and resulted inn the following working query next step is to use the LabVIEW Database toolkit to execute the querry DECLARE @UGID nvarchar(50); SET @UGID = N'C0CFF9BF-A8A5-11F0-9E18-4CB04AE64A78'; SELECT RTRIM(ur.UUT_SERIAL_NUMBER) AS UUT_SERIAL_NUMBER, RTRIM(CONVERT(varchar(23), ur.START_DATE_TIME, 121)) AS START_DATE_TIME, -- ISO 8601 RTRIM(ur.USER_LOGIN_NAME) AS USER_LOGIN_NAME, RTRIM(ur.STATION_ID) AS STATION_ID, -- <-- moved to UUT_RESULT RTRIM(ur.UUT_STATUS) AS UUT_STATUS, sr.ORDER_NUMBER, -- keep numeric for sorting RTRIM(sr.STEP_GROUP) AS STEP_GROUP, RTRIM(sc.SEQUENCE_NAME) AS SEQUENCE_NAME, RTRIM(sr.STEP_NAME) AS STEP_NAME, RTRIM(pnl.COMP_OPERATOR) AS COMP_OPERATOR, RTRIM(sr.STEP_TYPE) AS STEP_TYPE, RTRIM(sr.STATUS) AS STATUS, RTRIM(pr.DATA) AS RESULT, CAST(pnl.LOW_LIMIT AS nvarchar(50)) AS LOW_LIMIT, CAST(pnl.HIGH_LIMIT AS nvarchar(50)) AS HIGH_LIMIT, sr.MODULE_TIME AS MODULE_TIME, RTRIM(sc.SEQUENCE_FILE_PATH) AS SEQUENCE_FILE_PATH, RTRIM(pnl.UNITS) AS UNITS, ur.EXECUTION_TIME AS EXECUTION_TIME, sr.ERROR_CODE AS ERROR_CODE, RTRIM(sr.ERROR_MESSAGE) AS ERROR_MESSAGE, ur.UUT_ERROR_CODE AS UUT_ERROR_CODE, RTRIM(ur.UUT_ERROR_MESSAGE) AS UUT_ERROR_MESSAGE FROM dbo.UUT_RESULT AS ur JOIN dbo.STEP_RESULT AS sr ON ur.ID = sr.UUT_RESULT JOIN dbo.STEP_SEQCALL AS sc ON sr.STEP_PARENT = sc.STEP_RESULT LEFT JOIN dbo.PROP_RESULT AS pr ON sr.ID = pr.STEP_RESULT LEFT JOIN dbo.PROP_NUMERICLIMIT AS pnl ON pnl.PROP_RESULT = pr.ID WHERE sr.UUT_RESULT = @UGID ORDER BY sr.ORDER_NUMBER;