Database

Declare @c_cmd VARCHAR(255),@C_940IN_FILE varchar(100),@C_940IN_DIR varchar(100)<br />
<br />
Set @C_940IN_FILE ='S_outbound.xml'<br />
Set @C_940IN_DIR ='\\xceed\tech\'<br />
<br />
 CREATE TABLE #TEMP_940    <br />
 (    <br />
  ROWDATA varchar(8000) Null    <br />
 )    <br />
   <br />
 SELECT @c_cmd='BULK INSERT #TEMP_940 FROM '+'''' + @C_940IN_DIR + '\' + @C_940IN_FILE + ''''    <br />
   + ' WITH (FIELDTERMINATOR = ''><'')'    <br />
 PRINT @c_cmd    <br />
 EXEC(@c_cmd)    <br />
-----------------------    <br />
 select * from #TEMP_940  <br />
<br />
Drop Table #TEMP_940

   <Case_Dimension><br />
<br />
    <unit_of_measure>PK</unit_of_measure><br />
<br />
    <quantity>6</quantity><br />
<br />
    <unit_length/><br />
<br />
    <unit_width/><br />
<br />
    <unit_height/><br />
<br />
    <dimension_measure>CM</dimension_measure><br />
<br />
   </Case_Dimension>

<br />
unit_of_measure     quantity ...  ....  .... so on<br />
---------------     --------<br />
______PK_______     ___6____ ...  ...  ....<br />

CREATE PROCEDURE [dbo].[CountUniqueBirthdays] 
	@PersonID bigint
AS
 

BEGIN

SET NOCOUNT ON;
    
DECLARE @CalendarDaysToSearch int

SET @CalendarDaysToSearch = 90 


	SELECT  COUNT(DISTINCT o.Birthdays) 
		FROM
			[MYDATABASE].[dbo].[PersonInfo] n,
			[MYDATABASE].[dbo].[PersonInfo] o
		WHERE
			n.PersonID = @PersonID AND
			--n.PersonID <> o.PersonID AND

			-- all leads with...
			n.KeyPerson=o.KeyPersonAND
			
			-- within X days of current lead
			o.CalendarDate between dateadd(dd, (-1 * @CalendarDaysToSearch ), n.CalendarDate ) and dateadd(dd, 0, n.CalendarDate ) 

END

            <br />
try<br />
{<br />
                Console.WriteLine("Querying the MYDATABASE.dbo.PersonInfo table...Please wait.");<br />
                MYDATABASEDataSetTableAdapters.PersonInfoTableAdapter adapter =<br />
                    new MYDATABASEDataSetTableAdapters.PersonInfoTableAdapter();<br />
                MYDATABASEDataSet.PersonInfoDataTable table =<br />
                    adapter.GetData();<br />
                Console.WriteLine("Finished getting data.");<br />
<br />
                Console.WriteLine("Running the CountUniqueBirthdays stored procdure.  Searching for return values > 1...");<br />
                foreach (MYDATABASEDataSet.PersonInfoRow row in table.Rows)<br />
                {<br />
                    // Get the LeadId value<br />
                    long? personID = row.PersonId;<br />
                    if (!personID.HasValue)<br />
                        continue;<br />
<br />
                    Console.WriteLine("Checking output of CountUniqueBirthdays for PersonId = {0}...", leadID);<br />
<br />
                    // Pass the LeadId to the stored procedure<br />
                    long? value = adapter.CountUniqueBirthdays(leadID);<br />
                    if (value.HasValue) {<br />
                        if (value.Value > 1)<br />
                        {<br />
                            Console.WriteLine("Value > 1 found for return from LQSCountVendor190Days...for <br />
                              leadId = {0}",leadID);<br />
                            break;<br />
                        }<br />
                    }<br />
                }<br />
            }<br />
            catch (Exception e)<br />
            {<br />
                Console.WriteLine(e.Message);<br />
                return;<br />
            }

<br />
Querying the MYDATABASE.dbo.PersonInfo table...Please wait.<br />
Finished getting data.<br />
Running the CountUniqueBirthdays stored procdure.  Searching for return values > 1...<br />
Checking output of CountUniqueBirthdays for PersonId = 8752702...<br />
Specified cast is not valid.