Thanks everyone, for all of your feedback. 🙂

Thanks, Ron and Dan for your valuable feedback. 🙂

Thanks, Ron. I happen to have th SQL Server Management Studio R2 2008 installed which I obtained via the MS Alliance with Universities, as I'm in school. I'm wondering how...

Thanks, Ron and Dan. I happen to have th SQL Server Management Studio R2 2008 installed which I obtained via the MS Alliance with Universities, as I'm in school. I'm...

Hi Ron,

Thanks again for the input. By the MS stack, are you referring to the MS SSIS/SSAS/SSRS tools? If so, would the Express Edition suffice for learning?

Thanks, Ron. Are there any data warehousing tools you can suggest I can look into? I agree with what you're saying and I'd like to familiarize myself with such...

Thanks, Dan. Unfortunately my current position doesn't afford me the opportunity to do the things you've mentioned, but my previous position did. I will definitely look into the...

Thanks for all the helpful input, everyone. 🙂

Thanks, LutzM. That did the trick. 🙂

Hi Sean,

This is the query:

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

,CASE

WHEN ath_postype = 'GLD'

THEN sum(ath_usdamt)

WHEN ath_postype = 'GLC'

THEN sum(ath_usdamt) * - 1

END AS ath_usdamt

,count(*)

FROM dbo.ACCTING_TRANSACTION_HISTORY

left join Accting_body ae on...

Hi Chris and everyone,

Thanks for the suggestion. However from what has been posted here earlier, the fields in both Group By sections need to match. I tried it, nonetheless, and...

Hi Sean and everyone,

Thanks for your input. So I tried the following per your suggstion:

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

,CASE

WHEN ath_postype = 'GLD'

THEN sum(ath_usdamt)

WHEN ath_postype = 'GLC'

THEN sum(ath_usdamt)...

Thanks for your input, all. So, I tried using the Group By and Order By at the end of the query, but now it's returning a "Column 'dbo.ACCTING_TRANSACTION_HISTORY.ath_stlmnt_instr_id' is invalid...