Converting data type in MS SQL table from NVARCHAR TO BIGINT

Question

I am very new to MS SQL server. After importing a table into MS SQL I noticed that it changed the data type from a number to NVARCHAR, null. I have been on line practically all day trying recommended fixes that fall into two categories. The first is use alter, cast, etc. The second is adding a new column, that I called EXPENSE, with the bigint data type and copying and pasting the values from the old column called Value. Neither has worked. Here is the design of my table.

SELECT TOP (1000) [prvdr_num]

      ,[hosp_name_hcr]

      ,[state_abbreviation]

      ,[health_sys_id]

      ,[health_sys_name]

      ,[health_sys_city]

      ,[health_sys_state]

      ,[ffy]

      ,[Attribute]

      ,[Value]

      ,[EXPENSE]

Thank you for taking the time to read and respond to this request.

Answer 1

Hi,

My name is Igor, I have 12 Microsoft MVP awards. It's a pleasure for me to help others and I'll do all my best to help you. I'm sorry you have a problems.

Server related questions it is more effective to ask at Q&A forum https://docs.microsoft.com/en-us/answers/index....

It is oriented to admins and corporate users, and this forum - to home users so local experts may have no corresponding knowledge, sorry.

Answer 2

Thank you for responding. Will post on suggested site.