Re: Comparing a pair

ok, will try. thanks

"David Portas" wrote:

> TSQL doesn't have row-value constructors. But EXISTS is often a better way
> than using IN anyway:
>
> SELECT *
> FROM Foo
> WHERE EXISTS
> (SELECT *
> FROM Bar
> WHERE bar.manager_id = foo.manager_id
> AND bar.dept_id = foo.dept_id)
>
> --
> David Portas
> SQL Server MVP
> --
>
>
>
.

Relevant Pages

  • RE: INTERSECT not supported on SQL Server???
    ... The INTERSECT keyword isn't supported in TSQL. ... Usually you can do the same thing with an INNER JOIN: ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: How to lock only one row
    ... like this (in TSQL): ... DELETE FROM MDC7 ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: how can i set a columns default value to todays date?
    ... TSQL gives you more control and lets you do many things that are ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: Query question?
    ... Better specs would help us with future questions. ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • Re: SQL 2000, SP3a "TOP 100%"
    ... The best place to use ORDER BY is when you query the view. ... David Portas ... SQL Server MVP ... Prev by Date: ...
    (microsoft.public.sqlserver)