Exist Return Values

Hi ,

I like to use a variable to store the return values (True / False) of the
exists statement. How can I do that ? I unable to do that from my query show
below

declare @bln
set @bnl = Select Distinct Cust_Id,Cust_Name From Temp_Customer
Where Not Exists
(Select Cust_Id,Cust_Name From MyDb.dbo.Customer
Where MyDb.dbo.Customer .Cust_Id = Temp_Customer.Cust_Id)

Please Help ..

--
Travis Tan
.

Relevant Pages

  • Re: Relational Tables plus some
    ... A Mail Merge can - and should - be based on a Query. ... necessary, nor desirable, nor good design, to store this calculated ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • RE: Maximum Length Issue
    ... > I perform the query show below to find the duplicate records within the ... > Travis Tan ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Maximum Length Issue
    ... I perform the query show below to find the duplicate records within the ... Travis Tan ... Prev by Date: ...
    (microsoft.public.sqlserver.mseq)
  • Re: Update table using Total Query
    ... Why would you need to store this in a table? ... > I have a total query that I would like to update table fields with. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: English to Metric Update Query
    ... Next time only store one and use factor in a query when you need the results ... "sonofroy" wrote: ... Prev by Date: ...
    (microsoft.public.access.queries)