Author |
Topic |
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-05 : 03:54:41
|
I am not able to open that link I am getting GATEWAY TIMEOUT !Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-05 : 04:19:38
|
I downloaded it and is running!Cool...Look at this Books Online excerpt:USE AdventureWorks;GOSELECT SalesOrderID, ProductID, OrderQty ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg' ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count' ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min' ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'FROM Sales.SalesOrderDetail WHERE SalesOrderID IN(43659,43664);GO Peter LarssonHelsingborg, Sweden |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-05 : 04:20:10
|
yeah i've already installed it on a virtual pc.It installs OWC11 we still have SSMS...we also get the UPSERT or in T-SQL MERGE Statementalso this works:declare @i int = 5select @i++select @i_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-05 : 04:28:58
|
UPDATE now also supports TOP operator, as well as DELETE.Peter LarssonHelsingborg, Sweden |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-05 : 04:29:35
|
Time to create new forums for Katmai?Peter LarssonHelsingborg, Sweden |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-05 : 04:32:08
|
quote: Originally posted by Peso UPDATE now also supports TOP operator, as well as DELETE.Peter LarssonHelsingborg, Sweden
TOP in UPDATE/DELETE was supported by SQL 2005 as well, isn't it?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-06-05 : 04:36:11
|
Yes. See that now. Did that come with SP2?Peter LarssonHelsingborg, Sweden |
 |
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-06-05 : 05:00:03
|
I think it was part of SQL 2005, not an extension added in SP2. Not sure though ! Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
pootle_flump
1064 Posts |
Posted - 2007-06-05 : 08:03:40
|
quote: Originally posted by Peso I downloaded it and is running!Cool...Look at this Books Online excerpt:USE AdventureWorks;GOSELECT SalesOrderID, ProductID, OrderQty ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg' ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count' ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min' ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'FROM Sales.SalesOrderDetail WHERE SalesOrderID IN(43659,43664);GO Peter LarssonHelsingborg, Sweden
Lol - could have guessed that would be the first thing you'd check.Anyone know typical turn around from CTP to release? |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-05 : 08:20:53
|
my guess is late november 2k8_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
Kristen
Test
22859 Posts |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-05 : 09:49:11
|
<<which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!>>Does it apply for next version as well?MadhivananFailing to plan is Planning to fail |
 |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-05 : 09:49:55
|
quote: Originally posted by harsh_athalye I am not able to open that link I am getting GATEWAY TIMEOUT !Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
Slow internet connection? MadhivananFailing to plan is Planning to fail |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-05 : 09:55:58
|
supposedly they will be separated... we'll see if they really are..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-06-05 : 10:00:29
|
supposedly they ARE separated in SQL2005 ... you just need to sue a CTP to implement it! |
 |
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-06-05 : 10:02:03
|
quote: Originally posted by Peso I downloaded it and is running!Cool...Look at this Books Online excerpt:USE AdventureWorks;GOSELECT SalesOrderID, ProductID, OrderQty ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total' ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg' ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count' ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min' ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'FROM Sales.SalesOrderDetail WHERE SalesOrderID IN(43659,43664);GO Peter LarssonHelsingborg, Sweden
You can do that in SQL 2005 ...http://www.sqlteam.com/item.asp?ItemID=26943- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-06-05 : 10:15:31
|
quote: Originally posted by Kristen supposedly they ARE separated in SQL2005 ... you just need to sue a CTP to implement it! 
sue a CTP, huh? how exactly do you sue a CTP? _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
Kristen
Test
22859 Posts |
Posted - 2007-06-05 : 11:38:33
|
You'll be needing a Microsoft API for that ... Edit: The Microsoft Litigation API I expect ... |
 |
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-05 : 11:46:59
|
that API is useless. every method just pops up a EULA, no matter how many times you accept. elsasoft.org |
 |
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-05 : 11:57:56
|
quote: Originally posted by madhivanan <<which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!>>Does it apply for next version as well?MadhivananFailing to plan is Planning to fail
I think they have separated this in Katmai, I remember a vague mention about this at the MVP summit where they showed us a demo of some of these features.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
Next Page
|