Eric - Thanks for the SSIS tip. That will make it much easier to capture the handful of records without a match as opposed to joining across tables manually.

We haven't created a client table of correct, distinct values yet. I'm thinking initially we will have to go through those 300k records to find any variations and then...

This is a new process so we haven't really taken a close look at the data at this point. I can't put a number on it but would venture...

Thanks for all the help! It sounds like I might have to maintain a table with the correct name and create a list of all of the incorrect names...

Thanks! That seems like exactly what I have going on. I'll play around with a few things and probably take a look at the recompile query option since...

The suggestion was made to help improve security since, you know, no one has ever been able to access an environment not using port 1433 :laugh:

The logs look pretty similar when the service fails to start with the exception of the port

2016-06-22 09:12:27.12 Server Microsoft SQL Server 2014 (SP1-CU6) (KB3144524)...

I appreciate all of the help, John! 1433 works just fine so I went back to that to at least have the instance running. The NETBIOS is the...

2016-06-22 09:03:03.26 Server Microsoft SQL Server 2014 (SP1-CU6) (KB3144524) - 12.0.4449.0 (X64)

Apr 13 2016 12:41:07

Copyright (c) Microsoft Corporation

Enterprise Edition: Core-based Licensing (64-bit) on...

John - Correct, SQL Server is not starting as well. I don't see anything in the SQL Server errorlog that shows any errors and it even indicates that it...

I've tried that as well. That's what I do when I get the error message

"The request failed or the service did not respond in a timely fashion. Consult...

Sorry for the delayed response. I'm not seeing anything in those four files that show some kind of error and none have the timestamp of when I tried to...

The error I get in SSCM is "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs...

Luis/Lowell,

Thanks for all of the information. The web developers requested the float data type. It sounds like I'll need to talk to them about the shortcomings of the...

I probably phrased my original question incorrectly. Is there a way to display the value as 0.00004 instead of 4E-05 while still casting it as a float?