thank you ,, Luis ,,that's the exact answer,,,

neglect these humpty dumpties, they can't even understand what a poster wants..

pitty some fellows here, they can't understand simple things and...

my expected op is as follows

region sal count

a 1000 ...

here is the answer!!!!!!!!,

Alter FUNCTION FN_Count

(

@ENTERPRISE_MAIN_CODE int,

@Date varchar(50),

@ConditionNo int

)

RETURNS int

AS

BEGIN

Declare @Count int

Declare @PreYear varchar(50)

Declare @CurrentYear varchar(50)

if @ConditionNo=1

begin

Select @Count=count(A.ENTERPRISE_MAIN_CODE)

from TableA A inner join TableB B

on A.ENTERPRISE_MAIN_CODE =B.ENTERPRISE_MAIN_CODE

inner join TableC C...

OPPS Y WHAT IS THE REASON !!!!!!!!!

Following is the relatioship

Table A is related to Table B BY ENTERPRISE_MAIN_CODE AND ENTERPRISE_SUB_CODE

Table C is related to Table B by ID_NO

Table B is used...

Dear Sean,

Hope its clear to you.

thanks

nick

pls let me know what information u need from me.

i think i have explained you very clearly what iam looking for.

pls check the business rules mentioned before.

user inputs 201303

what he...

I just need the op displayed above....

its just the count and the amount too be displayed.

thanks

nick

output should be like this

ENTERPRISE

DESCRIPTION | count | amt | count | amt ...

Ok thanks for the comments.

The business rule is explained below

This is basically a statistical report for a small and medium enterprise.

With this report user should be able to judge the...

the tables what you created are the tables which is used to generate following op

ENTERPRISE

DESCRIPTION count...