Need to search the eventid in the column and need to give a appropriate name
I have column called ticketdesc where it contain may information, I tried using charindex function, the problem using this function is ,I am not able to find proper start place.There are around 1 millions types of ticket description,so it's hard to analysis.
I like to have the SQL query,where it will search for a keyword of event id's alone and need to group as per the events Id's and need to give proper name.
Back up Issue	50
so on Sample-colum.txt
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008SQL
you want to loop through the information in this column and group all the entries based on keyword event id.
for instance, all the entries in the column which has the word "database" in it, group them under proper name and return it back.
is that what u mean?