r.hensbergen (3/13/2009)

---

The way your query is written is possible and works. However, it's not the most versatile. I would suggest to you, you join tables using INNER/OUTER/FULL JOIN. I rewrote...

thanks Grant...didn't think it would be that easy...so the BCP commands will work just the same then hey?

Jeffrey Williams (7/21/2008)

---

The alias t1 was used in the sub-query and I didn't remove it. Modify the sum statements and change the reference from t1 to t and that...

Server: Msg 107, Level 16, State 2, Line 1

The column prefix 't1' does not match with a table name or alias name used in the query.

Server: Msg 107, Level 16,...

Hi Jeffrey - thanks again for your time assisting me with this. I...

select

g.arrival...

As for your problem with multiple rows - that is going to be caused by the joins. In the following:

from transactions t

Inner Join rpt_revenue...

Jeffrey Williams (7/18/2008)

---

Okay, I think this is what you are looking for - but I cannot be sure. I am not sure whether or not you need to tie...

GSquared (7/18/2008)

---

I'm not clear on exactly what you're trying to do here, but this part definitely won't work:

sum(select t.tax1_amt as 'IVA' where tran_code='7000'

Nor the other parts like it. Not...

I just noticed I didn't enclose line 11 and 12...but I have more problems than that...:hehe:

thanks, i ended up doing a parameter file and putting in the /n on the last column...

40 SQLCHAR 0 12 "\r" 40 honor SQL_Latin1_General_CP1_CI_AS

for some reason...

can you post your...

rbarryyoung (3/24/2008)

---

ISNULL does require two arguments and you have 2 ISNULL functions in that statement (only the outer one has the second argument). I suspect that you do not...

could you verify...

thank you...you're totally right...i did not know that function did that and bc the data in the columns already using that function did not have any "blanks" (nulls) it kind...