except keyword

hi,
how do i use except with my result sets.
any example please.
kalaivananHave you read this article in the BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b1019300-171a-4a1a-854f-e1e751de3565.htm
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> hi,
> how do i use except with my result sets.
> any example please.
> kalaivanan
>|||the link did not works.
may i have the link once again please.
kalaivanan
Uri Dimant wrote:
> Have you read this article in the BOL
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b1019300-171a-4a1a-854f-e1e751de3565.htm
>
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> > hi,
> > how do i use except with my result sets.
> > any example please.
> >
> > kalaivanan
> >|||Open BOL and click on search tab. Type "except" and click ok
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1163673132.167142.306460@.m7g2000cwm.googlegroups.com...
> the link did not works.
> may i have the link once again please.
> kalaivanan
> Uri Dimant wrote:
>> Have you read this article in the BOL
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/b1019300-171a-4a1a-854f-e1e751de3565.htm
>>
>> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
>> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
>> > hi,
>> > how do i use except with my result sets.
>> > any example please.
>> >
>> > kalaivanan
>> >
>|||--All city-region combination that exists
--in customers except those that also exists in employees
USE Northwind
SELECT City, Region FROM customers
EXCEPT
SELECT City, Region FROM Employees
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> hi,
> how do i use except with my result sets.
> any example please.
> kalaivanan
>|||hi,
i get the following error while trying
USE Northwind
SELECT City, Region FROM customers
EXCEPT
SELECT City, Region FROM Employees
error:
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'EXCEPT'.
Tibor Karaszi wrote:
> --All city-region combination that exists
> --in customers except those that also exists in employees
> USE Northwind
> SELECT City, Region FROM customers
> EXCEPT
> SELECT City, Region FROM Employees
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> > hi,
> > how do i use except with my result sets.
> > any example please.
> >
> > kalaivanan
> >|||What version of SQL Server? What compatibility level for the database? EXCEPT is new for 2005 and it
needs compat level 90.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1163742581.350491.211280@.e3g2000cwe.googlegroups.com...
> hi,
> i get the following error while trying
> USE Northwind
> SELECT City, Region FROM customers
> EXCEPT
> SELECT City, Region FROM Employees
> error:
> Server: Msg 156, Level 15, State 1, Line 2
> Incorrect syntax near the keyword 'EXCEPT'.
> Tibor Karaszi wrote:
>> --All city-region combination that exists
>> --in customers except those that also exists in employees
>> USE Northwind
>> SELECT City, Region FROM customers
>> EXCEPT
>> SELECT City, Region FROM Employees
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
>> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
>> > hi,
>> > how do i use except with my result sets.
>> > any example please.
>> >
>> > kalaivanan
>> >
>|||i am using sql server 2000.
kalaivanan
Tibor Karaszi wrote:
> What version of SQL Server? What compatibility level for the database? EXCEPT is new for 2005 and it
> needs compat level 90.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1163742581.350491.211280@.e3g2000cwe.googlegroups.com...
> > hi,
> >
> > i get the following error while trying
> >
> > USE Northwind
> > SELECT City, Region FROM customers
> > EXCEPT
> > SELECT City, Region FROM Employees
> >
> > error:
> >
> > Server: Msg 156, Level 15, State 1, Line 2
> > Incorrect syntax near the keyword 'EXCEPT'.
> >
> > Tibor Karaszi wrote:
> >> --All city-region combination that exists
> >>
> >> --in customers except those that also exists in employees
> >>
> >> USE Northwind
> >>
> >> SELECT City, Region FROM customers
> >>
> >> EXCEPT
> >>
> >> SELECT City, Region FROM Employees
> >>
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> >> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> >> > hi,
> >> > how do i use except with my result sets.
> >> > any example please.
> >> >
> >> > kalaivanan
> >> >
> >|||EXCEPT isn't available on 2000. It was introduced in 2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kalaivanan" <mail2kalai@.gmail.com> wrote in message
news:1163760282.349339.48870@.k70g2000cwa.googlegroups.com...
>i am using sql server 2000.
> kalaivanan
> Tibor Karaszi wrote:
>> What version of SQL Server? What compatibility level for the database? EXCEPT is new for 2005 and
>> it
>> needs compat level 90.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
>> news:1163742581.350491.211280@.e3g2000cwe.googlegroups.com...
>> > hi,
>> >
>> > i get the following error while trying
>> >
>> > USE Northwind
>> > SELECT City, Region FROM customers
>> > EXCEPT
>> > SELECT City, Region FROM Employees
>> >
>> > error:
>> >
>> > Server: Msg 156, Level 15, State 1, Line 2
>> > Incorrect syntax near the keyword 'EXCEPT'.
>> >
>> > Tibor Karaszi wrote:
>> >> --All city-region combination that exists
>> >>
>> >> --in customers except those that also exists in employees
>> >>
>> >> USE Northwind
>> >>
>> >> SELECT City, Region FROM customers
>> >>
>> >> EXCEPT
>> >>
>> >> SELECT City, Region FROM Employees
>> >>
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
>> >> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
>> >> > hi,
>> >> > how do i use except with my result sets.
>> >> > any example please.
>> >> >
>> >> > kalaivanan
>> >> >
>> >
>|||okay.
i have completed the job using left join.
kalaivanan
Tibor Karaszi wrote:
> EXCEPT isn't available on 2000. It was introduced in 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> news:1163760282.349339.48870@.k70g2000cwa.googlegroups.com...
> >i am using sql server 2000.
> >
> > kalaivanan
> >
> > Tibor Karaszi wrote:
> >> What version of SQL Server? What compatibility level for the database? EXCEPT is new for 2005 and
> >> it
> >> needs compat level 90.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> >> news:1163742581.350491.211280@.e3g2000cwe.googlegroups.com...
> >> > hi,
> >> >
> >> > i get the following error while trying
> >> >
> >> > USE Northwind
> >> > SELECT City, Region FROM customers
> >> > EXCEPT
> >> > SELECT City, Region FROM Employees
> >> >
> >> > error:
> >> >
> >> > Server: Msg 156, Level 15, State 1, Line 2
> >> > Incorrect syntax near the keyword 'EXCEPT'.
> >> >
> >> > Tibor Karaszi wrote:
> >> >> --All city-region combination that exists
> >> >>
> >> >> --in customers except those that also exists in employees
> >> >>
> >> >> USE Northwind
> >> >>
> >> >> SELECT City, Region FROM customers
> >> >>
> >> >> EXCEPT
> >> >>
> >> >> SELECT City, Region FROM Employees
> >> >>
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "kalaivanan" <mail2kalai@.gmail.com> wrote in message
> >> >> news:1163672142.199427.132050@.m73g2000cwd.googlegroups.com...
> >> >> > hi,
> >> >> > how do i use except with my result sets.
> >> >> > any example please.
> >> >> >
> >> >> > kalaivanan
> >> >> >
> >> >
> >