and therefore can not afford spell checking

Looks like you missed one change of IN to ''="

UPDATE Netzplan SET Frühester_Anfang IN vs. UPDATE Netzplan SET Frühester_Anfang =

Thank you both. I am glad to see it's not an obscure system table. I can rest in peace now!

Toni

I am not confident about understanding what you want done. If you need to execute the same statement to run everytime before the stored procedure runs, why wouldn't you...

Actually the Coalesce does not add anything since the first when clause handles a null '@x' variable already.

Toni

You could get the results without the overhead of distinct by checking for occurence of name in the string built thus far through a Case statement:

Declare @x VARCHAR(100)

SELECT @x...

I believe you can use the sys.foreign_key_columns table (See BOL) to determine what schema the foreign key belongs to...

SQL Server 2008 Books Online (November 2009)

sys.foreign_key_columns (Transact-SQL)

Contains a row for each...

Hi. I am sure you will correct me if I am wrong here but wouldn't Nittin's statement drop all the foreign keys from all the tables including those...

Wish there could be a similar illumination on the foundations of the other "ism" referenced in the article. Ageism is very real when it's thought that anyone over...

Some form of Job security and protection against outsourcing.

Erik, for this particular table if you add an identity column to your sheet1 table you can make your WidthHeight table without loops and all. Now, there is probably...

I am going to defer to Jeff. I don't think I am anywhere near the same mind set as you are on this one. I think you...

Erik. I am not sure what you mean by the % in the columns. From your sample grid (second post) it looks like you have the cost...

Jeff, Erik was addressing the question to an earlier post of mine that addressed only the original question and did not address the added complexity of the second grid which...

Now that I've looked at the second grid, that sure adds a bunch of complexity as there does not seem to be a straightforward algorithm for the pricing. ...