You can accomplish that by adding a COMPUTED column and then sorting on that i.e. COL4 with a DEFAULT VALUE of Col1 + Col2 + Col3 and then ORDER BY...

ASSUMPTION:  ID = IDENTITY.

Just run INSERT INTO Table2 ([Name], Address) SELECT ([Name], Address) FROM Table1

Parent_ID will need to be manually recreated (I am thinking)....

Sounds like the problem is that once you created/restored to SQL 2K5 it changed the database version to 9.0 (SQL 2K5).  You will need to restore to SQL 2K5 change...

IF you are attempting to do something like the following it wont work:

1.  Setup a PC that is NOT on the network

2.  Attempt to install SQL using DOMAIN\USERID (doesn't exist...

Why not have a MAIN stored-procedure that calls the SP's that BCP thge data out to the 563 various Excel files as 1 step and then the next step could...

What problems are you having?

Unless you have this information stored inside SQL (out of the box it isn't there) you won't be able to find it.  HOWEVER, I am sure that someone can help...

Why not produce All the reports needed first and THEN mail out the reports to the proper recipients?  No looping required ....

I know that there are more elegant ways of doing this but how about creating a loop for the tblState table that will look for stateName in States and then...

How many columns are in your @ReverseFields?  I think you would need to set each individually = to COUNT (if there is more than 1 column)....

Look at the DDL of the tables.  One of the columns you are attempting to join on has a different COLLATION then the others.  This is causing the problem.  2...

I would look at the table definitions of Ops_Narr and ensure that BOTH columns are either CHAR with the SAME COLLATION or INTEGER (SANS Collation).

Looks like you are either having...

You will have to put the columns back together in a dateformat to search like that along with the MM/YYYY you are looking for i.e.

WHERE MM/01/YYYY BETWEEN MM1 + '/01/'...

We test, test, test and do more testing prior to installing patches.  We have several machines in our lab set-up specifically for this purpose.

How bout something like

DECLARE @val DECIMAL(8, 0)

DECLARE @Table TABLE

(FirstHalf  DECIMAL(4, 0),

 SecondHalf DECIMAL(4, 0))

SET NOCOUNT ON

SET     @val = 10005555

INSERT INTO @Table (FirstHalf, SecondHalf)

SELECT LEFT(@Val, 4) FirstHalf, RIGHT(@Val,...