Re: [SQL] Insert problem

2008-03-09 Thread Jamie Tufnell
On 3/9/08, A. R. Van Hook <[EMAIL PROTECTED]> wrote: > The script worked fine untill I tried in on the following entries: > > 1841 | 2 | 9228 : Caty Case : SO:Bra:. > 1841 | 3 | 9621 : Kelsie Greenlee : PROM. > > 2072 | 3 | null : Cookie Jared Cook :.. > 2072 | 4 | null : Cookie Jar

[SQL] Insert problem

2008-03-09 Thread A. R. Van Hook
I have a table where some of the entries of should have been posted to the wrong cusid and item#: cusid | item# | 1747 | 149 | 9251 : Jonathon Krinke ... 1747 | 150 | 10071 : Lindsey Steele 1747 | 151 | 10187 : Lindsay Stapley ... 1747 | 152 | 10188 : Amanda Gou

Re: [SQL] Composite UNIQUE across two tables?

2008-03-09 Thread Jamie Tufnell
On 3/7/08, Jamie Tufnell <[EMAIL PROTECTED]> wrote: > On 3/7/08, Bart Degryse <[EMAIL PROTECTED]> wrote: > > I haven't tested these two statements, but I'm using exactly this > > concept on some tables myself. > > My equivalent of your users table contains some 3,000,000 records. > > My equivalent