What you need to do is modify my Union query by adding a simple "Not In" for the contra-rule. That will exclude the options that are tied to options that...

Sorry GSquared, but the query results are incorrect.

I'll go Donation by donation:

Assuming that Patient is Male (PrefID = 1), Location is America (PrefID=5), Age Between 21-10 (PrefID=3) and is Muslim...

Sorry if there is still ambiguity.

And you are right. If some onne donated for religion that is not followed by the patient, He is NOT eligible. Even if he meets...

Lets take the business process.

We are designing a Donation System.

1) Now, Donor Donates $100 for Patients with gender=Males and Age between 20-30.

This makes one donations.

2) Now we have a...

Patient Preferences are generated through the biodata of the patient in the system. Overe here, it could be assumed as stated in the Scenario.

DonationID 1 ,3 and 4 are valid for first Scenario.

Its because DonationID 1 is for PrefID 1 (Male) and PrefID 3 (Age between 21-30). Patient PrefIDs have PrefID 1 and...

Patient with Preference like

Male ( PrefID=1)

Location America (PrefID=5)

Religion Muslim (PrefID=8)

Age between 25 (PrefID=3)

Here is the explanation;

The above condition means All the DonationIDs are valid if PrefID 1,5,8,3

are...

Please Add the following record for DonationID 3 in vDonationPreferences

Select 3,8

Thanks

It seems quite simple. But I have been struggling with this for 4 hours.

I need a query to get the valid donations as discussed in the code.

Try using Left Outer Join with all tables according their fields with Distinct Clause...

Dynamic Query will be helpful...

Declare @vSQL varchar(1000)

Declare @VarName varchar(1000)

Set @VarName = 'RED'

Set @vSQL = 'select col1,col2 from [Table]

where col3 ' + case when @VarName = 'RED' then ' =...

In simple language, Service Broker is a technology that can transfer your message / data .

SQL Server Service Broker offers the functionality of Asynchronous messaging. SQL Server, at its own...

What to say...?

SQL Agent is installed with SQL Server 2008 Express but cannot be started.

So the creation of job is meaning less if you cannot execute it.

Lost my point....

Is tillReceiptnumber Unique troughout the table?

Can you please post some test data? It would be very helpful.

Ya. I have checked TOAD fro SQL Server.

Thanks for the reply.