Here's another:

"Wide World Importers has offices in Moscow, Paris, and Chicago. The Shipments table contains all the data concerning the company's import/export business. All data is entered in the local...

Creating a temp table and doing a in(select * from #temptable) turns out to be the appaoch that works.

Thanks!

Here it is.. Ths is a SQL Agent Job that monitors Reports jobs that are printed through several services. We want to be notified if any go...

I haven't tested it yet, but it currently works with a single static query.

The duplicate version would look like this:

IF DATEPART(HOUR,GETDATE()) > 7

(all the current code that...

Another thing I'm trying is to put a list of values into a variable and using in an IN clause, as in

IF EXISTS(SELECT COLUMN_A, COLUMN_B FROM TABLE WHERE COLUMN_A IN...

I want the query used between midnight & 7am to be slightly different from the query used other times.

I could have two versions of the whole thing inside

If Datepart(hour,GETDATE())...

The error message was the standard Microsoft message that I believe comes from the local SQL Client when a requested SQL Server cannot be located on the network. It...

The unistalled feature is in the vendor's software and the connection data is in a table in the vendor's database.

It's possible you have SQL 2008 R2 SSMS and SQL2005 Express DB engine installed. Actually that's what I have on my workstation.

Was SQL Express 2005 installed on your...

Interesting, while the Estimated Execution Plan looks simple enough, when I run the query with "Include Actual Execution Plan" selected, the Execution Plan tab shows 238 queries. There...

Yes, the column is indexed, it is not the primary key. The table has 513 rows and only one is updated by the query. The estimated query...

Would it be practical for each client to use a different SQL login/user to access their data in separate databases? If all queries from a particular client portal use...

Since we're doing one node (for dev) and haven't planned for SAN space for dev, can we get away with adding a small shared disk and storing all the database,...

SQL-Soft in Bellevue, WA

http://www.sqlsoft.com/

An unprepared instructor can be a disaster regardless of whether the class is online or in a traditional classrom. To gaurd against that I'd go with a vendor who...