January 16, 2014 at 2:50 am
I have to get the query for data in an column and delete if the data exists
My data is
COLUMNA
-------------
(Location is Asia and Location is Africa) and (Manager Name Kumar and Manager Name Kannan)
(Manager Name Selvam and Manager Name Robert) and (Location is Europe and Location is America)
(Manager Name Kumar and Manager Name Kannan)
Expected Result
(Manager Name Kumar and Manager Name Kannan)
(Manager Name Selvam and Manager Name Robert)
(Manager Name Kumar and Manager Name Kannan)
Need SQL Query to remove values staring from **(Location** and ends with **)**
January 16, 2014 at 7:52 am
Shanmuga Raj (1/16/2014)
I have to get the query for data in an column and delete if the data existsMy data is
COLUMNA
-------------
(Location is Asia and Location is Africa) and (Manager Name Kumar and Manager Name Kannan)
(Manager Name Selvam and Manager Name Robert) and (Location is Europe and Location is America)
(Manager Name Kumar and Manager Name Kannan)
Expected Result
(Manager Name Kumar and Manager Name Kannan)
(Manager Name Selvam and Manager Name Robert)
(Manager Name Kumar and Manager Name Kannan)
Need SQL Query to remove values staring from **(Location** and ends with **)**
It appears that you came here looking for some help with an issue in sql server. Unfortunately you did not provide any information. In order to help we will need a few things:
1. Sample DDL in the form of CREATE TABLE statements
2. Sample data in the form of INSERT INTO statements
3. Expected results based on the sample data
Please take a few minutes and read the first article in my signature for best practices when posting questions.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply