I am not getting you.

Yes, I am using 2000 only.

I will check it and come back to you.

Thanks a lot for your prompt reply.

Ok.

Can you tell me what could be the reason for the error message ?

select datepart(dd,columnname) +'-'+datepart(mm,columnname) +'-'+datepart(yy,columnname)

Check it out.

Sergiy,

I may be wrong because of my urgent need. I hope you can understand my code now.

create procedure Message_Insert

(

@START_TIME datetime,

@END_TIME varchar(100),

@ERROR_MSG text

)

as

Begin

Insert into LOG_TABLE (START_TIME,END_TIME,ERROR_MSG)

Values(@START_TIME,@END_TIME,@ERROR_MSG)

End

Any Inputs ?

Note that, this may produce a list of dates. This is because, sysstatistics table maintains one or more entries for each of the index columns of the table. It may...

Theare are lot of reasons. so as some of our forum member suggested, do that one.

But before doing all those things , just take a look on Query plan.

Set showplan...

As Christoper suggested ,read that article.

You can do it without using any loops.

Ya, I have started to watch english movies which is...

Who is your audience for the presentation?

My management.

how to brief 'Problem faced and solution' part ?

My question is

What are all the points comes under Problem faced ?

What are all...

Also , i have some questions on TempDB.

1) what is the best size of TempDB ? The answer may be 'it depends',But if anybody added some valid points then it...

ID = @ID OR pF = @pF OR ClassID = @ClassID obviously.

User may pass all values or sometime they won't pass any values.

If they didn't pass any value then we need to pull all the data, if they pass any...