Hi ,

Thanks for the reply.

But the issue here is the value of <Parameters> node is comming from the client. ('/Parameters/xml')

So i can't hard code it as /Parameters/xml,...

Add the Server1 as linked server to Server2, using sp_addlinkedserver.

In Server2 Query Analyzer

sp_addlinkedserver 'server1'

Then in Server2 Queryanalyzer use this query to get the data

Select * from Server1.northwind.dbo.[tablename]

Regards,

Ramesh K

Hi Arun,

Create a covered index on

DATETIMELASTMODIFIED , IDLocation columns and executre the query.

Script to create index

Create NonClustered index IX_DATE_ID ON TempReport (DATETIMELASTMODIFIED ,IDLocation )

Reagrds,

ramesh

Hi Sundeep,

Pleae find the ans for your Queries

1)Can i have a trigger inside a stored procedure.if "NO" then why.

If you have insert statment into a table ( on which trigger...

Hi,

Get the output in to one temp table like

select user_id,opdate,type,count(*) as Count into #temp

from table1

group by user_id,opdate,type

Select User_ID,opDate,

             HIV_Count = Case When Type ='HIV' then Count Else 0...

Try this one.

Select convert(varchar(10),'12/06/05 11.23AM' ,121)

Regards,

Ramesh K

Kenneth.. Thanks for your great explnation.. now i am very clear about this..

Thanks,

Ramesh K 

Thanks Gordon,

Can you give some info on performance related issues with these two diff types?

-- Ramesh K

Thanx mark and Larsen. I tried Your solution and it working fine.

hai sravan,

exec xp_cmdshell 'Bcp dbname..@tbl out "D:\text.txt" --c -Pservername -Uusername -Ppassword..This line is in the stored procedure only. Still it is giving error.

Please help me

Ramesh