Comments by devchina (Top 35 by date)

yes compiled.
List<notificationbo> ObjNotificationDetails = new List<notificationbo>();
ObjNotificationDetails = NotificationDL.FetchNotificationDetails(objNotificationBO);//30recods
ObjNotificationDetails = ObjNotificationDetails.Where(a => a.IsActive == objNotificationBO.IsActive).ToList();//30records
if (objNotificationBO.Country_Id != 0)
{
ObjNotificationDetails = ObjNotificationDetails.Where(a => a.Country_Id == objNotificationBO.Country_Id).ToList();//here getting 0 records

}

INSERT INTO IDSOWNER.NE_CS_BY_DEVICE
(FDR, BRANCH, GIS_ID,TWN_CD,
ROUTE_CODE,POLE_NUMBER,SUFFIX,DEVC_TYPE_CD,DEVC_TYPE_DESC, STREET_NAME, TREE_KEY, POWER_CLUSTER_ID, GIS_RWO_ID3)
SELECT
P.NORMAL_CIRCUIT_ID FDR,
P.IDS_BRANCH BRANCH,
DISTINCT P.GIS_ID,
P.TOWN_CODE,
P.ROUTE_CODE,
REPLACE(P.POLE_NUMBER,chr(92), chr(92)||chr(92)),
P.SUFFIX,
X.DEVC_TYPE_CD,
T.DEVC_TYPE_DESC,
P.STREET_NAME,
B.TREE_KEY,
B.POWER_CLUSTER_ID,
B.GIS_RWO_ID3
FROM IDS_PO_DEVICE P, REF_DEVC_TYPE T,
REF_DEVC_TYPE_XREF X, POWERON_NE.PO_DEVICE B
WHERE P.SOURCE_GIS = 'NE'
AND P.GIS_RWO_CODE = X.PO_DEVC_CD
AND X.DEVC_TYPE_CD = T.DEVC_TYPE_CD
AND B.TYPE = 'actual'
AND P.GIS_RWO_CODE = B.GIS_RWO_CODE
AND P.GIS_RWO_ID1 = B.GIS_RWO_ID1
AND P.GIS_RWO_ID2 = B.GIS_RWO_ID2
AND P.GIS_RWO_ID3 = B.GIS_RWO_ID3;

Now i want to add Delete query how?
DELETE FROM NE_CS_BY_DEVICE WHERE GIS_ID IN (--This will delete all devices that will be re-inserted with NE_CS_BY_DEVICE.sql.
SELECT DISTINCT P.GIS_ID
FROM POWERON_NE.PO_DEVICE B,
IDS_PO_DEVICE P
WHERE P.SOURCE_GIS = 'NE'
AND B.TYPE = 'actual'
AND P.GIS_RWO_CODE = B.GIS_RWO_CODE
AND P.GIS_RWO_ID1 = B.GIS_RWO_ID1
AND P.GIS_RWO_ID2 = B.GIS_RWO_ID2
AND P.GIS_RWO_ID3 = B.GIS_RWO_ID3
)
could yOu plz help me.

I am getting error cannot implicitly convert string to bool