SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 case function with row count
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

oracle_corrgi
Yak Posting Veteran

India
98 Posts

Posted - 09/04/2006 :  06:22:27  Show Profile  Reply with Quote

hi
can any one help with
case function with row count

if row count is greater then 1 or >1 case1
if row count is zero then case two

------this is my table and cloumn ---sample code

DECLARE
@rc tinyint ,
@var varchar(50)
set @var = (SELECT emd.tpa_id
from dbo.EMPLOYER_DIVISION AS ED,EMPLOYEE_MISC_DATA AS EMD
where emd.tpa_id=ed.tpa_id
and
emd.empe_key=ed.division_key)
SELECT ed.tpa_id,
ed.division_key,
emd.tpa_id,
emd.empe_key
from dbo.EMPLOYER_DIVISION AS ED,EMPLOYEE_MISC_DATA AS EMD


database

SwePeso
Patron Saint of Lost Yaks

Sweden
30218 Posts

Posted - 09/04/2006 :  06:26:30  Show Profile  Visit SwePeso's Homepage  Reply with Quote
quote:
Originally posted by oracle_corrgi

hi
can any one help with
case function with row count

if row count is greater then 1 or >1 case1
if row count is zero then case two

------this is my table and cloumn ---sample code

DECLARE
@rc tinyint ,
@var varchar(50)
set @var = (SELECT emd.tpa_id
from dbo.EMPLOYER_DIVISION AS ED,EMPLOYEE_MISC_DATA AS EMD
where emd.tpa_id=ed.tpa_id
and
emd.empe_key=ed.division_key)
SELECT ed.tpa_id,
ed.division_key,
emd.tpa_id,
emd.empe_key
from dbo.EMPLOYER_DIVISION AS ED,EMPLOYEE_MISC_DATA AS EMD
database

IF EXISTS (SELECT * FROM dbo.EMPLOYER_DIVISION AS ED inner join EMPLOYEE_MISC_DATA AS EMD on emd.tpa_id = ed.tpa_id and emd.empe_key = ed.division_key)
	SELECT		emd.tpa_id
	from		dbo.EMPLOYER_DIVISION AS ED
	inner join	EMPLOYEE_MISC_DATA AS EMD on emd.tpa_id = ed.tpa_id and emd.empe_key = ed.division_key
ELSE
	SELECT		ed.tpa_id,
			ed.division_key,
			emd.tpa_id,
			emd.empe_key
	from		dbo.EMPLOYER_DIVISION AS ED
	cross join	EMPLOYEE_MISC_DATA AS EMD


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000