USE test

CREATE TABLE testConstraint (

A int Null,

B int Null,

C int Not Null)

alter table testConstraint

add constraint threeColumn CHECK ((C = 150 AND A IS NOT NULL) OR (C = 151 ...

GilaMonster (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

And as a note to the OP, (not to you Lynn) not knowing your experience, make sure you really know what an overlapping index is. I have seen...

I looked back at your original post and realized that you are not deleting all of the records needed to perform the second delete. ALL records with the foreign...

Without the field order, it is useless. Index on columnA, columnB, columnC is completely different from columnC, columnB, columnA.

sqlfriends (4/17/2012)

---

This is hard for me too everytime to post on T-SQL forum, try to make it simple to get some hint, and not post all complicated table structures...

Lynn Pettis (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

sqlfriends (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

No, look:

ALTER TABLE [dbo].[batSchoolRangeProgramResult] WITH CHECK ADD CONSTRAINT [FK_batSchoolRangeProgramResult_appSchoolRangeProgramSnapshot] FOREIGN KEY([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

REFERENCES [dbo].[appSchoolRangeProgramSnapshot] ([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

So the constraint...

sqlfriends (4/17/2012)

---

SQLKnowItAll (4/17/2012)

---

No, look:

ALTER TABLE [dbo].[batSchoolRangeProgramResult] WITH CHECK ADD CONSTRAINT [FK_batSchoolRangeProgramResult_appSchoolRangeProgramSnapshot] FOREIGN KEY([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

REFERENCES [dbo].[appSchoolRangeProgramSnapshot] ([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

So the constraint is on batSchoolRangeProgramResult...

OP, look at your first error:

EDIT: OP changed names in first post from the actual in the attached code.

No, look:

ALTER TABLE [dbo].[batSchoolRangeProgramResult] WITH CHECK ADD CONSTRAINT [FK_batSchoolRangeProgramResult_appSchoolRangeProgramSnapshot] FOREIGN KEY([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

REFERENCES [dbo].[appSchoolRangeProgramSnapshot] ([ProcessID], [SchoolYear], [SchoolID], [RangeCd], [ProgramID])

So the constraint is on batSchoolRangeProgramResult and that...

Not to beat a dead horse... Maybe I'm not.

1. A Primary Key cannot contain a NULL value.

2. You can place a unique constraint on a column, which will...

Ok, let's start with this... Which table has more records than the other? My "guess" (since you have not included DDL for the tables and sample data as...

vinu512 (4/14/2012)

---

From what I understand this might be what you are looking for:

Insert Into tbl_year

Select * From tbl_Jan

Union All

Select * From tbl_Feb

Union All

Select * From tbl_March

Union All

Select * From tbl_April

Union...

Lynn Pettis (4/17/2012)

---

SkyBox (4/17/2012)

---

There...

SkyBox (4/17/2012)

---

There are a...

PiMané (4/17/2012)

---

Lynn Pettis (4/17/2012)

---

Simple answer, it depends. It depends...