Ars Technica

SQL query help - how can I combine these two queries into one?

I'm having a brain fart here... I have a feeling that I should be able to write a single query to handle this, but I just can't think of how... Basically, I have two tables: "distributors" and ...
Ars Technica

[MS SQL] Combine Data From Multiple Tables In Different Databases Into One View

So lets say I have 5 databases, all with the same schema, but different data. I want to be able to build reports based on the data in all of those databases. How could I construct a view which would ...
Visual Studio Magazine

T-SQL | COMBINE UPDATE AND INSERT STATEMENTS

Listing 5. This procedure demonstrates a technique for combining an Insert statement and an Update statement into a single stored procedure. CREATE PROCEDURE STDA.CustomersUpdate @CustomerID NCHAR(5), ...
Visual Studio Magazine

Combining LINQ Queries (or, When to Call ToList)

LINQ with Entity Framework has become so common that, when I'm looking at a client's code I'm finding some pretty scary-looking LINQ queries running against Entity Framework. Since I'm a big fan of ...