No thank you and everyone else for the insight. There's always more than one way to do something, but at the end of the day make sure that it's...

That worked! I got the same results that I initially had from using the while the loop and iterating over the temp tables.

I'm working on refactoring and implementing as such. I will let you guys know of my results when doing so. Sorry for the delayed responses, but have some other...

Thanks John and to everyone else. I will implement the new stored proc. Thanks to everyone for helping out with this one. I'm trying to beef up my...

Thanks Wayne. Unfortunately, the tables cannot actually be joined because someTypeID and ID are not the same (or someTypeID is not a foreign key reference to ID). Basically...

Here's the DDL. Sorry for the delayed response.

CREATE PROCEDURE [dbo].[myProcedure](

@ID int

)

AS

CREATE TABLE #TableA(

ID int,

ColumnA1 bit DEFAULT(0),

ColumnA2 bit DEFAULT(0),

ColumnA3 bit DEFAULT(0),

ColumnA4 bit DEFAULT(0),

ColumnA5...

Thanks for the reply and willingness to help John. See my previous post before yours. All is working fine now. Once again, thanks.

Nevermind. Found what it was. Forgot to increment the row index.

Just to understand a little more, doesn't varchar(max) allow for 2^31-1 bytes (or characters)? If that is the case, is it such that even though it allows for appx...

Thanks to all. I'll handle at the application level.

There are only two fields with varchar(max). I guess at the application level I could check to ensure that they do not enter no more than allotted amount of...

So based on your comment it's probably safe to say that one of the varchar fields (which in this table are all max) is being provided with a value beyond...

That worked. Thank you sir. 🙂