Thanks stewart,

I understand most of your points except the below point

>build the table on the new filegroup

I have to do partition for existing table

and can you please suggest the...

Thanks stewart,

We are using the scheduleuserid in most of the cases in where clause and sometimes questionId along with that.

and currently we have only one file group .

please suggest.

Hi ,

I hope this code meets your requirement

declare @Temptable table(Rulesid bigint ,

functiontypeid bigint,

[name] nvarchar(100),

nickname nvarchar(100),

nametype nvarchar(100)

)

insert into @Temptable

select 1, 1, 'abc', 'a', null

union all

select 1 ,1, 'def', 'd', null

union all

select...

Hi Chris,

There are 7K records and has index on column AssessmentId and this is an single statement

Thanks Fritchey... I am glad to you for helping out me

Thanks Bhuvanesh... I am glad to you for helping out me

Thanks Todd Fifield

Thanks ,but i did not get what i expected.

Let me quote the problem once again

I have User table where there is pk UserId and fk ParentId which refers pk UserId...

Sorry ,I dont have privilage for doing that.

but i can say there are table variables and temporary tables

Thanks Powell... After reading and trying your suggestion i will get back to you..

Thanks prabhu and Lowell

hi Lowell,

you are exactly correct . i logged in windows aunthentication mode and executed the...

Hi Lowell,

I know this functions and...

Hi Friend,

Can you get me the other alternative not using trigger

Thanks a lot Jack,

can you give some examples on implementing my requirement through sqlcmd

or power shell

Then what shall i do.. No options at all?:hehe: