Openquery and Link server both does not work for function.

Function only works within its own database.

I am not sure the Analysis Service is on Developer version, I think it is only on the enterprise version. I remembered when I installed the enterprise version client...

Analysis Service is totally different product of Sql Server 2000. You have to install it from the CD.

I wish I have the confidence to find a job in 4 to 6 weeks. So far I haven't found anything - permanent or contract job for 4 months.

Maybe...

Steve,

When you said you put out posting guide, did you mean for posting T-SQL question ? There are many forums that they are tough to create a template, they...

I don't think you can put a 'SELECT' statement inside a CASE statement.

Actually I tried to answer that question, it was quite a challenge !!!

Sometimes it is hard to write a question, I read a question that is a page long with...

I was working on a software company that sold high education software.

Table - Student

StudentID - automatically generated

Social Security number

Student Name

Birthday

Gender

Nationality

Race

Email Address

Father Name

Mother Name

Table - StudentAddress

AddressID - Auto generated

StudentID - FK...

karthikeyan,

There is one thing I don't understand. Your title is Senior Software Engineer and what kind of work you are doing so far. It seems you do not understand...

BTW I am here in America for over 20 years, my English is not perfect. Some people still tease me about my grammar. However not one of my...

English is my second language too. When I first came to America, my English was not perfect. However people were more patient than you thought. If you...

My former manager was a saavy manager and he wrote all the ETL procedures before he became the manager. He attended the Microsoft BI conference too

but it did not...

Can you show some example in each table?

Employee table has duplicate records, what is the difference between employeeid and Employee Number?

Employee and Employment is linked by employeeid. Does one...

I don't understand what value you want to get. Can you show how to get the value by hand? I don't understand the category part.

I am not sure this will get what you want since I don't have the data and I don't understand your system, but you can try.

SELECT K.KRR_COM_id AS CompanyId, C.CUR_code...