The easiest way is to change the order of the tables creation put StudentAccount after Instructor.

You could use a query like this, but you may want to complete it.

This will give you the StandIDs in more than one Stadium. To get the ones that are...

I've been doing it for so long, I'm not sure where to look for. Maybe the stairway to T-SQL [/url] on this site can be a good start but I...

dwg23 (5/31/2013)

---

Here is the code I ended up with and if anyone can explain why adding 'max' to the sub query's made them work I would love to be educated...

I'm sorry, my intention wasn't to be rude, I've had a tough week at work (some might have an idea why is that). I'm really interested in helping you, otherwise...

Use a batch separator (a.k.a. GO).

This will help you unless you're using the query inside a SP.

I'm sorry but I forgot my mindreader cap.

Could you post the errors you're getting and the DDL involved? Some sample data and expected results will help us to see what...

I'm glad it worked almost fine and even more glad that you tested the code before using it. 🙂

Could you post DDL (tables structure) and sample data? And define what's a match and what else is involved.

I'm thinking on using UPDATE... WHERE [NOT] EXISTS( <query to find the...

I've sent some emails and the answer was that they are aware of the implications of using it but it's a policy and must be followed.

I'll save that email to...

As general information, user defined scalar valued functions won't allow you to use parallellism in your queries.

You might find better performance using an inline Scalar Valued Function as called by...

Michael Valentine Jones (5/30/2013)

---

Luis Cazares (5/30/2013)

---

GilaMonster (5/28/2013)

---

Use one of the snapshot isolation...

Eugene Elutin (5/30/2013)

---

Luis Cazares (5/30/2013)

---

GilaMonster (5/28/2013)

---

Use one of the snapshot isolation levels....

GilaMonster (5/28/2013)

---

Use one of the snapshot isolation levels. Financial or non-financial, I've...

This code can help you to find it within Stored Procedures

DECLARE @Search_Text nvarchar(128) = 'MAXDOP',

@Command1 nvarchar(2000)

SET @Command1 =

'IF EXISTS( SELECT 1 FROM [?].sys.sql_modules m JOIN [?].sys.procedures p ON m.object_id =...