Steve, Wayne

Thank you!

Both of your statements give the desired results. Thanks for extracting the teeth! It appears to have been painfull. Thanks for the patience!

Best regards

Pieter

Steve Cullen (6/29/2010)

---

The confusing part to me is you say records from one will not be in the other table. If that is so, you have no way to...

Steve Jones - Editor (6/29/2010)

---

Is this Actuals? Or Budget?

I'm a little unclear about what you want for results? It looks like you are joining budget to actuals already, or is...

Thanks Steve, but how...

I did notice the word UNION from three posts. It was also suggested at the office.

As a novice though I have no idea what to do with it, (and I...

I have changes the suggest query to:

declare @Org text, @period int -- will be parameters to the procedure

SET @Org = 'RSA/JNB/T00'

SET @period =201001

SELECT IntGL.Org, IntGL.period, IntGL.account, GL.Amount, IntGL.budgetAmount

FROM...

Wayne

Thanks, your understanding of the question is correct.

I just need to figure out how to link the parameters in the worksheet to the declare statement and then test the query.

Thanks...

Appreciated.

Let me rephrase. Where on this forum collection do I post questions about SQL Select Queries?

On hhich discussion group/sub forum - there are several and it is not clear whether...