My Solution:
USE [NPS]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[sp_GetSeletedTrucks]
@xmldoc xml
as
-- sp_GetSeletedTrucks '<root fromdate="03/29/2014" todate="03/29/2014" tid="600-0000,601-0000,602-0000,603-0000,604-0000,605-0000,606-0000,607-0000,608-0000,609-0000,610-0000,611-0000,612-0000" />'
Declare @FromDate date, @ToDate date, @tid nvarchar(max)
SELECT
@FromDate = Col.value('@FromDate', 'date'),
@ToDate = Col.value('@ToDate', 'date'),
@tid = Col.value('@tid', 'nvarchar(MAX)')
FROM @xmldoc.nodes('/Root') Tbl(Col);
declare @dooroptions table
(dno varchar(max))
declare @text nvarchar(max)
set @text = REPLACE(@tid, '''','')
insert into @dooroptions
select data from dbo.Split(@text, ',')
select
distinct DoorNo as '@label'
,1 as '@value'
from TruckTracking v
where
DoorNo in (select dno from @dooroptions) and
(TrackDate between @FromDate and @ToDate)
for xml path('category') , Root('categories');