Database

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.

  SELECT C.Table_Name ,
         C.Column_ID ,
         C.Column_Name ,
         C.Data_Type,
         C.char_length      
    FROM    ALL_TAB_COLUMNS C        
   WHERE C.TABLE_NAME = 'CURRENCY'
ORDER BY C.column_ID