Dave,

You are indeed getting it wrong.:hehe:

You're confusing Foreign Keys with Indexes.

Read up on BOL on these topics and ask more questions after that. 🙂

And indexes are "pointers" to the physical location of the data. Think of them as floating on another layer or more appropriately as the index in the back of a...

Your question isn't clear to me.

Is Billing type supposed to result in 'Express Cash' or 'Payment Services'?

I mean you can

SELECT

CASE WHEN PROD = 'XCDD' AND...

Can you give us some sample data from t_Prod, 1,2 and 3? as well as some sample results?

AND

.... The latest is full text searches stopped working when we replace the SQL service account with a non-local administrative account....

If I understand you correctly, add a "dummy" parameter to the dataset that you're using for #2 that will come up if that particular parameter from #1 is selected.

EDITED: Incorrectly used INNER join when LEFT is appropriate.

Matt's suggestion OR use the left join method ...

FROM

....

...

"Books Online" It can be found

Start > Programs > Microsoft SQL Server 2005 > Documentation and Tutorials > SQL Server 2005 Books Online

Read up on the PIVOT keyword in BOL or search this site. There are plenty of examples around. 😉

Please read ... http://www.sqlservercentral.com/articles/Best+Practices/61537/ ... and repost your question. 😀

This also seems like a homework question. What have you tried already?

I fully understand joins, but I'm just not familiar with the older syntax (non-ANSI) standard use of them.

I've ran tests and it seems to be correct, I just wanted clarification...

Thanks!

Homework?

Read up on HAVING in BOL.

What's your table definition, what keys/indexes are on it now?

Can you provide examples of the queries ran against it currently?

Read up on PIVOT and UNPIVOT in BOL. The answer is in there. 🙂