how to separate string into different columns?

by

Instead of using split function there is a function called ParseName which returns the specified part of the object which spilts the string delimated by .
Please go through the ParseName link which helped me in writing this query

Declare @Sample Table
(MachineName varchar(max))

Insert into @Sample
values 
('Ab bb zecos'),('a Zeng')


  SELECT 
  Reverse(ParseName(Replace(Reverse(MachineName), ' ', '.'), 1)) As [M1]
 , Reverse(ParseName(Replace(Reverse(MachineName), ' ', '.'), 2)) As [M2]
 , Reverse(ParseName(Replace(Reverse(MachineName), ' ', '.'), 3)) As [M3]

  FROM  (Select MachineName from @Sample
  ) As [x]

More Related Contents:

  1. How to delete 0 values but not blanks from a column in SQL Server 2008 programming?
  2. Unpivot with column name
  3. How can I delete using INNER JOIN with SQL Server?
  4. Is there a way to access the “previous row” value in a SELECT statement?
  5. What this query does to create comma delimited list SQL Server?
  6. SQL Server – Return value after INSERT
  7. Convert varchar into datetime in SQL Server
  8. sql query to return differences between two tables
  9. Check if a row exists, otherwise insert
  10. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  11. SQL Server : dynamic pivot over 5 columns
  12. How to select the last record of a table in SQL?
  13. How to create table using select query in SQL Server?
  14. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  15. How to write UPDATE SQL with Table alias in SQL Server 2008?
  16. SQL Server 2008- Get table constraints
  17. SQL SERVER: Get total days between two dates
  18. Restrict an SQL Server connection to a specific IP address
  19. Execute Dynamic Query with go in sql
  20. TransactSQL to run another TransactSQL script
  21. How can I get a list of element names from an XML value in SQL Server
  22. Why are logical reads for windowed aggregate functions so high?
  23. Store multiple bit values in a single table column
  24. How to rename something in SQL Server that has square brackets in the name?
  25. Comma Separated values with SQL Query
  26. UPDATE and REPLACE part of a string
  27. Improve SQL Server query performance on large tables
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. Cumulative Total in MS Sql server [duplicate]
  30. Editing Record issues in Access / SQL (Write Conflict)

Leave a Comment