Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

Subscribe to my newsletter and never miss my upcoming articles

How to search for a list of words contains in a string column?

Aug 1, 20221 min read 5 views

To search whether the list of words contains in a column, you can implement it using a series of conditions with LIKE and OR operators. But to search...

How to split a string into a list of values

Jul 31, 20221 min read 10 views

Convert a string to list of values in table with one column · I have created a function to split a string based on the delimiter value and return the...

How to undo the last git commit in local repository?

Jul 28, 20221 min read 5 views

Undo last local commit but keep files changes. git reset HEAD~1 All the changes committed in the last commit is present in the local repo. Changes...

SQL Replication - Post Tracer Token error due to no active subscriptions

Jul 12, 20221 min read 9 views

No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. · I was trying to get all the SQL...

How to replace the first instance of the string in T-SQL?

Jul 6, 20221 min read 11 views

You can use the combination of stuff, charindex and len function to replace the first occurrence of the string. declare @database_name...

How to find customers who never placed an order in SQL?

Jun 22, 20222 min read 7 views

SQL interview questions and answers #12 · Write a SQL query to find the list of customers who never placed an order. There are two...

How to find customers who never placed an order in SQL?