WayneS (11/2/2010)

---

buddy__a (11/2/2010)

---

I think the derived table would create an even more complicated query since the query in the derived table would require and additional join to create a key...

A view is a good place to add columns and aggregations, but I don't understand why you have a trigger and stored procedure for this. Views are materialized when...

Can you give me an example of the raw data that would make up the groupings that you have there? Table DDL would help too.

Duh.....I didn't notice that all of the other column values were the same.....GROUP BY would definately be the best option. Thanks Lutz!

Law enforcement.

Here's one way......given I don't know anything about your table structure, size, or indexing, this will work. If it does not perform well, post your table DDL and some...

That's exactly what I'd recommend to do (obviously from the other post).

preensheen (10/29/2010)

---

John Rowan (10/25/2010)

---

The source adapter can usually glean the result set metadata from nested SP calls, but it sometimes gets confused when there are several nestings and many selects...

preensheen (10/27/2010)

---

Yes, i am trying to pass parameter and and everything correctly...

That would work if the 2 tables were in fact related by idnum=idnum, but the OP did not say the tables were related.....just similar.

Thanks for posting the solution. I'm sure this will help somebody else down the road.

Look at the STUFF function in BOL.

Why can't you just include the double quotes in with the header variable? How are you getting the header variable into the file?

CREATE VIEW Transactions

AS

SELECT idnum,

trndate,

amount * -1 as amount

FROMPurchases

UNION ALL

SELECT idnum,

trndate,

amount

FROMPayments

GO

DECLARE @TABLE_A TABLE (PCode char(3), MonthPop int)

INSERT INTO @Table_A

SELECT '5F5', 400000 UNION ALL

SELECT '5F7', 777777 UNION ALL

SELECT '5HG', 222224 UNION ALL

SELECT '5HP', 153086

DECLARE @TABLE_B TABLE (PCode char(3), MonthPop int)

INSERT INTO...