at t=0

Table contains 50,000 rows

File contains 60,000 records

When I run the program and it finishes there are 110,000 recs. There should be 60,000 recs.

If I run the program again...

I'll give it a go.

What are the reasons for the speed improvement..

didn't know partition by existed - very nice func.

You can rank within a group.

Thank you...

Doesn't include when all are the same amount and you do not have type='cust'

You can do another check for this and update one of them with some other criteria..

Not the best I know..

with tMaxVal AS

(select lnno, max(amount) as most

from #temp

group by lnno)

SELECT t.lnno, count(*) as noitems, tMax.most

INTO #tOccurs

FROM #temp as t

inner join tMaxVal as tMax

on t.lnno = tMax.lnno

and...

Thats what I've suggested - but trying to see all methods.

the SQLExpress is installed on many client machines. I don't know if the install guys can create windows users easily....

Thanks will check link out.

If I create the SP logged in as SA in the master DB with EXECUTE AS OWNER.

I still get The server principal "sa" is not able...

Thanks for replying.

Yeah that's what I'm getting at I'm essentially moving all one shop's data to another shop.

The PK will still be there but I thought about using the...

I've had this issue, had to get it working. File came from another machine.

I granted "everyone" full access to the file attached it (windows permissions) - sledgehammer approach.

Then removed the...

Is this what you want?

SELECT *

FROM @table AS t1

INNER JOIN @table AS t2

ON t1.customerid = t2.customerid

AND t2.INSTALMENTNO = t1.INSTALMENTNO-1

WHERE t2.PAIDAMT =0

AND t1.PAIDAMT <> 0

Long and short the whole server has been restarted, SQL started ok. these Backup processes have disappeared.

Thanks for your help.

It didn't take any time to restart.

Thanks nice article

I cannot use it I have workgroup edition.

Thanks for the Reply.

I really don't understand how this could have happened. These jobs are being rolled back from Friday/Sat morn. Its now mon.

I can select from tables in the...

Say you have a table of sales you could partition on sales date, so have one file per year.

Performance would be better for queries in that time period

Good point, I'd forgotten that