Don't let the intro to the intro put you off too much (I have to admit, I almost gave up there, myself). They get better as they get into it but, yes, they do some stuff that I'd never do and I'm no XML ninja. My worry is what newbies to SQL Server may get out of it. They seem to cover syntax and capabilities with no real world experience or coverage of caveats. I think that's, with rare exceptions, the problem with most computer training and books, though. There are so many holes you could go down on any subject within SQL Server that you could spend most of the time on the holes instead of the subject. Like the old saying goes (from the Mayflower donut shops?) ....
"As you ramble on through life, Brother,
Whatever be your goal,
Keep your eye upon the doughnut,
And not upon the hole."
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)