Convert Provider Number type from ntext to nvarchar

[bzswords]

So you can't do a SQL join on ntext columns because they do no support the = operator. We need to convert all Provider Number columns that are ntext in type to nvarchar because joining is a necessity for what we are trying to do.

http://stackoverflow.com/questions/18789810/how-can-i-easily-convert-all-ntext-fields-to-nvarcharmax-in-sql-query

[bzswords]

Converted Provider Number column in dbo.dbo_vwHQI_HOSP and dbo.dbo_vwHQI_HOSP_GEOCODES to nvarchar. Removed leading and trailing single quotes from dbo.dbo_vwHQI_HOSP. Will push SQL statements that successfully completed these tasks to repo in case we need them again