I recently found one or two issues at work with scalar functions. I would be happy to contribute an article with examples.

Drew, there's beauty in simplicity! Great solution, even if a bit slower. Thanks!

SQL rocks!

\m/

Very nice, Kevin! Thanks!

Lowell, thanks for the suggestions!

Krys,

You might start with this and fill in something for table B:

declare @table1 table(

ID int

, critter_description varchar(50)

)

declare @table2 table(

ID int

, critter_description varchar(50)

)

insert into @table1(ID, critter_description)

values (1,'cow')

insert into @table2(ID, critter_description)

values (2,'dog')

SELECT...

I don't see your definition of table B.

You're forcing us to guess just a bit as you haven't supplied DDL code and some data, but my guess is that what you need is not cursors but left...

How is it possible that the VM Admin would move a SQL Server and the SQL Server folks not be aware ahead of time? That's a real problem.

Do you mean to say that SSMS is locked or stuck? You might try closing SSMS, which of course won't stop SQL Server services.

Yup, the recursive CTE gave me what was needed. I needed to be able to get one particular Top Dude's descendents (employees), and this worked ok:

USE Sandbox;

GO

-- 1 and 12...

Thanks for the links. Jeff knows what he's talkin' 'bout! If I get some time this afternoon (or later), I will dig further into these.

From BOL:

To open a saved XML query plan in SQL Server Management Studio

In SQL Server Management Studio, on the File menu, choose Open, and then click File.

In the Open File...

Boomerang looks like it's quite useful; I like that it's SQL table-driven. However, given the fact that the Pro edition is 995 EUR and it's the cheapest edition that can...

I have not heard too many good things about replication. When there are problems, my impression is that it's not simple to fix.

Is it an option to just empty the...

I've done something similar to this before, and I didn't see much of a performance impact.. however, the views were pretty simple. I would give it a shot, but do...