My boss wants this script as a view, and I told him you cant put this in a view, just wanted to make sure im right.

Thanks for your help man,...

Ah i didnt know I could select like that.

Thanks Ben!!!

🙂

Just want to confirm one more thing with you, I can't put all this code into a view, and just query...

If I exclude the if statement, the SELECT works perfectly.

I just need to know if and how I can change the IF statements, so the conditions the the IF will...

Let me explain a bit better what I need to do and then post my whole code.

I need to write a script, where i can insert a name id, and...

If I set the variable to a value in the column, and then set the var = to the column it also work, but i dont want to use it...

Adr2 and Adr3.

I want to use the column name instead of the variable in the if statement, because i have to set the variable = to the column anyway.

Bit I...

It still says iunvalid column name

can someone please tell me how I can set the @ADR2 in the if statement equals to the actual column name?

Thanks guys I figured it out.

I set the language_id from the wrong table to 3.

The end user would insert all the details before the invoice is created, when he creates a preview the invoice show up on the screen with an invoice number starting...

The table is being populated manually at the moment, I have to use a trigger so that when new data gets inserted, it will automatically move over to the new...

There are multiple line in the Invoice line table with the same ID, that's why I joined the Invoice ID and Invoice header.

I have to move them across from the...

BEGIN

INSERT INTO PAT_AJS.dbo.AJS_Client_Invoices

SELECT IL.INVOICE_ID, IH.Invocie_DATE,

IH.Case_ID,IH.Actor_ID,IL.Invoice_Line_Text ,IL.Invoice_Amount,B_L_SEQ_NUMBER,B_L_AMOUNT,BL.WORK_CODE_ID

FROM INVOICE_LINE IL, INVOICE_HEADER IH, BUDGET_LINE BL

WHERE IH.Invoice_ID = IL.Invoice_ID

AND IL.INVOICE_ID = (SELECT MAX(invoice_id)

FROM INVOICE_HEADER

WHERE INVOICE_ID > 9990000

AND INVOICE_ID LIKE '1%')...

yes it does find all the data by itself, if I take the code and ut it into the trigger it works...but I need this trigger to execute a couple...

Thanks for everyone who helped, I finally got it working just before end of the day yesterday.

Just one more question, does anyone know the syntax to use this in a...