Hi
May be Issue is here
isnull(AVG(spent_liquor),'')
if the AVG value is NULL then you are trying insert
Empty into decimal field (avgliq), So set it to
"0" or some other numeric value. Do not set Empty character.
So use like below:-
insert into #suspended_alumina_gpl
select convert(datetime,@startdate),isnull(AVG(spent_liquor),0) from suspended_alumina_gpl
where CONVERT(varchar,edatetime,103)=CONVERT(varchar,@startdate)
hope it helps.