Some useful links to you.

http://msdn.microsoft.com/en-us/library/aa905208(SQL.80).aspx

http://www.sqldba.org/articles/17-SQL-DBO-SQL-Server-Database-Object-Owner-dbo.aspx

Please read more on this URL.

One more Alternate way.

select c.ID

,name1=min(case when c.SUB=e.ms1 then c.Name end)

,name2=isnull(min(case when c.SUB=e.ms2 then c.Name end),'')

from Client_Table c

join (

select a.ID, ms1=min(a.ms1), ms2=min(b.SUB)

from (

...

Sudheer,

An Alternate way here.

select ID, firstone = MIN(SUB)

into #t

from Client_Table

where Status = 'Active'

group by ID

go

create unique clustered index idx1 on #t (ID, firstone)

go

select ID, secondone = MIN(SUB)

into #q

from Client_Table a

where...

Heh... OP gave you a perfectly good test table... you should use it to test your code!

Server: Msg 1033, Level 15, State 1, Procedure PrintReverse, Line 18The ORDER...

I have asked my manager to arrange a training,But they are not ready to arrange. Simply he is saying' "Just download the documents from website and read that and do...

sybase,oracle,mysql etc.,

karthikeyan (8/13/2008)

--------------------------------------------------------------------------------

SQLGuru,

Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes), uniquefier (since it is non-unique - 4 bytes). So 16 bytes for CI

non-clustered...

SQLGuru,

Clustered index: order_id (assume int - 4 bytes), order_date (assume datetime - 8 bytes), uniquefier (since it is non-unique - 4 bytes). So 16 bytes for CI

non-clustered PK...

what do you mean by CI pointer ? Can anybody explain it ?

Can you Post the same table and data ?

Can you Post the complete query ?

Hey,

Try this code.

Create table #name

(

Name varchar(5),

Value int null

)

go

insert into #name (Name)

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union all

select 'ABC'

union...

Hey Trevor,

I have tested the below script, It is giving perfect result.

create table #t1

(

ID int,

Used int

)

go

insert into #t1

select 1,2

union

select 2,10

union

select 3,11

union

select 4, 1

union

select 5,8

select TOP 3 ID,Used

from #t1

order by...

Umm...TenCent and SSC Veteran is not the names.:P

Hey Trevor My name is not 'TenCent'.:D

Post the code here which you have executed.