Diff between rank & desnse_rank()

Hi ,
Just confused between the Yukon ranking functions
rank & dense_rank
Thanks
ARR
Say you have following
Anderson
Anderson
Smith
Xing
Rank over these will give you 1, 1, 3, 4
Dense_rank will give you 1,1,2,3
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aju" <ajuonline@.yahoo.com> wrote in message news:%23bE3v$$FFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> Just confused between the Yukon ranking functions
> rank & dense_rank
> Thanks
> ARR
>

Diff between rank & desnse_rank()

Hi ,
Just confused between the Yukon ranking functions
rank & dense_rank
Thanks
ARRSay you have following
Anderson
Anderson
Smith
Xing
Rank over these will give you 1, 1, 3, 4
Dense_rank will give you 1,1,2,3
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aju" <ajuonline@.yahoo.com> wrote in message news:%23bE3v$$FFHA.3928@.TK2MSFTNGP15.phx.gbl...

> Hi ,
> Just confused between the Yukon ranking functions
> rank & dense_rank
> Thanks
> ARR
>

Diff between rank & desnse_rank()

Hi ,
Just confused between the Yukon ranking functions
rank & dense_rank
Thanks
ARRSay you have following
Anderson
Anderson
Smith
Xing
Rank over these will give you 1, 1, 3, 4
Dense_rank will give you 1,1,2,3
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aju" <ajuonline@.yahoo.com> wrote in message news:%23bE3v$$FFHA.3928@.TK2MSFTNGP15.phx.gbl...
> Hi ,
> Just confused between the Yukon ranking functions
> rank & dense_rank
> Thanks
> ARR
>

Diagram in Yukon

Where can I find the diagram in SQL Server 2005? I installed the beta 2 version but i cannot find the diagram. Another thing is: how can i embed .net codes inside stored procedure or SQL Server 2005?

Thanks
Lou BelaroBeta 2 is very old and does not contain the database diagram tool. It is, however, in the most recent version of SQL Server 2005 (June CTP), which you can get from http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/ctp.mspx.

To use .NET code inside stored procedures, functions, triggers, etc. you need to create an assembly in SQL Server. Please see the following topics in SQL Server Books Online for additional information.

CREATE ASSEMBLY
Creating CLR Stored Procedures
CLR Programmability Samples|||I'll replace my current version.

Thanks alot,
Lou