outerjoint

Hi all - I am new to MsSQL and need a bit of help.
I have a query that works perfectly in Oracle but not in MsSQL. I understand that there are different commands in MsSQL and for the life of me I cannot find them. Can someone help? Here is the query.

Select c.*, ins.id from CASES c, INSPECTOR ins
where c.id = &intID
and ins.id (+) = decode(c.inspector_id,1,null,c.inspector_id)

Cheers
HekiSelect c.*, ins.id
from CASES c
LEFT OUTER JOIN
INSPECTOR ins ON
ins.id = decode(c.inspector_id,1,null,c.inspector_id) AND
c.id = &intID;|||sql server doesn't support DECODE

select c.*
, ins.id
from CASES c
left outer
join INSPECTOR ins
on case when c.inspector_id = 1
then null
else c.inspector_id end = ins.id
and c.id = &intID

Outer Join and Inner Join

Hi
I have been intrigued a bit with the terminology of outer and inner join.
I have been using outer joins as a.orderid=b.orderid(+) which means, that even if table b doesnt have the columns corresponding to orderids in a, it would still return the request row.

I dont know what is the inner join ?? Why and how is it used, and what is the case where inner join comes in handy.
Thanx and Regards
AruneeshOriginally posted by aruneeshsalhotr
Hi
I have been intrigued a bit with the terminology of outer and inner join.
I have been using outer joins as a.orderid=b.orderid(+) which means, that even if table b doesnt have the columns corresponding to orderids in a, it would still return the request row.

I dont know what is the inner join ?? Why and how is it used, and what is the case where inner join comes in handy.
Thanx and Regards
Aruneesh
Inner join is just a regular join, without the (+).

OT: Toronto SQL Server User Group

Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
--
spamhoneypot@.rogers.com (Do not e-mail)Yes, it is active. I'll try and ping the guys and find out what happened.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns9A49966649663usenethoneypotrogers@.127.0.0.1...
Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
--
spamhoneypot@.rogers.com (Do not e-mail)|||I found out that it is a hardware issue and it should be up tomorrow.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns9A49966649663usenethoneypotrogers@.127.0.0.1...
Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
--
spamhoneypot@.rogers.com (Do not e-mail)

OT: Toronto SQL Server User Group

Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
spamhoneypot@.rogers.com (Do not e-mail)
Yes, it is active. I'll try and ping the guys and find out what happened.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns9A49966649663usenethoneypotrogers@.127.0.0. 1...
Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
spamhoneypot@.rogers.com (Do not e-mail)
|||I found out that it is a hardware issue and it should be up tomorrow.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Spam Catcher" <spamhoneypot@.rogers.com> wrote in message
news:Xns9A49966649663usenethoneypotrogers@.127.0.0. 1...
Hi all,
A bit OT, but does Toronto have an active SQL Server User Group?
www.tsql.ca seems to be down...
Thanks!
spamhoneypot@.rogers.com (Do not e-mail)

OS requirements for SQL 2000

Can i run SQL 2000 Enterprise Edition 32 bit on Windows Server 2003 64 bit?
Thx,
DonYes, on X64 not Itanium. But you'll miss much of the advantages of the 64 bi
t HW/OS.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"donsql22222" <donsql22222@.discussions.microsoft.com> wrote in message
news:46697153-FC06-42A0-A8D0-EB825A234264@.microsoft.com...
> Can i run SQL 2000 Enterprise Edition 32 bit on Windows Server 2003 64 bit
?
> Thx,
> Don
>