sp_columns <tablename>

simple follow this query :

select newno into #t3 from #t2,#t1 where #t2.oldNo =#t1.oldNo

here t1,t2 are yr table

oldno ,newno r column names of t2

t3 is new table created as...

there is no datatype

you need to create a function

Hi sivaji,

try this :

select *, case countvalue when 0 then 0 else floor(((countvalue*1.0)/(answer*1.0))*100) end from @counttable order by countID

let me know result

kunal.

thanks yaar

its great.

thanks a lot

sorry yaar but need little more help.

i just copied and pasted your script in my query window and changed my database name with 'YourDatabaseName'

i got following error :

Msg 102, Level...

there is no 'sys.dm_db_index_physical_stats' sp in my database. its in master only.

i have passed DB_ID of my local database.

is there any other way to run it in my database...

thanks for yr query.

i execute query i got :

spt_values1451152215spt_valuesclust 110050

spt_values1451152215ix2_spt_values_nu_nc200080

its only 2 rows and spt_values is not my table. i have many indexes...

thanks yaar

I have noticed that backup size is increasing at 23.

I think there may be some scheduled task running over there.

Hi,

can you tell me what are the data type of filed ?

and check logical fragmentation of index. it should be less then 20.

I am not an expert but trying...

pls

i have already created function and then i altered it

thanks for reply,

as far as I know that, Join is much faster then IN.

i am sorry but i can't understand what you mean by saying :

'Also your first predicate is...