Thanks Florian for a buggy script. That thing just fried my server. :angry:

It is hard to understand the structure of your tables and views from the description you gave.

But if I understand the problem correctly I would suggest a slightly different approach.

I...

Not always it depends on ANSI_NULLS setting

This is from books online:

Care must be taken when comparing null values. The behavior of the comparison depends on the setting of the SET...

Yes, I think that would be fine.

Just to clarify. #temp objects do not have to be explicitly distroyed. they are local to the scope of execution so in your case after the query runs it's course...

Please avoid double posting.

Original post here

http://www.sqlservercentral.com/Forums/Topic686970-146-1.aspx

It sounds like you may be better off with local #temp object instead of global ##temp object.

This might help.

SET @dynSQL = 'SELECT * INTO '

SET @dynSQL = @dynsql + @NewTableName

SET @dynSQL = @dynsql + ' WHERE ClaimNumber = ' + CAST(@ClaimNumber AS VARCHAR) +...

I think I would use another approach. A slight modification to your option 3 without the dynamic SQL.

Pass the keys in VARCHAR.

Call a function to convert it's elements to a...

I think in this case you would want to have a VPN connectivity between UK and France and Germany, between the offices, not individual desktops. To do this you will...

I did not use the word 'horrible' 🙂

I understand that we need the paper books to ease the learning curve, but the more you know the harder it is to...

It depends. I do not understand what your application is going to do and why the Server is accessible over the web only. Who are the users? Individuals or remote...

Remotely? How?

Directly over the internet? - Bad idea. Unless you are a security expert I think you going to get the server hacked before you finish your coffee.

Using a...

Could you please elaborate more on this one. Do you want to access the database from a web server (IIS for example) or do you want to access the database...

I do not buy the technical books anymore. In most cases there are two major problems with most of them.

1. They are not accurate, full of mistakes. Did anyone notice...