When I worked at the bank, everyone could change the data had to take turn to take 2 weeks off at audit time.  This way, they said if you had...

Professional does not mean you have to dress up to work.  Of course you don't wear a short, a pair of flip flop and a torn T-shirt to go to...

Junior DBA, Senior DBA, Junior SQL developer, Senior SQL developer, most of these titles were based on how many years of experiences on the job?  However, some people do the...

The most important thing of a good team is people dynamic. I was in many teams.  In some teams, some developers were so arrogant that they thought they knew everything, it ended...

Students cheat all the time, not just at Duke, but at a lot of universities, even in high schools, middle schools.  They don't want to study but want to have...

In most companies I worked for, when they chose a product, they had the salesmen coming in to do a 'wonderful' demontration and promised that they could do anything you...

Two hundred lines of SQL query - you mean in one query?!

I wanted to know how the developer wrote this query.  BTW what's wrong with this query that you need...

Thanks for all your comments.

I wrote this article is kind of sacrasm.  I did a lot of projects, most of the projects had talented team of programmers working on it. ...

You meant you wanted to update the field with 'No Data here' ?

UPDATE TableA SET Field1 = 'No Data here'

I hope I am reading your question right.  You want to execute a stored procedure with output value inside another stored procedure ?

CREATE PROCEDURE procA

DECLARE @percent INT

EXEC procb '1', 'A', @pc...

Do you mean to add a sequence number in the table?

To rate the smart companies based on the finanical performance, I am sorry I totally disagreed with that. 

I agreed with Bill Gates and I agreed with the article.  Over the years I only met a few excellent programmers, they were the ones never stop learning and made...

Computer science is not dead but it is not as popular as 10 years ago in college, thanks to all the big companies outsourced to other countries.  The employment outlook...

First I don't understand why you have a table for 'Switch Haart' and a table for 'Changed Haart', and a table for 'Switch Haart Reason' and a table for 'Changed...