[font="Verdana"]Aha. Sorry. Final bit sprung to mind.

You want to assemble your dynamic SQL, and only do one exec. The "set identity_insert on/off" will only apply to the...

[font="Verdana"]I rewrote your code somewhat, and removed the dynamic SQL. I just wanted to test that I was getting a correct list of table names, columns names and whether...

[font="Verdana"]I'll have to have a look at the code... for starters though, I wouldn't mix using INFORMATION_SCHEMA with the sys tables. One or the other. Not both....

[font="Verdana"]Oh, who knows. I haven't played with Oracle for a couple of years now, so maybe the best thing is to do the old "suck it and see" approach....

[font="Verdana"]Does that actually work?

I know in Oracle, if you tried to put the filter criteria for the right hand side being empty into the ON clause, it didn't work as...

[font="Verdana"]You need to specifically name the columns you are inserting into when you have identity insert on.[/font]

[font="Verdana"]Welcome to the joys of execution plans. :w00t:

From experience, the left outer join always tend to perform at least as well as the not exists. So I always...

Lynn Pettis (2/3/2009)

---

I'd never use 6th normal form. Why would you want a table for evey column in your database? Think of all the joins you need to...

From what I understand that was never formally "Codd-ified". I'd be interested to read some reference on...

riga1966 (2/3/2009)

---

SELECT

ci.IG_SRC_SYS_KEY = CASE

WHEN LEFT(ci.IG_CD,1) = 'D' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID = 'DDA')

WHEN LEFT(ci.IG_CD,1) = 'G' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID = 'GRM')

WHEN LEFT(ci.IG_CD,1) =...

[font="Verdana"]Poor SQL Server would have been getting confused over whether you wanted a select or an update there. :D[/font]

Lynn Pettis (2/3/2009)

---

Actually, I've heard, but can't confirm, that if follow the rules of normalization far enough, you end up back where you started. Why you'd do that, I...

[font="Verdana"]I suspect that will be the end result of a re-design, but first an introduction to the five "normal...

[font="Verdana"]Okay, I am probably going to anger some purists with this suggestion, but let's be pragmatic here.

If you are trying to come up with a database design that ensures that...

ivana.andric (2/3/2009)

---

Can anyone tell me are there any limits on how many columns should be in composite key? I have a unique combinations of 28 fields that I nedd to...