|
|
||||||
|
|
||||||
Properties
| Property | Value |
| Name | Lookup AgeRangeAtTerm using AgeAtTerm |
| Description | Looks up values in a reference dataset by using exact matching. |
| Up Stream Components | |
| Down Stream Components | |
| ID | 1318 |
| Component Class ID | {27648839-180F-45E6-838D-AFF53DF682D2} |
| Contact Info | Lookup;Microsoft Corporation; Microsoft SqlServer v10; (C) Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;5 |
| Identification String | component "Lookup AgeRangeAtTerm using AgeAtTerm" (1318) |
| Is Default Locale | True |
| Pipeline Version | 0 |
| Uses Dispositions | True |
| Validate External Metadata | True |
| Version | 5 |
Connections
| Name | Connection Manager | Description |
OleDbConnection |
Custom Properties
| Name | Value |
CacheType |
0 |
ConnectionType |
0 |
DefaultCodePage |
1252 |
MaxMemoryUsage |
25 |
MaxMemoryUsage64 |
25 |
NoMatchBehavior |
1 |
NoMatchCachePercentage |
0 |
ParameterMap |
#857; |
ReferenceMetadataXml |
<referenceMetadata><referenceColumns><referenceColumn name="AgeAtTerm" dataType="DT_I2" length="0" precision="0" scale="0" codePage="0"/><referenceColumn name="AgeRangeAtTerm" dataType="DT_STR" length="7" precision="0" scale="0" codePage="1252"/></referenceColumns></referenceMetadata> |
SqlCommand |
SELECT CAST(0 AS smallint) AS AgeAtTerm, 'N/A' AS AgeRangeAtTerm UNION ALL SELECT CAST(1 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(2 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(3 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(4 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(5 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(6 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(7 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(8 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(9 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(10 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(11 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(12 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(13 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(14 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(15 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL SELECT CAST(16 AS smallint) AS AgeAtTerm, '16 - 17' AS AgeRangeAtTerm UNION ALL SELECT CAST(17 AS smallint) AS AgeAtTerm, '16 - 17' AS AgeRangeAtTerm UNION ALL SELECT CAST(18 AS smallint) AS AgeAtTerm, '18 - 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(19 AS smallint) AS AgeAtTerm, '18 - 19' AS AgeRangeAtTerm UNION ALL SELECT CAST(20 AS smallint) AS AgeAtTerm, '20 - 21' AS AgeRangeAtTerm UNION ALL SELECT CAST(21 AS smallint) AS AgeAtTerm, '20 - 21' AS AgeRangeAtTerm UNION ALL SELECT CAST(22 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL SELECT CAST(23 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL SELECT CAST(24 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL SELECT CAST(25 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(26 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(27 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(28 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(29 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL SELECT CAST(30 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(31 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(32 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(33 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(34 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(35 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(36 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(37 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(38 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(39 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(40 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(41 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(42 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(43 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(44 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(45 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(46 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(47 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(48 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(49 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(50 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(51 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(52 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(53 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(54 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(55 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(56 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(57 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(58 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(59 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(60 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(61 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(62 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(63 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(64 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(65 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(66 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(67 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(68 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(69 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(70 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(71 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(72 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(73 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(74 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(75 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(76 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(77 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(78 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(79 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(80 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(81 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(82 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(83 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(84 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(85 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(86 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(87 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(88 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(89 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(90 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(91 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(92 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(93 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(94 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(95 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(96 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(97 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(98 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(99 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(100 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(101 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(102 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(103 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(104 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(105 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(106 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(107 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(108 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(109 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(110 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(111 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(112 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(113 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(114 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(115 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(116 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(117 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(118 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(119 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL SELECT CAST(120 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm |
SqlCommandParam |
select * from (SELECT CAST(0 AS smallint) AS AgeAtTerm, 'N/A' AS AgeRangeAtTerm UNION ALL
SELECT CAST(1 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(2 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(3 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(4 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(5 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(6 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(7 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(8 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(9 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(10 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(11 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(12 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(13 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(14 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(15 AS smallint) AS AgeAtTerm, '< 16' AS AgeRangeAtTerm UNION ALL
SELECT CAST(16 AS smallint) AS AgeAtTerm, '16 - 17' AS AgeRangeAtTerm UNION ALL
SELECT CAST(17 AS smallint) AS AgeAtTerm, '16 - 17' AS AgeRangeAtTerm UNION ALL
SELECT CAST(18 AS smallint) AS AgeAtTerm, '18 - 19' AS AgeRangeAtTerm UNION ALL
SELECT CAST(19 AS smallint) AS AgeAtTerm, '18 - 19' AS AgeRangeAtTerm UNION ALL
SELECT CAST(20 AS smallint) AS AgeAtTerm, '20 - 21' AS AgeRangeAtTerm UNION ALL
SELECT CAST(21 AS smallint) AS AgeAtTerm, '20 - 21' AS AgeRangeAtTerm UNION ALL
SELECT CAST(22 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL
SELECT CAST(23 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL
SELECT CAST(24 AS smallint) AS AgeAtTerm, '22 - 24' AS AgeRangeAtTerm UNION ALL
SELECT CAST(25 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL
SELECT CAST(26 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL
SELECT CAST(27 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL
SELECT CAST(28 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL
SELECT CAST(29 AS smallint) AS AgeAtTerm, '25 - 29' AS AgeRangeAtTerm UNION ALL
SELECT CAST(30 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(31 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(32 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(33 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(34 AS smallint) AS AgeAtTerm, '30 - 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(35 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(36 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(37 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(38 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(39 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(40 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(41 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(42 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(43 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(44 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(45 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(46 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(47 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(48 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(49 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(50 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(51 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(52 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(53 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(54 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(55 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(56 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(57 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(58 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(59 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(60 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(61 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(62 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(63 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(64 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(65 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(66 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(67 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(68 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(69 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(70 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(71 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(72 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(73 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(74 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(75 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(76 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(77 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(78 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(79 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(80 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(81 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(82 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(83 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(84 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(85 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(86 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(87 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(88 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(89 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(90 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(91 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(92 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(93 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(94 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(95 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(96 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(97 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(98 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(99 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(100 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(101 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(102 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(103 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(104 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(105 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(106 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(107 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(108 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(109 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(110 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(111 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(112 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(113 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(114 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(115 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(116 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(117 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(118 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(119 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm UNION ALL
SELECT CAST(120 AS smallint) AS AgeAtTerm, '> 34' AS AgeRangeAtTerm) [refTable]
where [refTable].[AgeAtTerm] = ? |
Input Columns
| Name | ID | LineageID |
AgeAtTerm |
1342 |
857 |
AgeRangeAtTerm |
1339 |
1315 |
Output Columns
| Name | ID | LineageID |
ErrorCode |
1335 |
1335 |
ErrorColumn |
1336 |
1336 |
| Powered by BI Documenter |
