The only suggestion I can give at this point since all of the real code is masked in the table tha holds the where clause, but here goes;

You might be...

And sometimes I cheat by opening up BOL and trying to find the answer by digging through the articles before I actually answer the question. (Not that it...

The behavior is exactly as it should be as has been said. And as for a warning... why would you warn when it does what it is supposed to...

Also you will want to read this

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Here is an example of joining them together.

Just a guess. However, you are doing full outer joins, so appearently there are some nulls involved.

IF OBJECT_ID('tempdb.dbo.#a') IS NOT...

Actually in the converting of the columns, the SSMS (and most other tools) will duplicate the table, copy the data into it, and then drop the old table.

This...

As a few others have said, you aren't being exactly clear as to what it is that you are actually trying to do.

Perhaps if you explain a little about...

I know you said altering, but I am assuming you meant executing.

What is the command that you are trying to run? The reason I ask is because...

Actually that one is pretty easy... 😉 This...

toniupstny (1/23/2008)

---

You can use the stored procedure sp_msforeachtable to do truncates on each table in the database.

sp_MSforeachtable @command1 ="Truncate Table ?"

Be sure you are in the right database before running...

I tried it, and the on update cascade will fix the issue, but it will cause a ripple effect on the system that is really not necessary.

The OP already stated...

First of all, you missed the point. The ISNULL is not for the PK field, but the variable. You are just checking against the PK Field.

As for...

Change MASTER TO your DB name

@tblName = 'MASTER.dbo.tblTranLogs',

Change to the name of the column you want to group by

@GroupName = 'dbname'

kirk (1/24/2008)

---

I...

Also if the issue is how long it will take to construct the SQL with the 99 max's this should help.

DECLARE @sql NVARCHAR(MAX)

DECLARE @tblName sysname,@GroupName sysname

SELECT @tblName = 'MASTER.dbo.tblTranLogs',

...

I went ahead and submitted the bug. (didn't see one). I'll try and remember to update this post when I get some feedback.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=323974