Comma Separated values to multiple rows | string_split() | SQL Interview Q&A | CROSS APPLY
*****************************************************************************
-- 22 - STRING_SPLIT() - Comma Separated values to multiple rows
--*****************************************************************************
DROP TABLE Employees
CREATE TABLE Employees (Empid INT, ID Varchar(150))
INSERT Employees VALUES (1, '2,3,4,5,6')
INSERT Employees VALUES (2, '7,8,9,10,11')
select * From Employees
select * From Employees CROSS APPLY string_split(id,',')
SELECT Empid, Value FROM Employees CROSS APPLY string_split(ID,',')
Video 21: Comma Separated values in SQL | XML PATH | SQL to XML Format | Row Tag| Root Tag | SQL Interview Q&A
• Comma Separated values in SQL | XML P...
Blog: https://sqlwithravimartha.blogspot.com/
Facebook Pages:
/ sql-with-ravimartha-109497027391239
/ etl-dwh-testing-100494175057349
This channel (SQL With RaviMartha) would provide new videos on SQL, ETL and Data warehouse concepts. I would create a separate play list for SQL Tutorials for beginners, advanced concepts, Interview questions and data warehousing concepts
Feel free to drop me an email at sql.ravimartha@gmail.com in case of any queries you have in SQL or clarifications on the videos I have done :)
Blog: https://sqlwithravimartha.blogspot.co...
Video 12: Import Tables from one Server to another Using SSMS | Import tables using SQL Query in SSMS --* • Import Tables from one Server to anot...
Blog: https://sqlwithravimartha.blogspot.co...
Video 11: Table Variables in SQL Server | Pound Tables | Table Variable in SQL | Table Variable in Tempdb --* • Table Variables in SQL Server | Pound...
Blog: https://sqlwithravimartha.blogspot.co...
Video 10: Quick Practical onTemporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table--* • Quick Practical on Temporary tables i...
Blog: https://sqlwithravimartha.blogspot.co...
Video 9: Temporary tables in SQL Server | Temp Tables in SQL | Local Temp Table | Global Temp Table -- * • Temporary tables in SQL Server | Temp...
Blog: https://sqlwithravimartha.blogspot.co...
Video 8: Running total & Avg in SQL | Cumulative Sum & Avg in SQL | Calculating running total & Avg in SQL -- * • Running total & Avg in SQL | Cumulati...
https://sqlwithravimartha.blogspot.co...
Video 7 Title: Length Vs DataLength Vs ColumnLength | Len() | DataLength() | Col_Length | Column length in SQL -- * • Length Vs DataLength Vs ColumnLength ...
https://sqlwithravimartha.blogspot.co...
Video 6 Title: Tricky CASE Statement Interview Questions | CASE WHEN | WHEN Clause | CASE Statement in SQL -- * • Tricky CASE Statement Interview Quest...
https://sqlwithravimartha.blogspot.co...
Video 5 Title: Delete Duplicates in SQL by retaining one Unique record | Row Duplicates | Business Key Duplicates -- * • Delete Duplicates in SQL by retaining...
https://sqlwithravimartha.blogspot.co...
Video 4 Title: Difference between TRUNCATE, DELETE and DROP -- * • Difference between TRUNCATE, DELETE a...
https://sqlwithravimartha.blogspot.co...
Video 3 Title: Sorting in SQL | Order By | Conditional Sorting| Unusual Sorting -- * • Sorting in SQL | Order By | Condition...
https://sqlwithravimartha.blogspot.co...
Video 2 Title: Difference between Primary Key and Unique Key -- * • Difference between Primary Key and Un...
https://sqlwithravimartha.blogspot.co...
Video 1 Title: Logical Processing of SELECT Statement -- * • Logical Processing of SELECT Statemen...
https://sqlwithravimartha.blogspot.co...
Youtube Channel:
/ @sqlwithravimartha6357
On this page of the site you can watch the video online Comma Separated values to multiple rows | string_split() | SQL Interview Q&A | CROSS APPLY with a duration of hours minute second in good quality, which was uploaded by the user SQL With RaviMartha 09 January 2021, share the link with friends and acquaintances, this video has already been watched 19,833 times on youtube and it was liked by 225 viewers. Enjoy your viewing!
