I have a list of records (Church Dioceses) in which I would like to pull information into a gridview.
There's 12 priest per diocese but only about 3 are "primary". I need to show only the 3 primaries and I'm unable to figure it out. Any help would do.
Here is my code: SELECT [Contact_ID], [First_Name], [Last_Name], [IsPrimary] FROM [Contacts] WHERE (([IsPrimary] = @IsPrimary) AND ([Contact_ID] = @Contact_ID)).
FYI: each diocese has it's own unique ID
What Am I doing wrong? please help I'm a newbie.
Thank You