Database

select distinct [date],<br />
(select count(t1.status) from MyTable as t1 where status=2 and t1.date=MyTable.[date]) as [Total 2],<br />
(select count(t1.status) from MyTable as t1 where status=3 and t1.date=MyTable.[date]) as [Total 3]<br />
 from MyTable 

Scott Clewell wrote:

but like implicitly coverts int's to varchar

Ashfield wrote:

Have a try, post your sql and then someone may help you

"Data Source=dbserver;Initial Catalog=mydb;Persist Security Info=True;User ID=user;Password=password;Connection Timeout=60;Packet Size=16384;Pooling=false"

1. EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;
2. Client client = Application.GetClient();
3. db.GetPartsByClientType(...)</entitiesdatacontext>

public static T Current {
			get {
				string key = typeof(T).FullName;
				T datacontext = (T)System.Web.HttpContext.Current.Items[key];
				if (datacontext == null)
					System.Web.HttpContext.Current.Items.Add(key, datacontext = new T());
				return datacontext;
			}
		}

EntitiesDataContext db = MyProject.Misc.HttpDataContext<entitiesdatacontext>.Current;</entitiesdatacontext>