Amazingly, SQL Query Processor performs a Cartesian product (a cross join, or an unrestricted join) between the first two tables that appear in the FROM clause, and as a result,...

This is an excerpt taken from BOL:

Shared memory is the simplest protocol to use and has no configurable settings. Because clients using the shared memory protocol can only connect to...

Here is the post that uses cross joins

Hey, haven't you seen my above post?

Then just remove it from the select list & add the aggregate to order by clause..

SELECTTOP 1 WITH TIES t.teacher_id

FROM@teachers t

LEFT JOIN @students s on t.teacher_id = s.teacher_id

GROUP BY t.teacher_id

ORDER...

This is because you might have created the login with windows policies enforced on it. You need to disable the enforce password policy in login user properties.

Is this what you're looking for?

SELECTTOP 1 WITH TIES t.teacher_id, COUNT( s.teacher_id ) AS NoOfStudents

FROM@teachers t

LEFT JOIN @students s on t.teacher_id = s.teacher_id

GROUP BY t.teacher_id

ORDER BY NoOfStudents

It would be better, if you could post your code with the results you want, rather we working blindly thinking something else:cool:

I'll go for option B..., makes sense querying a date directly rather than concatenating integers to make a date then query it!!!!

Thanks Andras, for explaining what you meant earlier.:)

I still couldn't understand what you're trying to point...:unsure:

Multiplying the value gives me 3032, whereas I get 12 when divided...

I am curious to know, how the said value can be...

Is the SET option defined at the PROCEDURE level?

Well, you need to interchange * with /

You are right, (I probably need to sleep more)

You'll surely need...:D

Hey Andras, are u sure that will give what you said....

SELECT RTRIM( LTRIM( SomeColumn ) ) FROM SomeTable