I'm a software developer at a telco supporting line-of-business applications. We use a variety of technologies from ASP.NET to Perl. I've come to appreciate SQL more over time, and I now spend most of my time in the database.
If you'd like to learn SQL properly, consider the awesome free SQL course from Stanford. The organization behind the course offers many other classes. I'm enjoying the Fantasy and Science Fiction course.
|
4h
|
|
reviewed | Approve suggested edit on How can I do something after Process.Start("explorer.exe", OpenFolder) |
|
4h
|
|
reviewed | Approve suggested edit on Getting values from dynamic listview |
|
4h
|
|
reviewed | Approve suggested edit on Making the SE handle for the jQuery UI resizable plugin lock in the aspect ratio |
|
4h
|
|
reviewed | Approve suggested edit on LinkageError : I want to modify my CtClass and call ToClass() again |
|
4h
|
|
reviewed | Reject suggested edit on My database connection class will not connect to the database |
|
11h
|
|
comment |
SQL: Count Users with Activity in the Past Week Updated so you can use it for dates in the past as well. For example, replace all occurrences of getdate() with 2013-01-01
|
|
11h
|
|
revised |
SQL: Count Users with Activity in the Past Week added 38 characters in body |
|
11h
|
|
comment |
SQL: Count Users with Activity in the Past Week Don't think this implements "two sessions within 7 days OR ten in the past 30 day" |
|
11h
|
|
answered | SQL: Count Users with Activity in the Past Week |
|
20h
|
|
revised |
SQL Server: get records that their date is either begining or end of the month added 3 characters in body |
|
20h
|
|
comment |
SQL Server: get records that their date is either begining or end of the month @ErikE: Thanks for the edit, much appreciated. The question asks for the last and first count in a single row. To get there you have to pivot somehow, and aggregates are one way to do that. |
|
20h
|
|
comment |
SQL Server 2005 and temporary table scope @Legend: object_id should only see temporary tables from your own session. Should be easy to test.
|
|
1d
|
|
awarded | Good Answer |
|
1d
|
|
reviewed | Reject suggested edit on Errors while trying to build openmeeting from its sources |
|
1d
|
|
reviewed | Approve suggested edit on jQuery live draggable / live droppable? |
|
1d
|
|
reviewed | Approve suggested edit on How do you modify an SQL query to iteratate over every 100 results and then perform an outter query? |
|
1d
|
|
comment |
Why when I insert a DateTime null I have "0001-01-01" in SQL Server? @MarcGravell: Yeah, I presume nHibernate, Linq2Sql or EF converts the null to a DateTime somewhere, and that ends up as 0001-01-01. Perhaps the column is marked as non-nullable in EF. In a way null corresponds to 0001-01-01, which is what this answer says. Might not be a stellar answer, but it's from a new user, and I don't feel this deserves downvotes at all.
|
|
1d
|
|
revised |
SQL Server: get records that their date is either begining or end of the month added 2 characters in body |
|
1d
|
|
comment |
Why when I insert a DateTime null I have "0001-01-01" in SQL Server? @MarcGravell: Comment was meant as additional information. If you run var d = new DateTime(); Console.WriteLine(d);, it prints 0001-01-01, which makes me disagree with the downvotes.
|
|
1d
|
|
comment |
Why when I insert a DateTime null I have "0001-01-01" in SQL Server? +1 That's right! Use DBNull.Value to insert a SQL NULL
|
