Thanks so much Matt.

Seems to be working gr8

Hi Matt,

I for got to mention that I am using SQL-Server 2000 version.

I can't be able to use your solutions.

Is there any alernative solutions please suggest me.

Sorry Jeff.

Thanks once again Jeff.

surya

Thanks for writing the query for me Philip.

I tried to write but I couldn't figure out how to write that type of query.

You are really having creative ideas writing in...

Hi,

 I have problem with log shipping similar one as the above but in different senario

 For testing purpose...

Hi,

 I have problem with log shipping similar one as the above but in different senario

 For testing purpose...

Hi,

 I have problem with log shipping similar one as the above but in different senario

 For testing purpose...

Thanks david .

I still getting null values i haved tuned a bit witht he syntax.

Can you check what's wrong

SELECT errlog.empid,emp.empname,

  Address, MAX( CASE errlog.FieldName  when Address THEN errormessage ELSE ''...