-
select convert ( char ( 10 ), [LogDate] , 101 ), count (*) from [ Logs] group by convert ( char ( 10 ), [LogDate] , 101 ) order by convert ( char ( 10 ), [LogDate] , 101 ) desc
-
t-sql to count how many times a column's value is in a table SELECT distinct(a.Col1), (Select count(Col1) FROM [Table] b where a.Col1= b.Col1) as colcount FROM [Table] a group by a.Col1 having (Select count(Col1) FROM [Table] b where a.Col1 = b.Col1 ) > 1 order by colcount desc
-
Here's a free tool to browse and connect to Oracle SQL databases http://www.oracle.com/technology/software/products/sql/index.html
-
Here's a good article written by David Hayden that gives an example of a profileprovider written with LINQ http://www.davidhayden.com/blog/dave/archive/2007/10/30/CreateCustomProfileProviderASPNET2UsingLINQToSQL.aspx
-
Here are better SetPropertyValues and SetProfileData methods that only make 1 database call by buildinding a single sql statement to execute instead of executing a statement for each property. public override void SetPropertyValues(SettingsContext context, SettingsPropertyValueCollection collection)...
-
here's the sql script to create the table... Only EmployeeID field or the Ntlogin field is needed and should be a foreign key to the employee table CREATE TABLE [dbo].[tbl_Profiles]( [ProfileID] [int] IDENTITY(1,1) NOT NULL, [SystemID] [int] NULL, [EmployeeID] [int] NULL, [Ntlogin] [varchar](8) COLLATE...