Yes I also noticed what stax68 found and the outer joins could be your problem. However if you have true duplicates in both Case30 and CASEOLDR then this should do it. SELECT c.Case30.Case_no#, c.Last_name, c.[First Name], c.Determination, c.Sender, c.[Case Type], c.Date, c.[Qwik Due], c.[Qwik sent date], c.[Final due], c.[Final sent date], c.[on hold code], f.reportid, […]
2003-06-23
Hi Allen, quote: Is full-text search case sensitive too if SQL Server is installed as case sensitive? I've never noticed case sensivity on full text search. Cheers, Frank
2003-06-19
2 reads
Don't know as my db's are case-insensitive anyway. However did find this snippet in BOL Note The full-text search queries behave in a case-insensitive manner for those languages (mostly Latin-based) for which case sensitivity is meaningful. However, in Japanese, there are multiple phonetic orthographies in which the concept of orthographic normalization is akin to case […]
2003-06-19
2 reads
Great suggestions/feedback. I really appreciate everyone's input on this. beachidly, I also use an Access front end. I assume in your process you link the newly created table to the front end, after you've created and populated it....
2003-06-18
1 reads
Not sure if I have fully understood your question, but the normal way to avoid duplicate rows is to use primary keys. The code is: alter table <table name> add constraint <object name> primary key (<column name>) Hope it helps.
2003-06-18
Es gefaellt mir, dass die Erklaering Ihnen Hilfreich war. Ich habe Deutsch seit neun Jahre in der Schule gelernt. Zwei Woche lang als ich funfzehn war, habe ich mit einer deutschen Familie gewohnt. Ich hatte auch einen guten Lehrer in der Gymnasium. In seinem Klassen koennten wir nur Deutsch sprechen. Mit ihm habe ich viel […]
2003-06-16
2003-06-11
1 reads
Thanks everyone. I will work with what we have. I appreciate everybodys input. --Joe
2003-06-11
2003-06-11
Why don't you just throw away the starting balance and only keep the ending balance in the table? Keeping redundant data like this is almost asking for inconsistencies to develop.
2003-06-10
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers