Parallel Data Warehouse (PDW) pass variable to "TOP()" function
-
Montag, 4. Februar 2013 20:58
The code below works in SQL Server 2008 R2 but not in PDW. Can anyone assist please....
Declare @VAR2 bigint
set @VAR2 = 1
select top(@VAR2) * from PDW_POC.dbo.MyTable
Thanks!
Alle Antworten
-
Donnerstag, 7. Februar 2013 14:38Moderator Hi CBonilla,
SQL Server PDW has its own variant of SQL with extensions to support parallel processing. Some functions in the SMP SQL Server product have not been implemented in SQL Server PDW. Some of these were omitted because they are functions that do not translate well into a parallel environment. For example, the IDENTITY property is not supported as described in the ETL section. Please refer to: http://www.sqlservercentral.com/blogs/microsoft-business-intelligence-and-data-warehousing/2012/03/25/building-the-enterprise-dwbi-system-with-sql-server-pdw/
And please refer to Rick Byham's reply in the following link: http://social.msdn.microsoft.com/Forums/da-DK/transactsql/thread/e5493595-5a4d-4aac-9428-b3a9ef5f9c63
Thanks,
EileenEileen Zhao
TechNet Community Support
- Als Antwort markiert Eileen ZhaoMicrosoft Contingent Staff, Moderator Montag, 25. Februar 2013 01:57
.png)
.png)
