Viewing 15 posts - 16 through 30 (of 32 total)
Lynn
Sorry for the delay:
This is the required output
eid ename salary ...
February 10, 2010 at 7:46 am
Wschampheleer,
Sorry for misspelling your name in the first reply...
i am getting the expected result...
Thanks a million!
February 10, 2010 at 7:44 am
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...
February 10, 2010 at 7:41 am
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...
February 10, 2010 at 7:30 am
what about this?
select datediff(d,getdate(),convert (datetime,'09-06-2005 00:00:00',101))
October 25, 2009 at 10:37 am
Thanks a Ton!
Adding the local administrator account as the proxy account resolved the issue.
October 7, 2009 at 7:01 am
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...
October 7, 2009 at 2:28 am
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...
October 7, 2009 at 1:19 am
Exactly what i wanted....
Perfect.. Superb.. Fantastic
Thanks and Regards,
Paartha
My Brain stopped working Today 🙁
August 19, 2009 at 9:26 am
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...
August 19, 2009 at 9:05 am
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...
July 21, 2007 at 2:15 am
Sql Server is Microsoft SQL Server 2005/2000
OP sys Windows 2003 /2000
Plz generalise without releases
July 21, 2007 at 2:09 am
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...
June 28, 2007 at 1:00 am
it will get updated , but will have the detail of only when it got updated latest
March 15, 2007 at 10:37 pm
Viewing 15 posts - 16 through 30 (of 32 total)