FILE: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\Cartridges\sqlpdw.xsl
--
yes
[
]
'
'
Microsoft SQL Server Parallel Data Warehouse
Microsoft SQL Server 2008 R2 Parallel Data Warehouse
Datallegro
SQL Server 2012 Parallel Data Warehouse
32
32
Provider
Data Source
Server
Initial Catalog
Database
User ID
UID
Password
PWD
Integrated Security=SSPI
Trusted_Connection=yes
Microsoft.SqlServer.DataWarehouse
Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse
Microsoft.DataWarehouse.Controls.SqlClientQueryDesigner, Microsoft.DataWarehouse
System.Data.OleDb
Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse
Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse
System.Data.Odbc
Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse
auto
yes
yes
nosubsel
no
(
)
(
)
TOP ()
PERCENT
WITH TIES
(
SELECT
)
(SELECT
FROM DUAL
)
DISTINCT
AS
FROM
( on )
left outer join
right outer join
full outer join
inner join
Cross Join
(
)
cross apply
outer apply
GROUP BY
ORDER BY
WHERE
EXISTS ()
HAVING
null
primary key
(
)
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 0)
, (CASE WHEN IS NULL THEN 0 ELSE 1 END)
ASC
DESC
@
?
DATEPART( , )
year
quarter
month
dayofyear
day
week
weekday
hour
minute
second
millisecond
*
MIN
MAX
SUM
( )
COUNT ( )
STDEV
STDEVP
VAR
VARP
AVG
( )
((SELECT MIN()) UNION (SELECT MAX()))
(CASE WHEN COUNT_BIG(*) = COUNT_BIG() THEN ((SELECT MIN()) UNION (SELECT MAX())) ELSE ((SELECT MIN()) UNION (SELECT NULL)) END)
SUM(CASE WHEN () IS NULL THEN CAST(1 AS BIGINT) END)
SUM(CAST(1 AS BIGINT)) OVER ()
=
<>
>
= ]]>
<
<=
IN
AND
OR
+
-
/
*
(
)
LOWER()
UPPER()
LEN()
LTRIM()
RTRIM()
RTRIM(LTRIM())
>
<
<>
=
>=
<=
()
ISNULL(, '')
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 0)
()
ISNULL(, '')
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 0)
() = ()
() = () OR () IS NULL AND () IS NULL
(SELECT CASE WHEN Op1 = Op2 OR Op1 IS NULL AND Op2 IS NULL THEN 1 ELSE 0 END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() > ()
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() < ()
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() <= ()
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() >= ()
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END END) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() <> ()
(SELECT CASE WHEN Op2 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT CASE WHEN Op1 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
(SELECT CASE WHEN Op1 = Op2 OR (Op1 IS NULL AND Op2 IS NULL) THEN 1 ELSE 0 END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 0
''
CAST(-2 AS datetime)
0
''
CAST(-2 AS datetime)
0
() = ()
(SELECT CASE WHEN Op2 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT CASE WHEN Op1 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
(SELECT CASE WHEN Op1 = Op2 OR (Op1 IS NULL AND Op2 IS NULL) THEN 1 ELSE 0 END FROM (SELECT () AS Op1, () AS Op2) as AuxTable) = 1
() + ()
(SELECT ISNULL(AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1) FROM (SELECT AS Op1, AS Op2) as AuxTable)
(SELECT ISNULL(() + AuxTable.Op2, AuxTable.Op2) FROM (SELECT AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 + CAST(AuxTable.Op2 + 2 AS float) , AuxTable.Op1, AuxTable.Op2) FROM (SELECT AS Op1, () AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1, AuxTable.Op2) FROM (SELECT AS Op1, AS Op2) as AuxTable)
() - ()
(SELECT ISNULL(AuxTable.Op1 - AuxTable.Op2, AuxTable.Op1) FROM (SELECT AS Op1, AS Op2) as AuxTable)
(SELECT ISNULL(() - AuxTable.Op2, -AuxTable.Op2) FROM (SELECT AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 - AuxTable.Op2, AuxTable.Op1, -AuxTable.Op2) FROM (SELECT () AS Op1, AS Op2) as AuxTable)
() / ()
() / ISNULL(, 0)
() *
(
)
CAST(() * () AS money)
() * ()
(SELECT
CASE
WHEN AuxTable.Op1 IS NULL
THEN NULL
ELSE
CASE
WHEN AuxTable.Op2 IS NULL OR AuxTable.Op2 = 0
THEN AuxTable.Op3
ELSE
AuxTable.Op1 / AuxTable.Op2
END
END
FROM (SELECT
() AS Op1,
() AS Op2,
() AS Op3
) as AuxTable
)
OR
AND
() ()
ROUND((), ())
ROUND((), ISNULL((), 0))
ROUND((), (), 1)
ROUND((), ISNULL((), 0), 1)
(SELECT Op1 - Op2 * FLOOR(Op1 / Op2) FROM (SELECT () AS Op1, () AS Op2) AS AuxTable)
(SELECT Op1 - Op2 * FLOOR(Op1 / Op2) FROM (SELECT () AS Op1, ISNULL((), 0) AS Op2) AS AuxTable)
ROUND(() / (), 0, 1)
ROUND(() / ISNULL((), 0), 0, 1)
(LOG() / LOG())
(LOG() / LOG(ISNULL((), 0)))
(LOG(ISNULL((), 0)) / LOG())
(LOG(ISNULL((), 0)) / LOG(ISNULL((), 0)))
POWER((), ())
POWER((), ISNULL((), 0))
ISNULL((), ())
() % ()
(() / ())
(() / ISNULL((), 0))
(ISNULL((), 0) / ())
(ISNULL((), 0) / ISNULL((), 0))
Op1
(ISNULL(Op1, 0))
Op2
(ISNULL(Op2, 0))
(SELECT CASE WHEN < THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable)
Op1
(ISNULL(Op1, 0))
Op2
(ISNULL(Op2, 0))
(SELECT CASE WHEN > THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable)
NOT()
CAST((CASE WHEN () THEN 0 ELSE 1 END) AS BIT)
1 - ()
ISNULL(1 - (), 1)
-()
ABS
CEILING
FLOOR
SIGN
SQRT
SQUARE
()
EXP
LOG
LOG10
()
(ISNULL((), 0))
(CASE WHEN COUNT_BIG( ) = 0 THEN NULL ELSE COUNT_BIG( ) END)
(CASE WHEN (COUNT_BIG(DISTINCT ) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) = 0 THEN NULL
ELSE (COUNT_BIG(DISTINCT ) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) END)
(CASE WHEN COUNT_BIG(DISTINCT ) = 0 THEN NULL
ELSE COUNT_BIG(DISTINCT ) END)
()
ISNULL(, 0)
()
ISNULL(, 0)
()
ISNULL(, 0)
DATEADD(mm, ((SELECT CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END
FROM (SELECT AS Op1) as AuxTable) )*12 + - 1, 0) + ( - 1)
(SELECT COALESCE(AuxTable3.Op1 + AuxTable3.Op3, AuxTable3.Op1 - 1, AuxTable3.Op3 - 1)
FROM (SELECT COALESCE(DATEADD(MM, AuxTable2.Op1 + AuxTable2.Op2, 0), DATEADD(MM, AuxTable2.Op1 - 1, 0), DATEADD(MM, AuxTable2.Op2, 0)) AS Op1, AuxTable2.Op3 AS Op3
FROM (SELECT (CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END)*12 AS Op1, AuxTable.Op2 - 1 AS Op2, AuxTable.Op3 - 1 AS Op3
FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable) AS AuxTable2) AS AuxTable3)
DATEADD(ss, (*3600 + *60 + )%(3600*24), -2)
(SELECT DATEADD(ss, AuxTable2.Op1%(3600*24), -2)
FROM (SELECT COALESCE(AuxTable.Op1 + AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1 + AuxTable.Op3,
AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1, AuxTable.Op2, AuxTable.Op3) AS Op1
FROM (SELECT ()*3600 AS Op1, ()*60 AS Op2 , AS Op3) AS AuxTable) AS AuxTable2)
()
ISNULL(, CAST(-2 AS datetime))
()
ISNULL(, 0)
DATEADD(dd, -1, DATEADD(mm, DATEDIFF(m, 0, ) + 1 + , 0))
(SELECT DATEADD(dd, -1, DATEADD(mm, COALESCE(AuxTable.Op1 + 1 + AuxTable.Op2, AuxTable.Op1 + 1, AuxTable.Op2), 0))
FROM (SELECT DATEDIFF(m, 0, ) AS Op1, AS Op2) AS AuxTable)
(SELECT DATEADD(mm, AuxTable.Op2, AuxTable.Op1) FROM (SELECT DATEDIFF(dd, 0, ) AS Op1, AS Op2) AS AuxTable)
(SELECT COALESCE(DATEADD(mm, AuxTable.Op2, AuxTable.Op1), DATEADD(mm, AuxTable.Op2, CAST(-2 AS datetime)), DATEADD(mm, 0, AuxTable.Op1))
FROM (SELECT DATEDIFF(dd, 0, ) AS Op1, + 0 AS Op2) AS AuxTable)
()
ISNULL(, CAST(-2 AS datetime))
CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 1) % 7 + 1 AS bigint)
CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 2) % 7 + 1 AS bigint)
CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 2) % 7 AS bigint)
COALESCE
(
)
IS NULL
(
)
nvarchar
nvarchar
varchar
bit
tinyint
smallint
int
bigint
tinyint
smallint
int
bigint
real
float
datetime
datetime
decimal
varbinary
decimal
1=1
CAST(1 AS BIT)
1=0
CAST(0 AS BIT)
( )
(
, )
CAST( AS )
CAST(() + 2 AS float)
CAST(CASE WHEN THEN 1 ELSE 0 END AS float)
CAST( AS float)
(SELECT CAST(AuxTable.Op1 + CASE WHEN AuxTable.Op1 < 0 THEN -0.5 ELSE 0.5 END AS bigint)
FROM (SELECT CAST( AS float) + 2 AS Op1) as AuxTable)
(SELECT CAST(AuxTable.Op1 + CASE WHEN AuxTable.Op1 < 0 THEN -0.5 ELSE 0.5 END AS bigint)
FROM (SELECT AS Op1) as AuxTable)
CAST(CASE WHEN THEN 1 ELSE 0 END AS bigint)
CAST( as bigint)
CAST( AS money) + 2
CAST(CASE WHEN THEN 1 ELSE 0 END AS money)
CAST( AS money)
() <> CAST(-2 AS datetime)
CAST( AS bit) = 1
() <> 0
CAST(CAST( AS datetime) + 2 AS bit)
CAST(CASE WHEN THEN 1 ELSE 0 END AS bit)
CAST( AS bit)
CAST(CASE WHEN THEN 1 ELSE 0 END AS datetime) - 2
CAST( AS datetime) - 2
CAST( AS datetime)
CASE WHEN = 1 THEN N'TRUE' ELSE N'FALSE' END
CASE WHEN THEN N'TRUE' ELSE N'FALSE' END
CAST( AS nvarchar(max))
SQL90 cartridge error: OpCast: ResultType is not specified
CASE
END
WHEN ()
THEN ()
ELSE ()
RANK()
DENSE_RANK()
ROW_NUMBER()
NTILE()
OVER
(
)
PARTITION BY
CAST( AS bit)
CAST( AS datetime)
CAST( AS datetime)
CAST( AS decimal)
NULL
--