detecting duplicates is even more difficult than these other issues.

123 North Third

123 N. 3rd

123 North 3rd

123 N 3rd

123 N Third

123 North Third Ave

123 N. 3rd Ave

123 North 3rd Ave

123 N...

You might consider de-normalizing, storing a current address in each table where it is needed, having a historical address table that could be shared by those entities (with a M:N,...

Perhaps you could roll your 3 types of task into one table, then your timesheet records have only one parent. Create views that separate the 3 types of tasks...

Not sure, it shoed both columns for me... paste your exact code here I bet you just copied mine wrong 🙂

for totals... read this

http://www.sqlserverandxml.com/2008/09/tsql-lab-4-how-to-add-total-line-to.html

don't use a function? use a stored rpoc instead, tehn you can use dynamic sql execution? is that possible in your app?

josephptran2002 (12/4/2008)

---

Hi Bob,

How are you doing? you might say I'm very dumb on SQL. But I have to ask you straight question which relates to my project. I think without...

Joseph, for your first post's question, I would simply use a UNION

Select A

UNION

Select B

UNION

SELECT C

etc

you can use the date to string conversions mentioned in other posts...

I don't see where your "per user" criteria are coming from... how do you know that user1 sees clients starting with A and user2 those with B, etc...

Also do different...

I think in the long run you might be best off by creating simulators - small apps or scripts that produce transactions similar to production. Over time you could...