yes 
sir
will try to format for sure
thanks a million

regards
hemu

sir
i have tried query after modifying same as below
--------query
declare @query nvarchar(max),@col nvarchar(max);
--declare @frdate datetime='01-jan-2019',@todate datetime ='31-jan-2019';
DECLARE @frdate date = '20190101', @todate date = '20190131';
select...

sorry 
please ignore my silly question

sorry again

sir
excuse my shabbiness
i am  a newbe ro sql
one   more question ... may be very absurd

what  is xtab .........?
please explain

hi
thanks 
here is my whole code
i have masked table names  on security grounds
--------------------------

declare @query nvarchar(max),@col nvarchar(max);
declare @frdate datetime='01-jan-2019',@todate datetime ='31-jan-2019';
select @col=

STUFF((SELECT...

hi
please help 
i am trying to use pivot clause in a query
declare @sql nvarchar(max);
declare @frdate datetime =;01-jan-2019',@todate datetime ='31-jan-2019' 
set @sql= select  entrydate,id,amt from xtab where entrydate...