Will do

What tool can you recommend I use to do a recompile?

I have not been able to get 'Merg Join' to work

I would like my results to just display only the applications with a specific business area...so I wish to query both tables and just get those results

thanks I am looking into Books online...but my question is why is the script looping through the tables? 😉

Excuse me,

Here is what I have so far...

SELECT distinct [table1].Application_name, [table2].Application_Vendor

FROM [table1] INNER JOIN

...

Thanks for all your assistances

How come I can not use update instead of create. I do not wish to create a new table, I just want to update the column?

The rows get added manually the numbers get added manually...

Yes it is the only way to identify the rows...this is to avoid any dups...

Sample data provided each entry represents a column I just want to change the data in...

I will try to oblige:

The column is called Unique_Identifier. the data is just numbers 1,2,3,4, etc...My problem is if I delete any row then my numbers in that column gets...

I am looking for a way to update the row count through a script 😀

I must be missing something in your explanation. But I tried Insert, Update, and now Order By as you recommended but I get nothing but syntax errors when I run...

the script does not count down the column and insert the correct numerical number. Let me explain in detail

I have nine columns and 1164 rows.

One of the columns is...

Will that work if you do not have a primary ket set; cause I only have one table?

Msg 1919, Level 16, State 1, Line 1

Column 'Application_Name' in table 'Vista Application Compatibility' is of a type that is invalid for use as a key column in an index.

Msg...