Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
harry123
Starting Member
13 Posts |
 Posted - 2011-08-15 : 11:01:10
|
| I have a query which contains OVER statement and i executed it in SQL server 2008. It was executed perfectly. But when i used it in SSIS(BIDS) in SQL command mode.Then it is showing error like "THE OVER statement IS NOT SUPPORTED". My SQL server version:Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor) Compatibility level: 100 and Visual Studio 2008(BIDS)Is there anything that i need to change?Any help would be highly appreciated. |
|
|
|
|
|
Query help