SELECT     Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_1 AS TD, Sample_MSec_1 AS SMS, BS3_Analog_Table_1.Sample_Value_1 AS VAL
FROM         BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_1 IS NULL)) AND (NOT (Sample_MSec_1 IS NULL)) AND (NOT (Sample_Value_1 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_2 AS TD, Sample_MSec_2 AS SMS, BS3_Analog_Table_1.Sample_Value_2 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_2 IS NULL)) AND (NOT (Sample_MSec_2 IS NULL)) AND (NOT (Sample_Value_2 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_3 AS TD, Sample_MSec_3 AS SMS, BS3_Analog_Table_1.Sample_Value_3 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_3 IS NULL)) AND (NOT (Sample_MSec_3 IS NULL)) AND (NOT (Sample_Value_3 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_4 AS TD, Sample_MSec_4 AS SMS, BS3_Analog_Table_1.Sample_Value_4 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_4 IS NULL)) AND (NOT (Sample_MSec_4 IS NULL)) AND (NOT (Sample_Value_4 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_5 AS TD, Sample_MSec_5 AS SMS, BS3_Analog_Table_1.Sample_Value_5 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_5 IS NULL)) AND (NOT (Sample_MSec_5 IS NULL)) AND (NOT (Sample_Value_5 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_6 AS TD, Sample_MSec_6 AS SMS, BS3_Analog_Table_1.Sample_Value_6 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_1 IS NULL)) AND (NOT (Sample_MSec_6 IS NULL)) AND (NOT (Sample_Value_6 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_7 AS TD, Sample_MSec_7 AS SMS, BS3_Analog_Table_1.Sample_Value_7 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_7 IS NULL)) AND (NOT (Sample_MSec_7 IS NULL)) AND (NOT (Sample_Value_7 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_8 AS TD, Sample_MSec_8 AS SMS, BS3_Analog_Table_1.Sample_Value_8 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_8 IS NULL)) AND (NOT (Sample_MSec_8 IS NULL)) AND (NOT (Sample_Value_8 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_9 AS TD, Sample_MSec_9 AS SMS, BS3_Analog_Table_1.Sample_Value_9 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_9 IS NULL)) AND (NOT (Sample_MSec_9 IS NULL)) AND (NOT (Sample_Value_9 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT    Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_10 AS TD, Sample_MSec_10 AS SMS, BS3_Analog_Table_1.Sample_Value_10 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_10 IS NULL)) AND (NOT (Sample_MSec_10 IS NULL)) AND (NOT (Sample_Value_10 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_11 AS TD, Sample_MSec_11 AS SMS, BS3_Analog_Table_1.Sample_Value_11 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_11 IS NULL)) AND (NOT (Sample_MSec_11 IS NULL)) AND (NOT (Sample_Value_11 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_12 AS TD, Sample_MSec_12 AS SMS, BS3_Analog_Table_1.Sample_Value_12 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_12 IS NULL)) AND (NOT (Sample_MSec_12 IS NULL)) AND (NOT (Sample_Value_12 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_13 AS TD, Sample_MSec_13 AS SMS, BS3_Analog_Table_1.Sample_Value_13 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_13 IS NULL)) AND (NOT (Sample_MSec_13 IS NULL)) AND (NOT (Sample_Value_13 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_14 AS TD, Sample_MSec_14 AS SMS, BS3_Analog_Table_1.Sample_Value_14 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_14 IS NULL)) AND (NOT (Sample_MSec_14 IS NULL)) AND (NOT (Sample_Value_14 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_15 AS TD, Sample_MSec_15 AS SMS, BS3_Analog_Table_1.Sample_Value_15 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_15 IS NULL)) AND (NOT (Sample_MSec_15 IS NULL)) AND (NOT (Sample_Value_15 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_16 AS TD, Sample_MSec_16 AS SMS, BS3_Analog_Table_1.Sample_Value_16 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_16 IS NULL)) AND (NOT (Sample_MSec_16 IS NULL)) AND (NOT (Sample_Value_16 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_17 AS TD, Sample_MSec_17 AS SMS, BS3_Analog_Table_1.Sample_Value_17 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_17 IS NULL)) AND (NOT (Sample_MSec_17 IS NULL)) AND (NOT (Sample_Value_17 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_18 AS TD, Sample_MSec_18 AS SMS, BS3_Analog_Table_1.Sample_Value_18 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_18 IS NULL)) AND (NOT (Sample_MSec_18 IS NULL)) AND (NOT (Sample_Value_18 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_19 AS TD, Sample_MSec_19 AS SMS, BS3_Analog_Table_1.Sample_Value_19 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_19 IS NULL)) AND (NOT (Sample_MSec_19 IS NULL)) AND (NOT (Sample_Value_19 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_20 AS TD, Sample_MSec_20 AS SMS, BS3_Analog_Table_1.Sample_Value_20 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_20 IS NULL)) AND (NOT (Sample_MSec_20 IS NULL)) AND (NOT (Sample_Value_20 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_21 AS TD, Sample_MSec_21 AS SMS, BS3_Analog_Table_1.Sample_Value_21 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_21 IS NULL)) AND (NOT (Sample_MSec_21 IS NULL)) AND (NOT (Sample_Value_21 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_22 AS TD, Sample_MSec_22 AS SMS, BS3_Analog_Table_1.Sample_Value_22 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_22 IS NULL)) AND (NOT (Sample_MSec_22 IS NULL)) AND (NOT (Sample_Value_22 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_23 AS TD, Sample_MSec_23 AS SMS, BS3_Analog_Table_1.Sample_Value_23 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_23 IS NULL)) AND (NOT (Sample_MSec_23 IS NULL)) AND (NOT (Sample_Value_23 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_24 AS TD, Sample_MSec_24 AS SMS, BS3_Analog_Table_1.Sample_Value_24 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_24 IS NULL)) AND (NOT (Sample_MSec_24 IS NULL)) AND (NOT (Sample_Value_24 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_25 AS TD, Sample_MSec_25 AS SMS, BS3_Analog_Table_1.Sample_Value_25 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_25 IS NULL)) AND (NOT (Sample_MSec_25 IS NULL)) AND (NOT (Sample_Value_25 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_26 AS TD, Sample_MSec_26 AS SMS, BS3_Analog_Table_1.Sample_Value_26 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_26 IS NULL)) AND (NOT (Sample_MSec_26 IS NULL)) AND (NOT (Sample_Value_26 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_27 AS TD, Sample_MSec_27 AS SMS, BS3_Analog_Table_1.Sample_Value_27 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_27 IS NULL)) AND (NOT (Sample_MSec_27 IS NULL)) AND (NOT (Sample_Value_27 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_28 AS TD, Sample_MSec_28 AS SMS, BS3_Analog_Table_1.Sample_Value_28 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_28 IS NULL)) AND (NOT (Sample_MSec_28 IS NULL)) AND (NOT (Sample_Value_28 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_29 AS TD, Sample_MSec_29 AS SMS, BS3_Analog_Table_1.Sample_Value_29 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_29 IS NULL)) AND (NOT (Sample_MSec_29 IS NULL)) AND (NOT (Sample_Value_29 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_30 AS TD, Sample_MSec_30 AS SMS, BS3_Analog_Table_1.Sample_Value_30 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_30 IS NULL)) AND (NOT (Sample_MSec_30 IS NULL)) AND (NOT (Sample_Value_30 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_31 AS TD, Sample_MSec_31 AS SMS, BS3_Analog_Table_1.Sample_Value_31 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_31 IS NULL)) AND (NOT (Sample_MSec_31 IS NULL)) AND (NOT (Sample_Value_31 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_32 AS TD, Sample_MSec_32 AS SMS, BS3_Analog_Table_1.Sample_Value_32 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_32 IS NULL)) AND (NOT (Sample_MSec_32 IS NULL)) AND (NOT (Sample_Value_32 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_33 AS TD, Sample_MSec_33 AS SMS, BS3_Analog_Table_1.Sample_Value_33 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_33 IS NULL)) AND (NOT (Sample_MSec_33 IS NULL)) AND (NOT (Sample_Value_33 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_34 AS TD, Sample_MSec_34 AS SMS, BS3_Analog_Table_1.Sample_Value_34 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_34 IS NULL)) AND (NOT (Sample_MSec_34 IS NULL)) AND (NOT (Sample_Value_34 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_35 AS TD, Sample_MSec_35 AS SMS, BS3_Analog_Table_1.Sample_Value_35 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_35 IS NULL)) AND (NOT (Sample_MSec_35 IS NULL)) AND (NOT (Sample_Value_35 IS NULL)) AND Signal_Index=1
UNION ALL
SELECT  Signal_Index AS SI, BS3_Analog_Table_1.Sample_TDate_36 AS TD, Sample_MSec_36 AS SMS, BS3_Analog_Table_1.Sample_Value_36 AS VAL
FROM                      BS3_Analog_Table_1
WHERE     (NOT (Sample_TDate_36 IS NULL)) AND (NOT (Sample_MSec_36 IS NULL)) AND (NOT (Sample_Value_36 IS NULL)) AND Signal_Index=1
ORDER BY SI, TD, SMS