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.

 All Forums
 Site Related Forums
 The Yak Corral
 2008 CTP is out

Author  Topic 

jezemine
Master Smack Fu Yak Hacker

2886 Posts
Posted - 2007-06-04 : 21:22:11
It's hard to believe, but here it is:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

www.elsasoft.org

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 Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

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;
GO
SELECT 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 Larsson
Helsingborg, Sweden
Go to Top of Page

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 Statement
also this works:
declare @i int = 5
select @i++
select @i

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2007-06-05 : 04:29:35
Time to create new forums for Katmai?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

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 Larsson
Helsingborg, Sweden


TOP in UPDATE/DELETE was supported by SQL 2005 as well, isn't it?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

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 Larsson
Helsingborg, Sweden
Go to Top of Page

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 Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

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;
GO
SELECT 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 Larsson
Helsingborg, Sweden
Lol - could have guessed that would be the first thing you'd check.

Anyone know typical turn around from CTP to release?
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts
Posted - 2007-06-05 : 08:20:53
my guess is late november 2k8

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

Kristen
Test

22859 Posts
Posted - 2007-06-05 : 08:27:09
SQL 2005 was First slated for a 2003 release date

First post in the Yukon folder = 11/03/2003 : 16:15:45

which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!

Kristen
Go to Top of Page

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?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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 Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Slow internet connection?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

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!
Go to Top of Page

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;
GO
SELECT 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 Larsson
Helsingborg, Sweden


You can do that in SQL 2005 ...
http://www.sqlteam.com/item.asp?ItemID=26943

- Jeff
http://weblogs.sqlteam.com/JeffS
Go to Top of Page

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 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

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 ...
Go to Top of Page

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
Go to Top of Page

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?

Madhivanan

Failing 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/
Go to Top of Page
    Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site