Hi
can i write the Delete SQL directly in ODBC stage
my query is
DELETE FROM imp_ProviderFacility FROM imp_ProviderFacility
inner join
( SELECT DISTINCT mosg.StateCode, mosg.PCPGroup, pf.PRVDR_FAC, rtrim(pf.PRVDR_FAC_LONG_NAME) 'PRVDR_FAC_LONG_NAME'
FROM
mo_SpecialistGroups AS mosg
INNER JOIN HCP.dbo.PROVIDER_FACILITY AS pf ON mosg.PCPGroup = pf.PRVDR_GRP
WHERE
pf.END_EFF_DATE Is Null) A
On A.StateCode=imp_ProviderFacility.StateCode
and A.PRVDR_FAC_LONG_NAME=imp_ProviderFacility.PRVDR_FAC_LONG_NAME
and A.PCPGroup =imp_ProviderFacility.PRVDR_GRP
and A.PRVDR_FAC=imp_ProviderFacility.PRVDR_FAC.
thers is INNER JOIN in it.
i am taking the Source and Target Same Table(imp_ProviderFacility)
and i had written this SQL in Upsert mode DELETE ONLY.
am i doing right ot not?
Thanks,
Praveen
Delete the data
Moderators: chulett, rschirm, roy
Delete the data
Last edited by jpraveen on Thu Sep 09, 2010 6:15 am, edited 1 time in total.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: