Fisrt things First. You should look into changing such design ( if you can of course) Because it complicates all operations and makes possible a ton of inconsistensies!!

Second. Well, You...

Ok,

I found one that was related to the inserts but it has been also experienced (read suffered) on selects too:

 PRB: Poor Performance on a Heap

I still have to keep...

I just want to point out that it is possible to pass cursor data type as a parameter.

From BOL:

CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number...

>>I still belive that the problem was HW (or logical volume) related.<<

Gabor, Believe me, I have seen this on brand spanking new machines/Drives!!

The reason beign associated to Heap structures. I am...

Apparently you just answered your own question.

I have used this method for years and with a more general Method:

CREATE TABLE ControlTable (

   ...

Can you try:

Select

 SV00300.Service_Call_ID,

 SV00300.CUSTNAME,

 SV00300.DATE1,

 SV00300.USERID,

 SV00300.WS_Time_1,

 SV00300.Priority_of_Call,

 SV00300.Purchase_Order,

 SV00300.User_Define_2a,

 SV00300.User_Define_3a,

 SV00300.User_Define_4a,

 SV00300.Service_Date_1,

 SV00300.ADRSCODE,

 SV00200.ADDRESS1,

 SV00200.City,

 SV00200.State,

 SV00200.Zip,

 (left(SV00200.Phone1,3) + '-' + substring(SV00200.Phone1, 4,3) + '-' + substring(SV00200.Phone1, 7,4)),...

select distinct a.patient, a.invoice,  b.patient, b.invoice

from table a

   , table b

where a.patient <> b.patient -- Make sure this can not be null

and a.invoice = b.invoice

and a.pk <> b.pk --...

Not sure exactly what syntax are you using but you should be able to specify a format file and use a query or a view to handle the Field sizing...

>> ps: We've already been through this in the other post so I'm not going to say what I'm sure someone else will on the usage of cursors! <<

And that...

>> noel - is your typing speed faster than Remi's ?! <<

Not really, I got lucky this time

Select TableID, UserID , Sum(TimeKept + WorkQuality +Attitude) As Total

From YourTable

Group by TableID, UserID

Order by TableID, UserID

Believe me  I've tried  a Liquors List (none worked! )

Therefore I am starting to believe that you may be able to pick your...

Like I said: I have seen very strange behaviours on large tables Lacking Clustered indexes!! or having Clustered indexes with large fragmentation

Good Luck!

sswords:

I like that god!!! I need my wife to see that yet thought

If you plan to use this on an update I would recomment to move those criterias to the where clause

SELECT  voucherdate,vouchernumber,vouchertype,accountnumber,

debitcreditcode,    -1*(amount) as  'glamount'  

 FROM glentries_v

WHERE (debitcreditcode = 'D' AND amount <...