I should give credit to that developer because he was so much into customization that forced me to figure out how to get to my "normal" look-and-feel

I know ... that is why I tried to post a table so that he can be CLEAR about what data goes into what column!

Can you fill in the blanks ?

UserID TransactionType SaleAmount PaymentAmount PaymentType

209541 Executive 3 Year 6200

209541 3000 Visa

209541 3200 Amex

-------|----------------|-----------|--------------|------------|

UserID |TransactionType |SaleAmount |PaymentAmount |PaymentType |

-------|----------------|-----------|--------------|------------|

209541 |                |           |              |           ...

Tools-->Options-->Editor(tab) Check Tabbed Mode

CREATE PROCEDURE SP_CT_ITEM

AS

  DECLARE @CONTADOR NUMERIC(8)

  SET NOCOUNT ON

 -- no need for explicit Transaction because of atomicity in single statements

    UPDATE PARAMETRO SET @CONTADOR = NM1_PARAMETRO = NM1_PARAMETRO  +...

Actually I knew this one because in one occassion I had to use the computer of a developer at one ofmy clients and the guy had QA sooooo customized that...

In QA go to Tools->Options->Connections(Tab) and UNCHECK Use regional settings....

hth

Just create an Alert for SQL Performance Condition like:

IF (EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'YourDatabase Log > 70%'))

 ---- Delete the alert with the same name.

  EXECUTE msdb.dbo.sp_delete_alert...

Try:

raiserror (50001,1,16)  with log

May be I don't know much about Delphi but I think you will need "TGUID" type for the value

I don't see why ? Do you have some sample data ?

create procedure dbo.yourprocname @param uniqueidentifier output

as

begin

...

select @param = columnname from table where x=z

end

and from Delphi use the Returned value of the output parameter

hth

what is your question ?

Yes there is. Open the Relationships Window and right click on the foreign key LINE and select "Cascade Delete Related Records "

hth

Right padding ? Something is not right on your app. I can accept that you would have said Left padding but definitely not Right.

Can you double check that?