Its a bit like working with fractions - find the lowest common denominator and work with that. In the case of data, its often the csv file, and its...

This sort of jogged my memory when I read it, and believe it or not, two days later I actually needed to do it. Here's my 'real world' example...

It would be handy if there were no syntax errors.

They're all great points, but my personal experience has been that its the Business users, who think they can develop an application, not the "real" developers, that are the problem.

Tony Savoie (9/29/2010)

---

I am currently stuck in the scenario Old Hand describes......with the addition of "rock star" developers who design their own databases, in Access, do all of their .Net...

Sorry to bring this up again, but I'm trying the above in SSIS 2005, and am getting the following error

Unable to cast COM object of type 'System.__ComObject' to class type...

Good point:cool:

Without trying to derail the editorial, I really did think my wife and I were pretty much alone in the non-facebook (etc) world. Family and friends are always...

Being possibly the only person in the universe that doesn't have a twitter account, a facebook page, a myspace page or anything else like that (other than a linkedin page),...

Thanks for the reply, but what I wanted to know is whether 'update' also includes 'insert' and 'delete', especially when you have a trigger (i/u/d) on the table, as an...

Ah yes, but you can set sql refactor up to format however you like. Mine is set to leading commas, 'on' clauses on a separate line, 2 spaces indent...

I personally prefer leading commas, as they're much easier to see, especially when you line them all up, but in response to Jeff, while you're correct in that if you...

Commenting:

I like to see a comment block/change register at the top of each stored proc/function, something like

/* ************************************

Name: pu_mytable

Purpose: Updates dbo.MyTable with values from dbo.MyOtherTable

Date...

What I *really* hate is the clown who decided to name the columns with reserved words...

SELECT id

, database

...

Its such an easy thing to do, but until you go start trying to maintain code that is poorly written, you'll never really understand WHY you should lay everything out...