So you want to select rows that only exist in TableA? This is an OUTER JOIN.

SELECT a.*

FROM TableA a

LEFT JOIN TableB b

...

I suppose I should have qualified that more Steve. The reason I have the concern is because what you've stated in that the resources are shared and many folks...

Exactly, Matt's hit the nail on the head. The data should be retrieved from the database as a set based query. The application can perform any looping or...

Wow. I feel for you. I've seen this before and I'd have to say that from my experience, I would be very wary about running a multi-user SQL...

Dan,

I don't think there is a set formula like what you are asking for. You may be able to find information on how to initially size a SQL...

I'm with Jeff on this one. Since I've been into SQL Server, I have written 2 cursors. One was for analysis purposes to gather info. on all databases...

Thanks. For my example, I've only added a single...

You'll have to play around with this, but PATINDEX is probably the way to go here. I tried to do this using a derived table, but had no luck....

This works just fine....

DECLARE @EMPLOYEE TABLE (EmpId int, Ename varchar(20), Salary money, ManagerId int, DeptId int)

DECLARE @DEPaRTMENT TABLE (DeptId int, DeptName varchar(100), DeptHead int)

INSERT INTO @Employee

SELECT 1, 'John', 0, 0,...

Why can't you have 3 instances of the Employee table? Is this homework?

Please continue this thread here: http://www.sqlservercentral.com/Forums/Topic477835-338-1.aspx

WHERE LEN(EmployeeNumber) <> 6

Well, as I said, I am working on a schema design that was similar to the posters. I ended up creating a mock up of 2 models; one using...

I'll third that. Start out with a design that is as normalized as possible and make adjustments as needed.

Really, I chimed in here to give Luke a...

John,

There are a couple of things I'd like to point out here. Just as a note, I am not trying to sound condescending; rather, I'm not familiar...