As you say that this data in the table is getting deleted only for the last couple of days,

Kindly check the recently deployed codes (Stored Procedures, Patches) for the...

Thanks for your help!

post your query which you use

But this one is not working for SELECT CONVERT(CHAR(6), '2012-09-15', 112);

i mean When we provide a hard coded date.

Could you please help with more inputs

1. does it happen when you try to connect a new session in a fine morning or it happens when you are in...

I feel the best op tion would be to use SET ROWCOUNT option and use while loop to move the data in batches. This could improve the performance a bit.

Try this query

select employeeid, employeelogindatetime, employeedept

from tablename

where employeelogindatetime between @fromdate and @todate

and employeelogouttime like isnull('',null)

yes i have read this , but i dnt know hw to do it . but i will do it and tell you . will this be the reason for...

Actually this a reporting server . so to view reports we restore the production database from Production database to Report Server Daily . This is done to improve the performance...

we are using SQL 2005 (64 Bit )Enterprise Edition . On thing i found was , Actually we are restoring a Database daily from our production Server to this server...

sir , i think it occurs on running queries only . i cant understand abt what you are meaning by domain . For your info , We have two 4...

Dear ,

you have mentioned that you are directly performing daily backups to the destination server . how do u do this ? can u explain in brief or tell...

please tell me whether its possible to output the result set as a .pdf file attachment . if yes please provide a sample coding