ok i have 2 views
V_riprod_ZMATMAST returns 60 records
V_riprod_Specs_ZMATMAST_EQ returns 39 records or so that are matched
in another table.
these i will do an update on
problem i am having is the NEQ <>
i am trying to use the view below to return all the results of the
records that don't match.
so i can do an Insert...
SELECT DISTINCT TOP 100 PERCENT ABS(dbo.V_riprod_ZMATMAST.sap_partnum) AS pnum2
FROM dbo.V_riprod_ZMATMAST INNER JOIN
dbo.V_riprod_Specs_ZMATMAST_EQ ON
dbo.V_riprod_ZMATMAST.sap_partnum <>
dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum
WHERE (dbo.V_riprod_ZMATMAST.sap_partnum <>
N'dbo.V_riprod_Specs_ZMATMAST_EQ.sap_partnum')
i am using mssql2000 ent viewer.
have tried left outer join & a bunch of wierd stuff, and just keep
getting funky results...
This works for counting....
rcdCT TotalCount EqCount NeqCount
1 60 39 21
SELECT TOP 100 PERCENT COUNT(*) AS rcdCT,
dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT AS TotalCount,
dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT AS EqCount,
dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT -
dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT AS NeqCount
FROM dbo.V_riprod_Specs_ZMATMAST_Count CROSS JOIN
dbo.V_riprod_Specs_ZMATMAST_EQ_Count
GROUP BY dbo.V_riprod_Specs_ZMATMAST_Count.rcdCT,
dbo.V_riprod_Specs_ZMATMAST_EQ_Count.rcdCT
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
