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[/url]
Learn Extended Events