The correct answer should be...

... change the column in the table to the correct data type.

My experience with resumes is that when people say they want to "Beef Up" their resume, they really mean "stretch the truth" about experience and knowledge. One of my...

With the possible exception of some RegEx functionality, what is it that you think cannot be done in T-SQL without the use of CLR's?

If you setup Query Analyzer in the Text mode and use Tab's to delimit the data instead of commas, you can copy and paste directly from the Text results window...

Concur... trips through CHAR/VARCHAR conversions are somewhat slower especially over millions of rows.

Or, if the indexes are correct... an Index Scan which can be a little faster because there's usually fewer pages to step through. If...

Yes... it works.

No, no difference to the sever.

Yes... difference in readability but depends on what you're used to. I prefer the use of "=" to "IN" for single value...

This would be a very good place for you to lookup the POWER function in Books Online... it has a full explanation.

"Set-based" is the whole idea behind databases......

You code calls on V-1... i see no example of V_1.

Further... all of these views call on the table EmpBase... why do you need the views at all?

Instea of trying...

You crammin' for an interview or a test? Or, is this a take home test.

Please, do your own homework.

Not sure, but I think i answered this on the other post.

Yeah... you do...

Nope... that's pretty much it...

That's not a whole lot of information for me to go on...