thanks for ur reply,

but this scenario, i need to use with ASP.NET applications in a single sql statement