Viewing 7 posts - 1 through 7 (of 7 total)
Here you go
select ID,Model,
(select (count(client) +1 )* -1 as cnt
from table1 i where i.Model = o.Model and i.ID < o.ID ) 'client'
from table1 o
July 7, 2010 at 10:32 am
stewartc-708166 (7/7/2010)
dependencies may include:
> type of database (e.g. SQL Server, Oracle, DB2, Informix)
> version(s) of database(s)
> architecture (x86, x64, IA64)
> processing power
> RAM
>...
July 7, 2010 at 9:22 am
How did you arrive at the number of 325?
Lets consider a 4 column table for this example now.
Foll are the possibilities (64 in all).Now whats the math formula...
July 6, 2010 at 11:35 am
GilaMonster (7/3/2010)
Jeff Moden (7/3/2010)
What does affect non-clustered indexes is whether or not a clustered index exists.
And even then it just affects the internal structure of the index, not how...
July 3, 2010 at 12:16 pm
Well, what about the property of the column to be used as such?
The emphasis is that - The table does not have primary key column. Does that fact affect...
July 3, 2010 at 11:25 am
Viewing 7 posts - 1 through 7 (of 7 total)