I would go for

select OrderId from OrderDetails where ProductId=1
intersect
select OrderId from OrderDetails where ProductId=2;

... and did those 124 who gave the correct answer get their point after all?

Hi!

What is the data type of Ratio? If it is "int" and between 0 and 100 the result of the division will always be 0. Try and replace "Ratio/100" by...

The name of getdate() is somewhat misleading as it returns datetime. For your WHERE clause to work you will have to replace getdate() by cast(getdate() as date).

Just to get you started: have look at the DATEADD function (http://msdn.microsoft.com/de-de/library/ms186819.aspx).

You can make use of the fact that 0 corresponds to 01-01-1900.

A final hint: The last day of the...

Is this what you are looking for

select MONTH(bill_date), YEAR(bill_date),SUM(travel),SUM(fixed),SUM(food),SUM(lodge)

from dbo.expense

group by MONTH(bill_date), YEAR(bill_date)

order by MONTH(bill_date), YEAR(bill_date)

Difficult to know if that's what you want as your sample data don't seem to...

Hi,

In your second 'SELECT ...' the comma after the NULL is missing.

The answer is only correct is ANSI_NULLS is ON. With ANSI_NULLS off one obtains 2,4,5.

Hi, mickyT!

Your method only works if the number of rows is a multiple of 5. Try and remove the ('J',1) and your bottom 20 per cent has only one record.

The error is in the three updates: You can't use an alias for the expression on the right-hand side of the '='.

In this case you can use "distinct":

update R

set Mask=(select sum(distinct POWER(@Big2, D.Dept)) from @Depts D where D.CustomerNum = R.CustomerNum)

from @Result R

Bitwise ORing powers of 2 is just like adding them. You can try this:

update R

set Mask=(select sum(POWER(@Big2, D.Dept)) from @Depts D where D.CustomerNum = R.CustomerNum)

from @Result R