Hi - your attached SQL works appropriately for everything except those nvarchar(10) values in the format MM/YY.  Example:  10/02 is not being formatted ! 

thx

thx - all is working well!

Thanks!  This appears to be working!  MUCH Appreciated David.

Now I need data, in the varied formats - converted to the static target columns:

CCExpMonth  INT  NOT NULL,

CCExpYear   INT  NOT NULL

Examples:

02/2005 needs 02 stored...

Yes, this is then entire list of unique formats.  This is a legacy system w/ no new info being added.  THX

THANKS!  The SUM(ABS(CORRECT) worked fine.  Much appreciated!

Thanks!  Much appreciated.

some says I am

    some says I ain't

        Jerry Garcia / Bob Weir!!! 

select SUSER_SNAME()

I have a stored proc called BusinessRules_Common_ApplicationStatusArrayList_readarray as follows:

ALTER PROCEDURE dbo.BusinessRules_Common_ApplicationStatusArrayList_readarray

@StatusID int ,

@DateOpened datetime =NULL,

@DateSubmitted datetime =NULL,

@DatePendingNotification datetime =NULL

AS

SET NOCOUNT ON

SELECT TOP 10000

ID,

PersonID

FROM

CW_Applications

WHERE

StatusID = @StatusID AND

DateOpened <=...

Frank - my sentiments exactly! (regarding the reinventing of the wheel) -- We have a "chief" architect insisting that we generate an .MSI install script -- to do so, he...

Thanks for the infor so far -- I have 2 queries attached here.  My goal:  Using a source SQL 2K DB as input, generate a SQL script containing DDL...

select OrderNumber, EmailAddress, count(EmailAddress)

 from your_table

  group by OrderNumber, EmailAddress

   having count(EmailAddress) > 1

Noel / Ron- perfect.  Your solution just got me over an 8 hour hump!!!   Can I offer you a Philly Cheese Steak??? 

thanks a million!

bt

I tried your recommendation and it failed w/ the following error message:

The charindex function requires 2 to 3 arguments.

update STAGEtblCSComponentParsed

 set Type_1    = left(AddrInstr,1),

     Type_1_ID = cast(substring(AddrInstr,2,3-charindex(';',AddrInstr,3)) as int),

     Type_2   ...