You guys are right. Inside the SQL, it used views and functions that I did not know. I did not write the SQL myself.

Now I fixed the SQL...

As a SQL Server DBA and Developer, how can you have a clear mind 10 hours a day? That's why I wonder about the productivity level.

I did...

BTW, Can I email my resume to you?

Also I put down 'Main' in the Entry method and it seemed to work.

I agree that the address table should be separated from the student table.

STUDENT

studentid (PK)

Studentname

StudentAddress

addressid (PK)

Addresstype

studentid (FK to STUDENT)

Address

city

state

zip

If you want to normalize it, you can create a...

Me three !!!! I hate SSIS !:crazy::angry:

I used to work for a software company for higher education products - student info, admission, registration, financial aid... for colleges.

What kind of system are you designing - just the...

You can go to Monster.com and see if there are international jobs available. Yes in most cases you need a working visa in most countries (except Canada). The...

Too often I have seen the loudest employees rise the ladder of success, and good employees doing their jobs silently stayed unrecognized.

While the loud employees give at least some indication...

Maybe I work with data warehouse. I think learning business intelligence (data warehouse) is necessary.

A lot of DBA job description these days includes T-SQL, SSIS and Business Intelligence experiences.

As a matter of facts, a lot of companies hire DBA/Developer instead of just DBA.

It is SQL Server 2000 so I cannot use RANK, that is why I posted the question in this forum.

The one you posted for SQL Server 2000 worked liked a...

Is there any advantage to migrate from SQL Server 2005 to 2008 if there are not much difference?

I like landscaping and cheesecake baking too !!!!! If I have a second career, I will choose landscaping.

How many of you stay in this business because of the money or...

"We did work in other fields in our '95 study. It was a slightly different pool, but we found that women across industries will often take a brief break --...