BI Learning Hub

This blog will provide real time solutions in SQL, SSRS, SSIS, DWH, Tableau, Analytics Solution, Agile - Scrum, Salesforce Einstein Analytics (Tableau CRM) and many more. Keep Learning!

9/15/2014

Different strategies for removing duplicate records in SQL Server

Different strategies for removing duplicate records in SQL Server

http://www.mssqltips.com/sqlservertip/1918/different-strategies-for-removing-duplicate-records-in-sql-server/

at September 15, 2014

Email This BlogThis!Share to Twitter Share to Facebook Share to Pinterest

Labels: Remove duplicates records in SQL server, Removing duplicates in SQL server, way to remove duplicates record in SQL server

1 comment:

Lavanya1/03/2022
I have found great and massive information. Thanks for sharing
Msbi Online Training in India
Msbi Training
ReplyDelete
Replies

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Tableau interview questions and answers for experienced professionals

Tableau Interview Questions and Answers for experienced professional 1. What is TABLEAU? Tableau is the powerful and fastest visualizing ...

Format Date in SSIS MM-DD-YYYY or MM/DD/YYYY DD-MM-YYYY or DD/MM/YYYY

Format Date in SSIS MM-DD-YYYY or MM/DD/YYYY DD-MM-YYYY or DD/MM/YYYY Date Format MM-DD-YYYY: RIGHT("0" + (DT_STR,4,1252...
Month Name and Day Name in SSIS expression

Month Name and Day Name in SSIS expression: In many scenarios we need to evaluate month name or days name from date in SSIS expr...
Differences between CTE and View

Differences between CTE and View CTE: CTE stands for Common Table expressions can be thought of as a temporary result set that is de...

Search This Blog

Pages

Home
SQL
SSRS

About Me

Avanish Tomar

View my complete profile

Blog Archive

► 2021 (8)
- ► October (3)
- ► September (2)
- ► July (2)
- ► June (1)

► 2019 (3)
- ► March (3)

► 2018 (15)
- ► September (3)
- ► August (2)
- ► May (10)

► 2017 (1)
- ► November (1)

► 2016 (5)
- ► December (3)
- ► November (2)

► 2015 (34)
- ► October (17)
- ► September (16)
- ► May (1)

▼ 2014 (13)
- ▼ September (13)

► 2013 (2)
- ► December (1)
- ► October (1)

► 2012 (1)
- ► August (1)

Labels

#Error in SSR
2014
2017
add costum color in color palettes in Tableau
Additional features of SQL 2012
Advance features of SQL Server 2012
advantages of CTE
advantages of View over CTE
Aggregate Function
alphanumeric data order in SQL server
Alternate background color in SSRS
apply operators in sql server
AWS
Azure
BI Engineer
BIDS
Blending
Business Intelligence
Caching in SSRS
Calendar table
calendar table in sql
Calendar table in SQL server
CAST
Change DateTime into another timezone SQL
Change DateTime into another timezone SQL Server
change from one timezone to another timezone in SQL
change lower case to uppercase
CHARINDEX
Cheat sheet SSIS expressions
COALESCE
Configuration and Deployment of a report on report manager
Configuration of report manager
Context Filters
Conversions function in SSRS
CONVERT
correct order of SQL query
Correlated and Noncorrelated Sub query
Count Days between two dates excluding weekends
Count null values for all column
Count total Null value for each column of a table
Count total null value from each column for each row
Count Week days between given two dates excluding weekends (Sat & Sun)
Creating 5 Star Rating using Indicators in SSRS
creating five star rating in SSRS
Cross Apply
Cross Apply in SQL
Cross Apply in SQL Server with example
CTE
CTE and View
CTE and View in SQL server
Custom formatting of Datetime in SQL
Data
Data Analyst
Data Bar in SSRS report
Data Blending
Data Driven Subscription in SSRS
Data Engineer
Data join
Data models
Data Science
Data Source Filters
data source on report manager
Data sources in SSRS
Data transformation
Data warehouse with SQL server
Data Wharehouse
Database
Database traversing in SQL
Date Function
Date Time expressions of SSRS
DATEADD
DateAdd in SSRS
DateFormat in SSRS
DATEPART
Datepart in SSRS
Datetime Custom format in SQL Server
DateTime expression in SSIS
datetime formatting in SSRS
DateTime function in SSIS
Day name in SSIS
Dense Rank
design Data bar in SSRS
Design Data models
difference between chaching and snapshot in SSRS
Difference between Cross Aplly or Outer Apply
Difference between temp table and CTE and table variable
Difference between Temp Table and Table Variable
Differences between CTE and View
differences between data driven and standard subscription
Differences between View and CTE
different kind of SSRS report
different type of SSRS report
Different types of Filters in Tableau
Dimension Filters
display message if no data in SSRS
Displaying some message within a Tablix if there is no data
Divide by zero in SSRS
Divide by zero or null value in SSRS
Drill Down
Dual axis
DWH
Exclude 0 from value in SQL Server
exclude 0 initially from a column
Execute SSRS Subscription through SQL Query
Experienced
export data into multiple tabs in SSIS
Export Data to multiple excel sheet from SQL server Table using SSIS
export into tabs data in SSIS
Extract Filters
Fetch data from different database servers
Filtered index
Filtered index in SQL Server
Filters in Tableau
Find all tables from all database
Find all Tables with their columns in SQL
Find all views with their columns in SQL
find columns and their table
find day in SSIS
find month from date in SSIS expression
find tables
find week day in SSIS expression
FORMAT
Format Date in SSIS DD-MM-YYYY
Format Date in SSIS DD/MM/YYYY
Format Date in SSIS MM-DD-YYYY
Format Date in SSIS MM/DD/YYYY
Format function in SQL server
Format the date
Formatting of date in SQL Server
Formatting of Datetime in SQL server
Full outer Join
Functions in SQL
Generate calendar in SQL
get highest salary without rank function
get rank without rank function
Get Week End Date Using SQL Server
Get Week Start Date
global temp table
How SQL server stores data on a binary Level
How to create a Calendar table in SQL server with example
how to create a data driven subscription in SSRS
how to create a shared data source
How to create a standard subscription in SSRS
How to create shared schedule in SSRS
how to find a columns table
How to find Week End date
How to find Week start date
how to get previous row value with current row
how to implement Data warehouse with SQL server
how-to-identify-all-stored-procedures-referring-a-particular-table
If condition in SSIS
If Exists condition
If Exists Update Else Insert
IIF in SSRS
Import excel data into SQL Server table
improve performance of SQL query
Index
Indexes in SQL Server 2008
Infopath forms
Inner Join
Interview Preparation
Interview questions
Introduction to correlated and noncorrelated subquery
IsNothing expression in SSRS
Joins in Tableau
LAG and LEAD functions in SQL Server 2012
LEAD - LEG
LEAD() and LAG() functions
Left Join
Like operator of SSRS
local temp table
Lookup and lookUpSet in SSRS
Lookup in SSRS
LookUpSet in SSRS
LTRIM
measure
Measure Filters
Month Name in SSIS
Month name in SSIS expression
mostly asked tableau interview
mostly asked Tableau interview questions
Mostly used Expression in SSIS
MS BI
New Features in SQL server 2012
NoSQL
NVL
open url in new window in SSRS
Opening a link in SSRS within a new window
Oracle
Order Month name in SQL
Order month name in SSRS
Outer Apply
Outer Apply in SQL
Outer Apply in SQL Server with example
Page break in SSRS expression
Parameter
PATINDEX
preferences file
Preferences.tps file
Proper case in SSRS
Query performance approach in SQL Server
Query performance in SQL server
Rank
Real time
remove 0 initially from a column value in SQL Server
Remove duplicates records in SQL server
Removing duplicates in SQL server
Report Manager
Report server tables
Reports deployment
Retrieve data from multiple database servers
right join
row level security
row level security in database
row level security in SQL
Row Level Security in SQL Server 2016
Row Number
RTRIM
Run subscription through SQL code
SAS
Scenario based
Schema Query for view in SQL
Schema query to find all Tables details in SQL Server
Schema query to find all tables with column names in all database
Schema query to find all Tables with their columns details
schema query to find all views details in SQL Server
Schema query to find all views with their columns details
Schema Query to find tables
Schema query to get Tables details in SQL
Select queries order of execution
Select query order of execution in SQL Server
shared data source
Shared Schedule
Shared Schedule in SSRS
short Month name value in their natural order from Jan to Dec in SQL Server
show link or underline based on condition in SSRS
Snapshot in SSRS
Snowflake
Sort Month Name in SQL Server
Sort month name in SSRS
Sorting Alpha Numeric and Numeric data in SQL Server
sorting alphanumeric data
Split column values based on delimiter
Split delimiter separated value in SQL Server
Split function
Split function based on delimiter to show values in separate columns
Split function of SQL Server
Split function to show delimiter separated value in separate columns
Split function to show value in separate columns
SPSS
SQL
SQL best practices
SQL Functions
SQL interview questions
SQL queries for data analysis
SQL query example
SQL Query tuning and performance
SQL Real time scenarios
SQL Server
SQL Server 2016 Row level security
SQL server Architecture
SQL Server Datetime Custom format
SQL Server functions
SQL Server Functions with examples
SQL Server index 2012
SQL Server Indexes
SQL server Internals and Architecture
sql server loop through databases
SQL Server maximum number of indexes per table
SQL Server Performance Optimization and Troubleshooting
SQL server query execution order
SQL server Row level
SQL Server user defined functions
SQL Tutorial
sql-server-find-stored-procedure-related-to-table-in-database-search-in-all-stored-procedure
SSIS commoon expressions
SSIS Date format in DD/MM/YYYY
SSIS Date format in mm/dd/yyyy
SSIS expression
SSIS Expressions
SSRS Action to Open a URL in a New Window
SSRS Caching
SSRS caching and snapshot
SSRS Chart settings
SSRS data time expressions
SSRS Date expressions
SSRS date formatting
SSRS date time formatting expressions
SSRS Deployment
SSRS end date
SSRS expressions
SSRS expressions for datetime
SSRS last month enddate
SSRS last month first day
SSRS Report Manager
SSRS report type
SSRS reports
SSRS shared data sources
SSRS Shared Schedule
SSRS snapshot
SSRS start date of month
SSRS subscription execution
SSRS Subscriptions
SSRS Subscriptions execution
SSRS Tutorial
SSRS Tutorial Videos
SSRS Tutorials
SSRS Videos
SSS reporting tutorial videos
start date of week sql
Statistics & Analytics Using R Tool
String function in SSIS
String Functions
Sub Query
Sub Report
Subscription example in SSRS
Subscriptions in SSRS
SUBSTR
Switch in SSRS
T-SQL real time scenarios
Table variable
table variable vs temp tables
Tableau
Tableau - Create Custom Color Palettes
Tableau Data
Tableau data integration
Tableau developer
tableau development
Tableau Filters
Tableau interview questions
Tableau interview questions and answers for experienced professionals. tableau interview questions
tableau interview questions for experienced professionals
Tableau parameters
Tableau tutorial
Temp table
temp table vs table variable
Timezone changes in SQL server
traverse database in sql server
Traverse multiple database servers
Traverse through multiple databases in SQL Server
trigger subscription manually
Trigger subscription through SQL query
tutorial Tableau Joining
types of SSRS report
types of SSRS reports
Types of subscription
types of temp table
UDF
upload excel data into SQL Server table
upload excel data into SQL table
use of filtered index
Use of Format function in SQL server
use of report server tables
use of sys table to find table and column
User defined functions
View and CTE
Visualization
way to remove duplicates record in SQL server
Week begin Date in SQL
Week End Date
Week End Day in SQL Server
Week Start Date in SQL
what is correlated sub query
What is infopath forms
what is MS BI
what is noncorrelated sub query
what is shared data source in SSRS
what is shared schedule
What is SSRS Subscription

Report Abuse

Translate

Total Pageviews

Simple theme. Powered by Blogger.