Shawon Amos

select distinct rowid=IDENTITY(Int, 1,1),  buyorder.Chln into #temp from BuyOrder  inner join rChallan  on BuyOrder.Chln=rChallan.OrderNo where BuyOrder.Qty=BuyOrder.sQty/2 and BuyOrder.sQty=rChallan.Qty declare @challanID as varchar(50) declare @num as int set @num=1 while(@num<=(select MAX(rowid) from #temp)) begin set @challanID=(select Chln  from #temp  where rowid=@num ) print @challanID set @num=@num+1 end drop table #temp

DECLARE @singleDuplicateData TABLE ( ID NVARCHAR(50), StyleID NVARCHAR(50), CLID NVARCHAR(50), FileName NVARCHAR(550), FilePath NVARCHAR(550) ) INSERT INTO @singleDuplicateData         (           StyleID ,           CLID ,           FileName,  FilePath         ) select top 1 StyleID,CLID,FileName,FilePath  from #temptblFiles  t  WHERE t.CLID=@CL AND t.StyleID=@Style

UPDATE dbo.Sale SET NetAmt=(SELECT NetAmt FROM dbo.Ssummary WHERE Ssummary.Invoice=Sale.Invoice) WHERE Invoice IN ( SELECT ss.Invoice FROM ( SELECT DISTINCT Sale.ShopID,ShopName ,Invoice,CASE WHEN (LEFT(Invoice,2)='CR') THEN -NetAmt ELSE NetAmt END  NetAmt ,  CONVERT(DATE,SaleDT,101) SaleDT,  (SELECT NetAmt FROM dbo.Ssummary WHERE Ssummary.Invoice=Sale.Invoice) AS ssNet FROM dbo.Sale INNER JOIN dbo.ShopList ON ShopList.ShopID = Sale.ShopID INNER JOIN dbo.StyleSize ON StyleSize.Barcode = Sale.BarCode WHERE CONVERT(DATE, SaleDT,101) BETWEEN '01/01/2017' AND '01/31/2017' AND Sale.ShopID='OS01' --order by Invoice ) AS ss WHERE ss.NetAmt<>ss.ssNet )

JSON has a maximum length! I need to increase this value. In web.config add the following: <appSettings> <add key = "aspnet:MaxJsonDeserializerMembers" value = "150000" /> </appSettings> The unit of measure is the # of items (key/value pairs) that can be deserialized. If your JSON has 500 members (key/value pairs) and your limit is 400 then it would fail.

if ( Date({RPT_ShopWiseComSaleSumm1.SaleDT}) >= Date("01/01/2017"))then {@totSale}-{@discount}-{RPT_ShopWiseComSaleSumm1.CustRet}+{@vat} else {@totSale}-{@discount}-{RPT_ShopWiseComSaleSumm1.CustRet}

if(left({RPT_ShopWiseComSaleSumm1.Invoice},2)='CR') then 0 else ToNumber({RPT_ShopWiseComSaleSumm1.totalsale}) if ( Date({RPT_ShopWiseComSaleSumm1.SaleDT}) >= Date("01/01/2017"))then     if(left({RPT_ShopWiseComSaleSumm1.Invoice},2)='CR')     then     -{RPT_ShopWiseComSaleSumm1.CustRet}     else    {@totSale}-{RPT_ShopWiseComSaleSumm1.CustRet}-{RPT_ShopWiseComSaleSumm1.Discont} else {@totSale}-{RPT_ShopWiseComSaleSumm1.CustRet}

DateDiff("d",({RPT_SalePerfrmBySeasons.IssueDT}),{RPT_SalePerfrmBySeasons.CurrentDT})

class DateToWord     {         public string ConvertEnglish()         {             return "";         }         public string ConvertBangla(DateTime dt)         {             int day = dt.Day;             int month = dt.Month;             int year = dt.Year;             string BanglaValue = "";             //if (day < 12)             //{             //  ...

class TimeToWord     {         public string ConvertEnglish()         {             return "";         }         public string ConvertBangla(DateTime dt)         {             int hour = dt.Hour;             int minute = dt.Minute;             string BanglaValue = "";             if (hour < 12)             {                 BanglaValue += @"সকাল";         ...