Computerworld

LINQ in .NET returning duplicate rows from a working SQL view [SOLVED]

Twice in the past couple of months I’ve gotten tripped up by the same data issue when using LINQ to Entities in the .NET framework. I create a simple view in my database which performs some ...
Ars Technica

How do I reed a return code from a SQL stored procedure?

I'm working on a VB.NET app that creates SQL Logins for an app that uses our MS-SQL server.<BR><BR>The docs for both sp_addlogin and sp_grantdbaccess claim that it will return a zero if successful, ...
MCPmag

PowerShell Returns, The SQL

We've been looking at ways you can leverage and extend all the PowerShell knowledge you've gleaned over the course of this column. I want to wrap up with a peek at what you can do with SQL Server 2008 ...
Ars Technica

SQL to return average count of admits for each day of the week

Hey, been reading the board for a bit. First post. I'm having issues coming up with a SQL query that will provide the average admits for each day of the week. However, I can't for the life of me get ...