On the other hand... it depends on how critical performance is, but actually performing an exists check before doing either an update or an insert is just a waste of...

Try this syntax instead:

RAISERROR ('Exiting script', 25, 1) WITH LOG

/Kenneth

If you don't want to (or have the possibility to) change the schema, you could order by a CASE statement.

select * from days

order by case dayname

  when 'Monday'  then...

It seems that when trying to insert into a table, you get the message 'Server: Msg 6819, Level 16, State 1, Line 4

The FOR XML clause is not allowed in...

This isn't 100% - there can be gaps in the ordinal position sequence, which then will offset the ordinal values from the actual columns in the current table definition.

The anser...

Unfortunately, that's not going to work so well - it doesn't provide the output you may expect. It's often not a good idea to rely on supposed defaults, it will...

Having just glanced through the plan and seen the extensive piggybacking of views on views and functions all over the place, I can just say that I'm not surprised this...

Why not look at the 'problem' from the other side?

You have n rows in one table, and based on those you want to update two other tables... What about doing...

It would be a little easier if you could explain what you are trying to do - how the desired result should look and your intentions with it. A few...

I've been around for a while... You tend to see some 'stuff' from time to time...

/Kenneth

Well, perhaps you could summarize it?

I'm asking, not because I'm too lazy to read, but because sometimes when backtracking and gathering together suggestions, what one have done etc, might bring some...

Don't forget the thing about change control. It's better to work on that as well, so it is ready when you're done with the mapping. If not, it may be...

One resource often underestimated, or just plain overseen is the system procs already on the server. They may not be all estethically perfect, but provides some good reading nonetheless.

/Kenneth

The BOL article 'Expanding Hierarchies' shows a solution to a similar scenario.

/Kenneth

There are many ways to achieve this.

Perhaps it's better for you to look up 'distributed queries' in Books On Line to see what is available.

/Kenneth