The IT industry is frequently compared to bridge-building - normally in a negative way. To put it into perspective, bridge-building has been going on for centuries, if not millennia; by...

I think you probably need the country part of the WHERE clause as below;

select ledger_account, supplier_country, receiver_country, supplier_number, supplier_name, supplier_invoice_number, purchase_order_number, tran_type_po, document_number_po, invoice_amount,

currency, invoice_amount_hc, vat_account_po, vat_amount_po, tran_type_app, document_number_app, vat_account_app,...

I agree with Luis, but it does depend on how your data may expand in the future. We have a CRM application where there are several 'standard' phone numbers for...

Note that one of your collations is accent-sensitive and the other isn't. When applying the suggested solutions to your code, make sure you specify the one you need. For example,...

The programmers are definitely wrong (as you already know). They need to use one connection and decide either to keep it open all the time and close on exit, or...

I think you need to modify the Group By clause in the first select to

group by ath_stlmnt_instr_id, ath_instr_id, ae.stlmnt_line_instr_id, ath_gl_num, ath_cost_cntr

but you should also review the way you're handling the...

Maybe the Case/Sum part is intended to be;

SELECT ISNULL(ath_stlmnt_instr_id, ae.stlmnt_line_instr_id) AS ath_instr_id

,ath_instr_id AS orig_instr_id

,ath_gl_num

,ath_cost_cntr

,sum(CASE

WHEN ath_postype = 'GLD'

THEN ath_usdamt

WHEN ath_postype = 'GLC'

THEN ath_usdamt * - 1

END) AS ath_usdamt

,count(*)

FROM dbo.ACCTING_TRANSACTION_HISTORY

left join...

Is it possible that the @KeyCountReserve parameter is sometimes zero or negative? That would cause duplicates to be generated.

The IsNull should be used like this;

SELECT distinct

GBPriceList.[Mfr_Part_Num],

[HP_ Long_ description],

[HP_ Short_ Description],

--Exhibit_Unpivoted.Exhibit,

WeightKGS,

WarrantyCode,

ProductLine,

Serialized,

ListPrice,

Prod_Class,

IsNull(Exhibit_Discount.Discount, 0) AS Discount

rather than in the WHERE clause if you want to...

It occurs to me that there may not be an Exhibit_Discount record for products where the discount is zero. If that's the case, you'll need a left outer join to...

You could do something like the following to update the Cart status after each update of an order item.

update Cart

set Status = OverallStatus

from Cart inner join

(Select Cart2.CartNumber,

case when sum(Orders.PickStatus) =...

Sorry, yes I did check for triggers and there aren't any (not visible to my login anyway - I'll ask a server admin to check for me).

The stored procedure really is in the same database as the tables; most of our stored procedures use the 3-part name because some operate across more than one database and...

The table(s) and stored procedure are definitely in the same database and that is the same database specified by the application when it opens the connection. We've tried explicitly granting...

Thanks for your response. The error we're getting is shown in the attachment; not much detail as it's being displayed by an old VB6 program. The stored procedure just does...