I tend to use upper, but either upper or lower I'm fine with as long as it is consistant. 🙂

Here is one guess. You might be able to emilenate the join between AAA and BBB, depends on your data...INSERT CCC

SELECT *

FROM

(

SELECT T2.*

FROM BBB AS B

INNER JOIN

(

SELECTB.ID, MAX(B.Date) AS MaxDate

FROM...

First you should look at: http://www.datamodel.org/NormalizationRules.html

That will give you the basics. I'm not sure if this is for a class, personal enrichment or work. But, if you plan on continuing...

I do not...

I would suggest using a trigger for a temproal constraint.

I assume you have additonal constraints for BeginDate < EndDate?

Is the column just a date or does it also include the format (mm/dd/yy)?

I wasn't sure if you were looking for all combinations of Customers that meet that percentage or just starting with the min number or.???

At anyrate, I just used a simple...

SQL has ranking functions that people use for sequence numbers (ROW_NUMBER, RANK, DENSE_RANK). But, I'm not aware of anything that allows you to specify a one PK for mutiple tables.

Do...

You cannot guarantee in what order SQL will evaluate your conditions so the CONVERT might happen before or after the ISNUMERC:WHERE id_type = 'MR'

AND isnumeric(result_value) = 1 -- Issue

AND (resulted_test_desc...

Here is another one for just for people on A and not B for a given year:SELECT

A.[Calendar year],

A.Quarter,

COUNT(*) AS Total_Patients_on_Just_A

FROM

(

SELECT *

FROM [MainTable]

WHERE [Drug name] = 'typeA'

) AS A

LEFT OUTER JOIN

(

SELECT...

If you can fix your names now you should remove the spaces. But, here ya go.

SELECT

A.[Calendar year],

A.Quarter,

COUNT(*) AS Total_Patients_on_Aand_B

FROM

(

SELECT *

FROM [Main Table]

WHERE [Drug name] = 'typeA'

) AS A

INNER JOIN

(

SELECT *

FROM...

To build on what Grant and others have said. Exchanges are, in general, more expensive. Since we are talking in a SQL forum, I'll assume that you mean as it...

If you are interested in a set-based solution you might try giving us DDL, sample data and expected output in addition explaining what you are actually trying to do.

I'm not...

Here is an article writen by Peso that compares several methods:

http://weblogs.sqlteam.com/peterl/archive/2009/06/12/Timings-of-different-techniques-for-finding-missing-records.aspx

Left and Left Outer are the same thing. OUTER is optional.