Hey all... I have a few tables that I am joining and need to know how to set a value from the return to a different column:
example:
SELECT
Prospect.ProspectName AS P1, AccountShipTo.ShipToName AS [Account Name], ProposalHeader.PropHCity AS City, ProposalHeader.PropHState AS State,
ProposalHeader.PropHNumb AS [Proposal ID], ProposalHeader.PropHRevNumb AS Rev, ProposalHeader.PropHCreateDate AS [Creation Date],
ProposalHeader.update_timestamp AS [Last Edit Date]
FROM ProposalHeader LEFT OUTER JOIN
AccountShipTo ON ProposalHeader.PropHShipTo = LTRIM(AccountShipTo.ShipToCust) LEFT OUTER JOIN
Prospect ON ProposalHeader.PropHBillTo = LTRIM(Prospect.ProspectNumb)
WHERE (ProposalHeader.Alias = N'billb')
GROUP BY ProposalHeader.PropHRevNumb, AccountShipTo.ShipToName, ProposalHeader.PropHCity, ProposalHeader.PropHState,
ProposalHeader.PropHNumb, ProposalHeader.PropHCreateDate, ProposalHeader.update_timestamp, Prospect.ProspectName
ORDER BY [Proposal ID]
I need P1 value (Test - Timberline Corp)to be in the Account Name column (NULL)... any ideas?
P1 Account Name City State Proposal ID Rev Creation Date Last Edit Date
NULL Samples, Inc. High Point NC Samples1 1 2007-07-25 2007-07-30
Test - Timberline Corp NULL Rapid City SD test1 1 2007-07-31 2007-07-31
(2 row(s) affected)
Any help would be appreciated... thanks!
Have you tried coalesce(AccountShipTo.ShipToName, Prospect.ProspectName) or isnull(AccountShipTo.ShipToName, Prospect.ProspectName)|||
Very coo! Thanks...
Did this....
SELECT COALESCE (AccountShipTo.ShipToName, Prospect.ProspectName) AS [Account Name]
No comments:
Post a Comment