Is the number of rows/page gonna be dynamic at some point or will remain static. How large is that large dataset?

Are you sure this is posted in the right thread??

That's because you need a trailing comma for it to work.. but please check my solution and ask question if you don't get it.

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=231299

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=231299

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=231299

Please do not cross-post, we monitor all boards.

Finish the thread here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=231299

Flow control + 2 sps :-).

Wondering if it's because of different level of access to information... maybe the solution is different altogether than what originally thaught.

You might also wanna read this for more info.

Arrays and Lists in SQL Server

Why would you have different fields sent to the application??

You'll have to create an update trigger and add to the actual count, the number of times that the row was updated in the batch (can be more than once)....

The real question should be : "Should I denormalize or not?", not the other way around. On the long run, the wasted ressources caused by not normalizing the schema...

Can't tell without sample data... that's why this thread is still running.

Help us help you

What's the ratio of update VS selects you'd have to do against this table?

Set @sql = 'Update ' + @TableName + ' SET '

while Fetch...

@sql = @sql + @Colname + ' = LTRIM(RTRIM(' + @ColName + ')), '

end while

set @sql = LEFT(@Sql, DATALENGTH(@Sql)...