Sent you one too...

That is entirely too vague to give a concrete answer. It is however a good interview question because it should immediately start you asking questions. What is this query? Are...

Yes you can have more than 1 foreign key constraint on a table.

Here is an example of creating one.

alter table MyTable

add constraint MyTable_MyColumn_FK FOREIGN KEY ( MyColumn ) references...

You just need to alias your original tables.

If SelectSQL.Length = 0 Then

strSQL = "SELECT...

dwain.c (4/12/2012)

---

sbuchan - You're most welcome.

Gotta give credit where credit is due though. My first attempt at a solution didn't look as good as Sean's so it was his...

And just for the record there is absolutely no reason at all you need a cursor to do this. 😉

paramjit4 (4/11/2012)

---

i want to insert values in number tables from march_2012 from first in to last in in series

1

2

3

4

in march tables can have many first in and last in

help me...

Sounds like you need a tally table[/url].

You really should start your own post instead of tacking onto a different one.

I don't understand at all why you even need to loop for this. From what you posted...

Lynn Pettis (4/11/2012)

---

Please, someone tell me why, just why do I keep helping someone who...

Are the parameters the same every time you run it?

Lynn Pettis (4/11/2012)

---

GilaMonster (4/11/2012)

---

Sean Lange (4/11/2012)

---

What is wrong with people today? So many stupid posts with little to no information or clarity. Did I miss the memo about today being...

What is wrong with people today? So many stupid posts with little to no information or clarity. Did I miss the memo about today being "Leave your brain at home...

Happy to help. Post back when you have a chance to try it and let us know. Good luck!!!

Pretty light on details but does this help?

INSERT INTO item_tbl1

(SETID,INV_ITEM_ID, MFG_ID, MFG_ITM_ID, UNIT_OF_MEASURE, UPN_TYPE_CD, UPN_ID)

select 'CORP1','0031','800281','0031','EA','DOM','800281000016'

where not exists

(select 'CORP1','0031','800281','0031','EA','DOM','800281000016' from item_tbl2)

Of course this could be different depending on where...