Teradata - How to setup all client tools

Order is important... start by installing these, in the following order:

1. Teradata Shared ICU Libraries
2. Teradata GSSS
3. Teradata CLIv2
4. Teradata ODBC Driver
5. Teradata SQL Assistant
6. Java JRE 1.7+
7. Teradata Studio (java client, best)
8. Teradata Data Connector

EXCEL - Median calculation (conditional on range matching a value)

=MEDIAN(IF(AR:AR=AY14,AI:AI ))

=MEDIAN(
IF(
RANGE_WITH_DATA_TO_FILTER_BY = VALUE_TO_FILTER_WITH
, RANGE_WITH_NUMERIC_VALUES_TO_CALC_MEDIAN_FOR
)
)

TSQL - Raiserror for more immediate prints

RAISERROR ('Message', 0, 1) WITH NOWAIT;