I have an admin for my reporting, he has to run report from all the 6 offices at once, how can i allow allow him to hit 6 different db's...

is there any other option apart from updating each n every database.

OK I think the conversion is on the wrong track, may be I didnt explain it in the right way, here is what i need.

say for example i have 6...

Is there anything I can do from the database side to perform that job..I mean like a store proc which can run all procs from diffrent db's at once for...

its ok.

moving is not a problem, actually those procs are for reporting purpose and I have to run all the reports at one time using the same store procs for...

what does it mean?

sorry..still its not working..I checked the query it returned row but not raising error mesg.

I have a problem when doing dynamic sort order, it is not allowing dynamic sort order when am using DISTINCT for select statement.

How can i get both in one proc

select

Distinct (e.empID),empName

from Indicator I, emp e

where...

when I have DISTINCT for empid y does empid duplicate in this scenariao?

but still didnt work...

Actually there is  condition in where clause like

e.jobID = I.IndicatorID

but anyways how can i get rid of...

I still wonder why my query returns an error saying

" subquery returned more than 1 value. This is not permitted when subquery follows =.!=.<,<=,>,>= or the subquery is used...

but how can i use EXISTS in my query as am looking for some records as

IF (select .......) IN (select....) begin raise error....

I have no problem with that coz it just has only 1 value.

But i want to restricy delete in the store proc itself, how can i do that.