One Table Data Fill Thourgh Store Procedure

Manish Patat

5y799

i have one table Like

I Have Main Master Table Like Data

I Have Fill Master Table Data One table Through Store Procedure

My Store Procedure Here..

ALTER PROCEDURE [dbo].[RFM_SubOADetailDAtaAdd]

BEGIN

Declare @Loop int,@Cnt int

set @Loop=0

select @cnt=Count(*) from SubOADetail

while(@Loop < @cnt)

BEGIN

Declare @Mouldcode nvarchar(15), @CastingDrg nvarchar(60),@CastingDrgRev nvarchar(4)=NULL

set @Loop=@Loop+1

Select @Mouldcode=MOULDCODE From SubOADetail

Select @CastingDrg=CastingDrg,@CastingDrgRev=CastingDrgRev From MouldDetails Where MOULDCODE=@Mouldcode

update SubOADetail set CastingDrg=@CastingDrg,CastingDrgRev=@CastingDrgRev where MOULDCODE=@Mouldcode

end

End

This Sp Was Execute But Not Change Data And message Warning Display Like

(7 row(s) affected)

Warning: Null value is eliminated by an aggregate or other SET operation.

Thanks in advance

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Piyush Pansuriya5y ago
Accepted answer
Hi Manish,

Your statement select @cnt=Count(*) from SubOADetail gives you a warning. because of null value.

Use PrimaryKey or not null field into the Count().

i.e. Count(OANO)
Manish Patat5y ago
HI @Sachin And @Piyush
You're right but triggered by being on my table
that error after trigger disable then execute
Thank Both of you
Manish Patat5y ago
Hi Piyush
Thank For Help...
All Try me but same error given No any Row ID or OANo Not Null or blank but issued same Warning error.
Sachin Singh5y ago
hii @Manish
as @piyush suggested , its just a warning , and we too get warning on such queries , so it is not something to be worry about.
is there any other issues than the warning?
Piyush Pansuriya5y ago
Hi Manish,

You can try another way like
SELECT @cnt = SUM(CASE WHEN [uid] IS NULL THEN 0 ELSE 1 END)
OR
You can off the warning message
SET ANSI_WARNINGS OFF;
GO
Because its just a warning.
Manish Patat5y ago
Hi Piyush Pansuriya
i have already try select @cnt=Count(ID) from SubOADetail
But Same error Occured
(7 row(s) affected)
Warning: Null value is eliminated by an aggregate or other SET operation.
Sachin Singh5y ago
you can also use merge table
https://www.mssqltips.com/sqlservertip/1704/using-merge-in-sql-server-to-insert-update-and-delete-at-the-same-time/