I encountered another new format:  MMYY.   (w/ a period as the 5th byte)  The actual data value in the column is "1101."  Can you help me format this one?  I've...

Just found my problem.  It works ok for some of the MM/YY values and doesn't work for others.  (probably the internal hex representation varies though the display looks like MM/YY)...

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