Lynn

Sorry for the delay:

This is the required output

eid ename salary ...

Wschampheleer,

Sorry for misspelling your name in the first reply...

i am getting the expected result...

Thanks a million!

Hi Wschampler

but the query does not work for this sample data..

insert into emp values(1,'CCCCC',10000,'abc','01/01/2005','n')

insert into emp values(1,'CCCCC',10000,'xys','01/11/2005','n')

insert into emp values(1,'CCCCC',20000,'xyz','01/01/2006','n')

insert into emp values(1,'CCCCC',20000,'xyy','01/01/2008','y')

i need this employee to get returned in...

Sorry Nabha..

Let me explain exactly i want.

If we look the table, we have 3 records for the empid 1,

1st record on the 01-01-2005 was inserted when that employee actually joined.

the...

what about this?

select datediff(d,getdate(),convert (datetime,'09-06-2005 00:00:00',101))

Thanks a Ton!

Adding the local administrator account as the proxy account resolved the issue.

Hi,

I enabled the "Non sys-admin job step proxy account" in the sql server agent settings. Still it is failing, but with a different message.

Msg 50001, Level 1, State 50001

xp_cmdshell...

As i told earlier.. this is the error

Msg 50001, Level 1, State 50001

xp_cmdshell failed to execute because current security context is not sysadmin and proxy acount is not setup...

Exactly what i wanted....

Perfect.. Superb.. Fantastic

Thanks and Regards,

Paartha

My Brain stopped working Today 🙁

Pakki,

There are no unique keys.

Take the example of an invoice detail table..

It will contain the invoice number, number of rows , and other details..

I need to validate whether the...

any updates?

I read after configuring a primary sever and secondary server

(through log shipping from Primary databases), you can reallocate query processing from Primary server to secondary servers.

Hope u can understand now.

For...

Sql Server is Microsoft SQL Server 2005/2000

OP sys Windows 2003 /2000

Plz generalise without releases

Thanks for all your replies .. i too tried on many tables and was tried to compare execution plans .. but i too feel that exists and not exist would...

it will get updated , but will have the detail of only when it got updated latest