Thanks Koen,

Got it working.

Really appreciate your help man.

Thanks for the answer, it makes sense.

I need to use it to pass the result into a variable.

;WITH CTE_Test (ID)

AS

(

SELECT CAST(id AS VARCHAR(60)) FROM cat_transaction

EXCEPT

SELECT ext_reference FROM Patricia.dbo.BUDGET_LINE

)

;

SET...

Hi all,

The insert procedure wont change and they won't provide a fix.

The reason the asked me to get the data back into our DB is because their developers can't.(Don't know...

John,

There will be more than one case id in the budget_line table because you can have multiple transaction for each case.

And for the second part, will I then select from...

GilaMonster,

I have inserted a row into the transaction table and all it says is :(1 row(s) affected)

OK GilaMonster I will try, don't know if it will work because there are other tables that will also need to get data in for each transaction

John,

The reason I created this trigger is because the data will only be inserted one at a time, so if there are two records being inserted then the trigger will...

It says one row affected when I execute the SP, or when I script out the transaction and just execute the code.

If I enable the trigger the transaction doesn't go...

It says one row affected when I execute the SP, or when I script out the transaction and just execute the code.

If I enable the trigger the transaction doesn't go...

GilaMonster,

It says one row affected, so it does work right.

When I look in the other DB I see the record has been inserted.

John Mitchell,

I don't know how they import the...

Yeah it doesn't insert into the transaction table.

There are no errors, it just doesn't insert it.

And if I disable the trigger and do another transaction, then it writes the "lost"...

It works perfectly if I execute it manually.

USE eqcas

GO

DECLARE @LineNumber SMALLINT,

@CaseID SMALLINT,

@ChargeingID SMALLINT

SET @CaseID = (SELECT

CASE_ID

FROM

cat_transaction

WHERE

id = (SELECT

MAX(id)

FROM

cat_transaction

)

)

SET @LineNumber...

Found a query for this.

To all who would need to do this in the future, use:

Use db_Name

SELECT column_name 'Column Name',

data_type 'Data Type',

CHARacter_maximum_length 'Maximum Length'

FROM information_schema.columns

WHERE table_name...

When he explained to me what he wants I did ask if i should have it in one column and he said no, im not sure even why he wants...

I have no idea sorry