I use Excel 2007, under Data, I choose Microsoft query and it let me choose the table and the fields, and then you can put in filter in the field.

The script was written by a web programmer. It had cursor within cursor within cursor. The company never bothered to hire a SQL server DBA or developer until...

Actually it is a very large script. It extracts data from multiple tables from one database, does some checking and cleansing work and then put them into multiple tables...

DECLARE @Line VARCHAR(1000)

SET @Line = ''

SELECT @Line = @Line + c.column_name + ' , ' FROM information_schema.tables T

JOIN information_schema.columns C

ON t.table_name = c.table_name

WHERE t.table_type = 'base table' and t.table_name like...

When I was on call, the company provided me the cell phone and laptop. The laptop had VPN so I could work from home when I got a call.

Usually...

I am ISTJ. I did this test because there were 12 of us working on a project and we argued about everything everyday. So my manager made all...

Even the column is set to varchar(8000), it will not take up 8000 bytes, it depends on the actual size of the data.

DonaldW, I read the article from SELF magazine about woman having trouble to let go of bad manager experience.

A few years ago, I landed a job and this was the...

I always put in more than 100% at work. In one company, the manager promoted a programmer with less experience to be senior programmer. When I asked the...

I work from home and this is my first time. I was hoping it would help me to get away from all the company gossips and politics. But...

It depended mostly on the managers. Some managers gave me the project and let me decide how to tackle it. Since I was the senior staff and I...

I like Monk.

Here is one of my favorite from 'Gone with the Wind'

'After all, tomorrow is another day'

This company has no physical office. Even the CEO works at home. When I interviewed for the job, I went to the CEO's house. It is a e-commerce...

I just start working from home. So my home is my office and my office is my home. Now I cannot separate work from home. :crying: I don't...

Enroll in an MBA or Master's program. The Master's degree in MIS degree and many MBA programs were specifically created out of the need to turn engineers into managers. Personally...