Can you dynamically construct a bcp statement?

Tommy Bollhofer (10/2/2007)

Is there an FW between the MSSQL server and the SMTP relay? If this is the case, can you confirm w/ IT that TCP 25 is open...

Do you have to update or can you insert ?

INSERT cross_tab_table

select id,

sum(CASE WHEN MM = 1 THEN TotalAmount ELSE 0 END) as JAN_TOTAL,

sum(CASE WHEN MM =...

I think you need to define relationships between the tables; foreign key/primary keys in the actual database or on the data source view.

If you are looking for training materials, you might consider looking here:

http://www.learnsqlserver.com/VideoTutorials/

http://www.learnintegrationservices.com/

I havent used any of the videos so I dont know how good they are, but they are...