Clarify, If you want the minimum Budgeted values from all the budgeted figures given a site_ref?

As suggested by [KH], use dynamic query.

Decalre @strSQL varchar(100)

set @strSQL = 'select @pendT = count(*) from ' + Object_Name(@Object)

sp_executesql @strSQL

Check this out.

Hope this solve your purpose,

insert into dim_time

(

Select outdate

from

 (select exam_datetime outdate from futureexams

 union

 Select exam_date outdate from userexams ) A

where A.outdate not in (Select DimTime.TheDateFiled dim_time)

)

Hope this works

SELECT site_ref, budgeted_net_rent, budgeted_occupancy

FROM src_tbl_rental

WHERE (convert(datetime,src_date,106) >= @dt_src_date) AND (convert(datetime,src_date,103) < DATEADD(month, 1, @dt_src_date) - 1)

Input Table

Ok.

Thanks for clarification.

Thanks Addict,

What if the Join condition has two clauses.

e.g

SELECT * FROM A INNER JOIN B ON A.a1 = B.a1 and A.a2 = B.a2

Now what will be order of evaluation...

HI,

The output parameters returns value to the calling function or procedure. So you need a variable in the calling function or procedure to catch the returned value.

As when you are...