Your backup, to a table in same database, is it for migration/upgrade purposes?

(If so, maybe set database to single user mode, first.)

Otherwise is it possible to use the builtin database...

The problem is the FUNCAveMile(), that is need to be run for every row in table. What does it do?

I have used Poor Man's T-SQL Formatter, in different editors, works nicely. Now I mostly use SQL Prompt, from Toolbelt in SSMS. The SQL Prompt Core, is...

the query runs for about 15 min and gives results.

And you expect 900k rows, that's gonna take a while, so you probably get a network timeout.

You could also minimize the...

At this point, I need to know how can I get SQL to recognize my current computer name (current db owner)?

The current user is:

select CurrentUser = suser_sname();

It...

How can I determine the name of the owner of the database?

select [Database] = [name], [Owner] = suser_sname(owner_sid)
from sys.databases;

Should list the databases and owners.

What is the owner of the database. There if often problem with owner and the scripts for creating the structure for diagrams. Diagrams works fine, and even if the are...

Most databases benefits to be normalized to the 3NF. Take a look of sites describing different sql normalization rules.

I'm using it to hold values obtained from the field Column, which is only 10 characters in length.

You probably what a table type holding your strings of length 10, that's...

There are some tools to create ER diagram automatically. For large databases, you probably want to use several ER diagrams.

In SSMS, you can use the diagram functionality to manually...

• This reply was modified 5 years, 6 months ago by  jonas.gunnarsson 52434.

All SSN handling/validation should be done in code, before sent to the database. Is it only one type of SSN? Else OID is needed, to define type of...

You may want to use convert
select convert(varchar(19), getdate(), 120) as [getdateoutput];

Look at insert (XML DML), there is some samples that may fit your needs.

The result is correct, use the str function, like:
select str(cast(@p1 as numeric(12, 2)) / cast(@p2 as numeric(12, 2)), 12, 2);