select count(TaskId) as tasks from Task T,Provider P where P.UserId=T.UserId and T.permissions='False' and T.State='Close' and T.Assignedto=@Assignedto select count(TaskId) as tasks1 from Task T,Provider P where P.UserId=T.UserId and T.Permissions='False' and T.State='Open' and T.Assignedto=@Assignedto select count(TaskId) as tasks2 from Task T,Provider P where P.UserId=T.UserId and T.Permissions='False' and T.State='Completed' and T.Assignedto=@Assignedto
DataSet
DataTables
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)