Hi

I too experienced the same result (1,1). I tried it in sql 2005.

pls give the explanation......

hi,

Hope the following code helps u.....

the with statement can be given with only single select clause as below

WITH Parts

AS

(

...

hi

its simply returns the last sname in alphabetical order....

Its something similar to

select top 1 sname from students order by sname desc

Have u used a XML variable in your 2ndSP to receive the output?

yes, I am able to connect to linked server(s) through SSMS....

And the servers are running with default port only.... and no Anti-virus software is running....

the server is located in LAN only......

and the error is not for specific server.....

Sorry i was out of station for past two days.....

S it runs....

This is my procedure:

IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'ServerName')

begin

EXEC sp_dropserver @server=N'ServerName', @droplogins='droplogins';...

Thanks for ur reply

the code error (quotes) is made when typing......

i have given correctly in Procedure.....

yes this Procedure is runing at Login and Logout time to read values from other...

Try with this :

select ename + ' ' + (case when ((select count(*) from emp where ename=e.ename) > 1 ) then ecode else '' end) as ename from emp e

can u please provide some sample data and explain

U can introduce a new column and try it as below:

select *,case when ID=KeyId then 0 else 1 end as Eq from myTable order by Eq

hi

I want to get the identity column value after insert.....

Can i get this with an int variable....

Hi

I was also looking for the same problem....

Thanks a lot....

But is there any way to output the values into Variables than into the Table?

Hey there is a slight modification in the previous code

just apply this code

Select

lastname,

case when CharIndex(' ', firstname) > 0 Then substring(firstname,1, CharIndex(' ', firstname)-1) else firstname end firstname_1,

case when CharIndex('...