How to Delete duplicate rows from table in sql

How to Delete duplicate rows from table in sql server

WITH cte AS (
    SELECT 
Barcode,
        ROW_NUMBER() OVER (
            PARTITION BY 
                Barcode
            ORDER BY 
               Barcode
        ) row_num
     FROM 
        Isuued_Product_DetailsLog
)
DELETE FROM cte
WHERE row_num > 1;


I hope this will help to you

how to use if else condition in sqlserver

How to use if else in sqlserver

This is my code  you can see below:
I hope this will help full to you

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[CCISales_Groupwise]

@From varchar(50),
@To varchar(50),
@Exid varchar(50),
@ExName varchar(50)
as
begin
if @Exid!='All'
Begin
select distinct  cdp.Exhibition_Id,cdp.Exhibition_Name, convert(Varchar(50),cdp.Added_On,103) AS dates,CDP.GroupMode,
(SELECT SUM(Product_Total) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103) and Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
)AS PRODUCT,(SELECT COUNT(*) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103) and Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
)AS Qty  from CCISold_Product_Details AS CDP where Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
group by Exhibition_Id, Exhibition_Name,convert(Varchar(50),cdp.Added_On,103),CDP.GroupMode
End
Else
begin
select distinct 
 convert(Varchar(50),cdp.Added_On,103) AS dates,CDP.GroupMode,
(SELECT SUM(Product_Total) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103) and Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
)AS PRODUCT,(SELECT COUNT(*) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103) and Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
)AS Qty  from CCISold_Product_Details AS CDP where Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
group by convert(Varchar(50),cdp.Added_On,103),CDP.GroupMode
end
--select distinct @From as frd,@To as Tod, cdp.Exhibition_Id,cdp.Exhibition_Name, convert(Varchar(50),cdp.Added_On,103) AS dates,CDP.GroupMode,
--(SELECT SUM(Product_Total) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103)
--)AS PRODUCT,(SELECT COUNT(*) FROM CCISold_Product_Details WHERE GROUPMODE=CDP.GROUPMODE and convert(Varchar(50),Added_On,103)=convert(Varchar(50),cdp.Added_On,103)
--)AS Qty  from CCISold_Product_Details AS CDP where Exhibition_Id like case when @Exid='All' then '%%' else '%'+@Exid end and Exhibition_Name like case when @ExName='All' then '%%' else '%'+@ExName end
--group by Exhibition_Id, Exhibition_Name,convert(Varchar(50),cdp.Added_On,103),CDP.GroupMode
end

How to create a comma delimited list using SELECT clause from table column?

How to create a comma delimited list using SELECT clause from table column?

USE AdventureWorks

GO

DECLARE @listStr VARCHAR(MAX)

SELECT @listStr = COALESCE(@listStr+',' ,'') + Name

FROM Production.Product

SELECT @listStr

GO




I hope this will helpful to you

How to Synchronize local database to remote database

How to Synchronize local database to remote database

View below given link this will help you

https://vivekcek.wordpress.com/2012/07/08/synchronizing-sql-server-databases-using-microsoft-sync-framework/

How to get month from a date in sqlserver

How to get month from a date in  SQL server

If  I am writing select Month(getdate()) then I am getting from month.But if I am writing this command like

Select Month('02/12/2019') then it give me month=2

but here my month is 12 what I can do

Kindly help

thanks in advance