Really very thanks for all, i will work on it to increase the performance.

thanks alot.

hi all

this is my small part if code, i dont know which cursor taking more time to consolidate the data.

USE [databasename]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--Below...

http://msdn.microsoft.com/en-us/library/ms859415

here only i encountered the word..

thanks

Selva

in the context of memory track in server..

thanks

selva

thanks jeff your suggestion and ur answer helped me alot jeff.

thanks alot

sure jeff

thanks!!!

thanks alot:-):-)

dear Jeff

i dont know how to use books online effectively,so ly i am keep on asking simple question in this forum.

thanks...

hi lynn,

left outer join - take all values from left table and match with right table, if value not match with right table that row comes...

thanks alot

finally i attached mdf and ldf using sp_attach_db procedure.

i have only MDF and LDF files.

den how to etimate which one is best ?:-P