look at this tool

http://www.red-gate.com/products/SQL_Compare/index.htm?

From Jeff's article:

Emphasis added...

I suggest...

vmrao

Your would most likely get more assistance if you posted your table definition and sample data as described in the first link of my signature block ... and with...

First Excell 2007 uses a different ODBC driver than does previous versions of OFFICE products:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Dowload and install above:

Then to call Excel use:

'Microsoft.ACE.OLEDB.12.0',

'Excel 12.0;'

Instead of:

'Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;'

Note: Not...

Decimal with a defined precision and scale works.

DECLARE @dec DECIMAL(2,1),

@float FLOAT

...

ColdCoffee

First Excell 2007 uses a different ODBC driver than does previous versions of OFFICE products:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

Download and install the above, then alter your OPENROWSET statement to:

Create the Excel workbook (Book1.xlsx) save...

If this is a one time export ... believe the following link will assist you

http://www.sql-server-performance.com/articles/biz/How_to_Export_Data_to_Excel_2007_p1.aspx

TRACEY-320982

--==Extracted segments only for Illustration purposes

DECLARE @L VARCHAR(10)

SET @L = 'Location'

CHARINDEX(@L,S) AS 'LocA',

,CHARINDEX(@L,REPLACE(S,'SITE ','SITE1')) AS 'LocB'

Please note. The parameter @L is only used to determine the position of...

DECLARE @L VARCHAR(10)

SET @L = 'Location'

SELECT id, S, CHARINDEX(@L,S) AS 'LocA', REPLACE(S,'SITE ','SITE1') aS 'Modified'

,CHARINDEX(@L,REPLACE(S,'SITE ','SITE1')) AS 'LocB'

--== notice blank (space) ^

FROM #Table

DROP TABLE #Table

/* Result:

idS...

Whoops

[

SELECT * FROM sys.all_objects ]

- will return information for all these database objects .. AGGREGATE_FUNCTION

CHECK_CONSTRAINT

DEFAULT_CONSTRAINT

FOREIGN_KEY_CONSTRAINT

PRIMARY_KEY_CONSTRAINT

SQL_STORED_PROCEDURE

CLR_STORED_PROCEDURE

SQL_SCALAR_FUNCTION

CLR_SCALAR_FUNCTION

CLR_TABLE_VALUED_FUNCTION

RULE

REPLICATION_FILTER_PROCEDURE

SYSTEM_TABLE

SYNONYM

SERVICE_QUEUE

CLR_TRIGGER

SQL_TRIGGER

SQL_INLINE_TABLE_VALUED_FUNCTION

SQL_TABLE_VALUED_FUNCTION

USER_TABLE

UNIQUE_CONSTRAINT

VIEW

EXTENDED_STORED_PROCEDURE

INTERNAL_TABLE

--------------

but as far as I know and as Lowell has stated it will not identify invalid...

Your boss ,truly, has only one recourse. Hire a contract lawyer, and consult with that individual, and then decide how to proceed.

oops

rik gretzinger

The following is just to give you an idea of how the

problem could be solved, it is NOT the fastest way,

and if your parts and subparts tables...