chris_masiero (10/6/2013)
I really don't know if being an expert is even required for 95% of jobs.
Correct... but I'm thinking that they expect someone who's applying for a job that involves the use of T-SQL can actually do the job.
I might even fail a 'test' in an interview if they wanted me to write something of the top of my head that involves some of the more exotic SQL.
But I'll bet you could write a joined UPDATE for two simple tables off the top of your head. I've interviewed a whole lot of people that don't even know where to begin. 😛
--Jeff Moden
Change is inevitable... Change for the better is not.