i want all the columns in one report

thanx fr reply

is there any work around fr this.................

or...

can any one plzz provide me the script ....

i think the script sholuld use linked server and chk it in another server if the job is still running it...

Hi Paul

i have used the following query but its also displaying the policies which have trans in between add and can and policies with only add

SELECT t2.TRN_POLICY ,

...

tabrez.test (2/27/2010)

---

also ihave tried above sql they are also displaying policies which have trans add and trans can and in between other trans like ren,adj,,,(which should not )

i want...

also ihave tried above sql they are also displaying policies which have trans add and trans can and in between other trans like ren,adj,,,(which should not )

i want policies...

Just to emphasize what Lutz stated, inless you have something to preserve the order of rows you have indicated, this task is doomed to failure because there is no guarantee...

hi Bru

is there any way that rather than adding last sep in job1

i want to add step 1 in job 2 on server 2 to check job 1 on...

i have tried the following query but count is also substracting from others & new (but it should not)

select LineOfBusiness,TransactionGroup,count(TransactionGroup )-

(select count(TransactionType) from dbo.Test a where a.LineOfBusiness=b.LineOfBusiness and...

emily-1119612 (12/21/2009)

---

SQL Profiler will report on current/ongoing database activity. It almost sounded from your post that you want to know about historical data insertion. In this case you would...

thanx fr the reply can u explain in detail as iam a new to sql 2005

Thanks Steve i got it nw

n thanxx fr all who have replyed

ill explain here in a better way here order is asc on sal

name sal

aaa 1000

bbb 2000

ccc 3000

ddd 4000

eee ...

ok take this as example

ill explain here in a better way here order is asc on sal

name sal

aaa 1000

bbb 2000

ccc 3000

ddd ...

ok u can take it as 6th row should be displayed first n rest in order(order means as they are entered in database)