As stated above, your requirements are unclear. If you are looking for MAX values, I don't see any duplicates in your data except for descriptions and codes in #TableC....

Jack, I disagree that the best bet is...

I think of Schemas as SQL Server's version of namespaces.

Your basic question seems to be how to get the statement in a trigger to work, so I will try to answer that.

In a trigger, you have access to two...

This may not be the best way, but it works for my current situation. I create a procedure that lists all the columns as parameters, with "default" values (with...

sqlfriends (2/9/2012)

---

My question is if I copy all the 5 statements together into one query window, and hit Excute,

will that execute one by one, could that possibley happen that...

32 levels is not the limit, it is simply the current maximum depth. I am not using a CTE to build the recursion; the code I have now was...

Jeff Moden (2/7/2012)

---

I'm just curious. What type of hierarchy are you using? Adjacency list, Hierarchical Path, HierarchyID, Nested Sets, cfomposite of 2 or more of those? Also,...

What I am suggesting is that you create a complete hierarchy that...

This code will not work...

Depending on how often the products change, it may be worth putting this data into a permanent, indexed location so that it does not have to be requeried on the...

I suggest you use the NVARCHAR datatype to be consistent with the doc_family column.

You should "ALTER COLUMN" rather than "MODIFY COLUMN".

To get the the beginning of the "from" date, CAST the first expression to a DATE datatype; that will strip the time portion completely.

To get to the end of the...

I believe the problem is that you are using CHAR fields rather than VARCHAR fields. CHAR fields are always padded to the specified number of characters. Convert to...

The way I would solve that problem is to use a temp table.

Step 1: Insert all the names into a temp table that contains an IDENTITY column, sorted by the...