This is very Dinamick Pivot Cration... AND might not be very optimized... Your comments and sugestions are Welcome...

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

IF exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_Pivot]') and OBJECTPROPERTY(id, N'IsUserTable')...

Colunm are a,b,c, etc... i don't know how many Keys there are, they might change over time...

Values are x,y,z,xx,yy,zz... etc there are strings... becouse of keys varieaty...

i do not need...

Pivot Table is Index on id witch is PK with Clustering...

I might add more index later...

Well Becouse this table is Write only Once, No Modifications, i can do Selects with(NoLock)...

Further,...

Hmmm... Let me Just Explaine Little more about stracture,

i am running SQL2K Standart...

Table1

id -idedntity/autoincrement - PK - Clustered

Table2

aaa - idedntity/autoincrement - PK - clustered

idFK - FK - not clustered index...

usualy...

Well i was hoping for more solid answere then that...

i don't want to test it on real DB and kind of hard to test

this on smaller DB....