I made a slight change to your code:

DECLARE @I INT = 0;

WHILE @I <[highlight="#ffff11"]=[/highlight] 10

BEGIN

IF @I%2 = 0

IF TAN(@I) > 0

...

OK, thank you!

Doesn't it matter if the OrderDT is indexed or not when used in filter?

Thanks Chuck for clarifying!

I agree with your statement:

it really needs to also be in the SELECT clause, and so that gives you some consistency in your predicates and the...

I couldn't understand what exactly would be the use of the following code in real world? :unsure:

SELECT *

FROM MyOrder

WHERE CASE YEAR(OrderDT)

WHEN 2014 THEN 'Year 1'

WHEN 2013 THEN 'Year 2'

WHEN 2012...

Upon my execution of Listing 12, I got the following results. So, I am not sure if I should agree with of using a JOIN is same as Subquery.

(1076 row(s)...

Could someone shed more light on the following code? What kind of scenario can this be used in a real world?

SELECT TOP (SELECT TOP 1 OrderQty

...

The topic belongs to both the sections. So,...

noeld (6/29/2005)

I don't know Pervasive DB either but I am pretty sure that the cast Construct is a MS proprietary thing. You should find out what are the functions used...