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: Yesterday @ 10:18 PM
Points: 17,964, Visits: 15,968
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: 2 days ago @ 6:03 AM
Points: 134, Visits: 227
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: 2 days ago @ 6:03 AM
Points: 134, Visits: 227
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: Yesterday @ 10:18 PM
Points: 17,964, Visits: 15,968
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: 2 days ago @ 6:03 AM
Points: 134, Visits: 227
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: Yesterday @ 10:18 PM
Points: 17,964, Visits: 15,968
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