Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Blog Author Picture

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 replace the first instance of the string in T-SQL?

Jul 6, 20221 min read

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

How to concatenate multiple rows into a single string in SQL?
How to de-group the data in SQL?