You don't have a "Fred" column in your target table, but you do have one in your insert statement. Fix that part, and you should have a working solution,...

It's a clever solution to complex lookups in small tables (very few rows), where indexes won't matter. On larger tables, it's going to bypass indexes and quite probably slow...

I can't think of a way to do this without loops of some sort, either cursors or a while loop. Since changing the existing nested cursors to nested while...

You can use an inline function in a group by clause. I've done so. (It kills performance, but if it's necessary, it's necessary.)

Try running the select without the...

@@spid will give you that.

user_name() might be more useful, depending on the connection context.

Books Online has data on each of these and what they do.

In the case of patents, we're getting back into the chair-design realm, instead of the physical chair.

If you like the chair so much that you copy it, you have put...

In the case of the chair used as a flowerholder, or a "sitting fee", you can return the chair and the chair-maker then has control over it. You no...

You need to add a "GroupID" column, so that the first set is group 1, the second set is group 2, etc.

If you do that, then it becomes much easier...

For the concept of data ownership to be simplified, we have to simplify the concept of data work first.

If a person spends time and effort to make a wooden chair,...

Robert Davis (12/22/2006)

Of course, I don't think the author's intention was to claim that Context_Info was the solution to all of our security concerns. I think he merely chose that...

It looks to me like your "fromdate" field might be char/varchar instead of datetime. In that case, you'll get any string that starts with a character > "2" in...

select *

from table1

inner join table2 on table1.key = table2.key

inner join table3 on table1.key = table3.key

That's the SQL text. In Query Designer, I think you just drag the column from...

You need to change the first line of the first update command to "Update O" instead of "Update Orders". You used a table alias in your update query, and...

When you use "top" and "order by" together, they work together.

Thus, your first query select 3 and 2, because it first orders by sequence, descending, then it picks the top...

Generally, the best way is going to be to create a linked server (Books Online has directions on how to do this), and then use the 4-part name of the...