Post the code and sample data so we don't have to guess at this problem.

Ah, now that makes sens!

Thanks 😀

I'm not sure I'm following here Jack, can you explain a little bit more?

I built something like this once... took me a month (was in a bigger project).

If I were you I would not waste time on this matter. SSMS is the...

Lol, ya I forgot about that one... hoping that didn't screw up anything with the application. Only time will tell.

That actually might work in your favor if it did...

1st of all, autp update is triggered after a huge % of the data has been changed (5% or 20%)... not before that... so you have 1M rows, you need...

No they won't. You need to pick out the order so that the first column is the most granular... or makes the most sens for order bys.

In the case...

Maybe it's just me, but I was under the impression that SSN is not unique across the planet... that's why you need to have another column such as CountryId to...

It is. If you scan only syscomments, it means that 100% of the data access is done via stored procs or other sql objects.

Since it wasn't the case for...

I'd love to hear their reasons for wanting this... then I'd also love to have them read those forums!

I know... but it beats the hell out of adding 50 commas manually!!!

Anyhow, I still preffer the scripting option of the GUI.

Ya sorry about the "bad" news.

A little word of advice, if you are not forseeing any problems (performance, db size, etc.)... your time might be better invested elsewhere. Over...

SELECT

[name] + ', '

FROM sys.columns

WHERE [object_id] = object_id('TableName')

ORDER BY 1

That way you don't have to manually put the commas.

I'd preffer fail solution,...

The articles and scripts are posted to the site long before they make it to the newsletter. If you're lucky, you'll see it in the new post or active...

I did this manually once.

Search all the code on SQL server and all the code on the client application (search for each table name, also need to be carefull for...