Database

select * from iss_bsm_svcstates_table ss, iss_bsm_geolocation_table geo
where ss.service = geo.service_name and ss.time_received in 
(select max(ss1.time_received) from iss_bsm_svcstates_table ss1 group by ss1.service)

select * from iss_bsm_svcstates_table ss, iss_bsm_geolocation_table geowhere ss.service = geo.service_name and ss.time_received in 
(select top 1 ss1.time_received from iss_bsm_svcstates_table ss1 where ss1.time_received  = ss.time_received  order by ss1.service desc)

declare @codes varchar(max)
select @codes=cast(quotename('28-2801','''')+','+quotename('28-2802','''') as varchar(max))
print @codes
exec [sp_getCommunityDetail] @codes

create proc sp_detail
(
@p varchar(max)
)
as
select * from tblName where code in (@p)
go

declare @codes varchar(max)
select @codes=cast(quotename('28-2801','''')+','+quotename('28-2802','''') as varchar(max))
exec [sp_detail] @codes

declare @Split TABLE (.....)
insert into @Split
	select .. from your_split_function

select * from table t1
join @split s on s.code = t1.code