Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

InvestmentType == "Forward Cash" Expand / Collapse
Author
Message
Posted Monday, August 11, 2014 8:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 17,940, Visits: 15,925
ronan.healy (8/11/2014)
so say I use something like this
SELECT       *                
FROM dbo.BNYForwardsTaxLotsForwards
WHERE Quantity IN (SELECT Quantity as CurrencyPurchasedAmount
FROM dbo.BNYForwardsTaxLotsForwards
WHERE investmentType ='Forward Cash'
and Quantity < 0)

when I want to map CurrencyPurchasedAmount to a field in my table how can i


Since you are using a select *, your field name for the source would be Quantity.

What is the field name for the destination? That is your mapping.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1601915
Posted Tuesday, August 12, 2014 1:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 1:40 AM
Points: 133, Visits: 224
CurrencyCodePurchased is the name of the column it will be mapped to
Post #1602168
Posted Tuesday, August 12, 2014 3:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 1:40 AM
Points: 133, Visits: 224
will have to declare a variable for it to work
Post #1602201
Posted Tuesday, August 12, 2014 8:38 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 17,940, Visits: 15,925
ronan.healy (8/12/2014)
will have to declare a variable for it to work


No, you just map the datasource column to the CurrencyCodePurchased column in your destination object.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1602315
Posted Tuesday, August 12, 2014 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 1:40 AM
Points: 133, Visits: 224
how if im using an sql script
Post #1602324
Posted Tuesday, August 12, 2014 8:53 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 17,940, Visits: 15,925
ronan.healy (8/12/2014)
how if im using an sql script


Nothing was said about using a SQL Script (exeucte sql component). Your data source (ole db source) can use a sql statement/query as the source instead of a full table load.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1602328
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse