I'm not sure they're correct. If a row has factor 0.20 then it will be in both ranges.

The OP must either...

I have to be honest and say that I haven't used it before, but as understood by the documentation, it checks which columns where updated according to their position in...

Dird (6/5/2013)

---

The problem with that is you'd have to create the table separately, when you...

You'll be surprised, but programming isn't something you can...

Dird (6/5/2013)

---

Using recursion? or would you class it as a...

By the way, are you sure you need "IF (COLUMNS_UPDATED() & 14) > 0" or you just copied from somewhere else?

You're on the right track. Just as you got the old values from the pseudo-table DELETED, you can get the new values from the pseudo-table INSERTED.;-)

You could ask for a query with a LEFT JOIN that need a filter on the right table, knowing that you would look for the condition to be specified on...

DiverKas (6/5/2013)

---

Assuming you have down time, my suggestion would be:

Merge all your tables into one table with no constraint, with an additional column indicating the source database/table it came from....

But you have to check all of your dependant tables to update the values. An option is to check your Foreign Keys are specified as ON UPDATE CASCADE.

It's hard to...

What came to my mind is that 2 users tried to insert a row at similar times and both got the same ID from the VB function.

Why don't you have...

That sounds like a lot of work to do when you think about it.

You should either add a Client ID to each table to preserve uniqueness when merging all the...

If I understood correctly, you need to pivot your data. A great way is to use CROSS TABS[/url]

With your data pivoted, you can concatenate the columns as you need them.

--I...

Maybe some code like this

SELECT FirstName, LastName

FROM(

SELECT FirstName,

ROW_NUMBER() OVER(ORDER BY FirstName) rn

FROM( SELECT DISTINCT FirstName FROM MyTable)x) a

JOIN (

SELECT LastName,

ROW_NUMBER() OVER(ORDER BY LastName DESC) rn

FROM( SELECT DISTINCT LastName FROM MyTable)y...

How about using names from AdventureWorks DB?