SQL create a delimited string from a flat file
Recently I wrote a post on how to split a delimited string in SQL. Now I need to do the reverse and take the flat …
Recently I wrote a post on how to split a delimited string in SQL. Now I need to do the reverse and take the flat …
Ever need to split a delimited string in SQL, creating new records? For example you could have a table called Users: Country User UK Bob|Fred|Bill …
This article describes how to remove the carriage returns and line feeds in SQL, Tableau, Excel and Access. If you ever have to deal with …
Use a Tableau URL action to link Tableau to SSRS, enabling users to click through from Tableau to SSRS. Passing parameters into the URL even …
To label the row number in SQL there’s a useful SQL function you need to know about: ROW_NUMBER() As the name suggests, it numbers all …
There are a few ways to remove the time from a datetime in SQL. This article describes two of them. I am deliberately ignoring ways …