Query using an update statement

Assignment Help Computer Engineering

Reference no: EM1329195

Here is the issue, a table namedPoints varchar(81) has values stored in a column named Point. There are two columns in the Points table, X and Y. Here is the code that created the table:
REATE TABLE dbo.POINTS (
I INT IDENTITY NOT NULL
,Point varchar(81) NOT NULL
,X decimal(38,10) NULL
,Y decimal(38,10) NULL
)
GO
INSERT dbo.POINTS (Point) VALUES ('(45.123,22.5)')
INSERT dbo.POINTS (Point) VALUES ('(7.95,3.45)')
INSERT dbo.POINTS (Point) VALUES ('(100.2,15.498)')
GO

I need a query using an UPDATE statement to populate X and Y from Point. THe data on the left side of the comma is X and on the right side of the comma is Y. I am guessing that either Substring or Charindex would beused but I am not sure.

Reference no: EM1329195

Questions Cloud

Explain progress report : Explain Progress Report and What are the global considerations for an all-inclusive resort

Supply chain for electric fans : Advantage of any global opportunities available to riordan manufacturing such as lower labor cost

Difference between encapsulation and information hiding : define the difference between encapsulation and information hiding. In addition, I need to explain the role both of these concepts play in helping to make designs more robust and extensible.

Solution to supply chain management : Solution to Supply Chain Management and Supply Chain Management identify the main issues in the chosen area, and contain and reference new learning that has occurred

Query using an update statement : Here is issue, a table namedPoints varchar(81) has values stored in a column named Point. There are two columns in the Points table, X and Y.

Does the airline industry offer attractive opportunities : Does the airline industry offer attractive opportunities for growth?

Student query- supply chain management : ABC car manufacturer is subject to caps on CO2 emissions and would like to assess whether or not it should invest in the technology necessary to make electric vehicles that would reduce the amount of CO2 produced by their vehicles.

Select which currency they wish to display : Expand the "Currency Conversion" program to have a menu of five currencies that allows the user to choose which currency they wish to show in its equivalency to the US dollars.

How are airline industry rival positioned : How are airline industry rival positioned and who is strongly positioned and who is not?

User Account

All Pages