String.Format(@"Select TOP(@batch) [Id]
                      ,[Barcode]
                      ,[ItemCode]
                      ,[Description]
                      ,[UnitOfMeasure]
                      ,[ItemClass1]
                      ,[ItemClass2]
                      ,[ItemClass3]
                      ,[ItemClass4]
                      ,[ItemClass5]
                      ,[VendorCode]
                      ,[Weight]
                      ,[UnitCost]
                      ,[UnitPrice]
                      ,[TotStockItem]
                      ,[Loc1Stock]
                      ,[Loc2Stock]
                      ,[Loc3Stock]
                      ,[ItemClass6]
                      ,[Warranty]
                      ,[QtyIn]
                      ,[QtyOut]
                      ,[MonthUpToDate]
                      ,[YearUpToDate]
                      ,[LMonthUpToDate]
                      ,[LastYear]
                      ,[BestInQty]
                      ,[VAT]
                      ,[Margin]
                      ,[Ingredients]
                      ,[Ingredients2]
                      ,convert(nvarchar,[LastModifiedDate],121) as [LastModifiedDate]
                      ,[Custom1]
                      ,[Active],[ScanSerial],[TrackingType]
                       from Masterdata with(nolock)
WHERE ( [LastModifiedDate]=@lastSync AND [Id]>@id) OR ( [LastModifiedDate]>@lastSync )
order by lastModifiedDate asc,id asc");