Hi Everyone,
I have the following query:
INSERT INTO dbo.FTA_ReportFileDumpNew
select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date,
A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary,
A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE,
A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Mobile No. Range is Invalid' from dbo.FTA_ReportFileDump A
WHERE LEN(A.MobileNo) <> 10
INSERT INTO dbo.FTA_ReportFileDumpNew
select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date,
A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary,
A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE,
A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Sim No. Range is Invalid' from dbo.FTA_ReportFileDump A
WHERE LEN(A.Sim_No) <> 20
INSERT INTO dbo.FTA_ReportFileDumpNew
select A.MobileNo,A.CustomerName,A.Product,A.Suk_Type,A.FTR_Date,A.FTA_Date,
A.Sim_No,A.IMSI_No,A.Retailer_No,A.RetailerName,A.MacMobile_No,A.MacPrimary,
A.MacLocation,A.HUB,A.CombinedZone,A.TM_Name,A.TM_Number,A.RETAILER_SMS_DATE,
A.CUSTOMER_SMS_DATE,A.[TAT/Hrs],A.[TAT/Mins],A.MinuteWiseData,GETDATE(),'Customer name should not be blank' from dbo.FTA_ReportFileDump A
WHERE A.CustomerName IS NULL
----------------
Can any one suggest me how to use the "CASE" for the above query.
Regards,
Raj