Benoit,

Being a project manger, you know a lot more about DTS package and SQL server than some of the SQL Server developers I know.  My company will never let a...

Robert

I don't like to encrypt the sript because there is no way to undo it. If anything happens, I have no way to debug it.

My problem is I have a...

Do you need to put in Log in ID and Password in the bat or exe file ?

Are you a SQL Server deverloper ro DBA?

I have a question.  Sun microsystem does a lot of good things. The UNIX system worked wonderful.  They also the first on introduce JAVA which would run from any platform. ...

If you have three databases, which database do you put the common tables and processes?

I would use a new database for comman tables and processes, if it is meta data tables, definitely...

Ralph Kimball is an advocate for enterprise data warehouse while Bill Inmon is an advocate for data mart. 

In Ralph Kimball's datawarehouse book, he mentioined using both star schema and...

I will vote for Condi Rice too.  But Hillary Clinton, I did not even vote for her for senator even I live in NY. But unfortunately NY is a democrate...

I want to know if you don't use xp_cmdshell, what can you do to solve the problem ?  Can you use execute process task ? 

I am trying to do...

What is the salary range and would they consider working offsite?

I live in Rochester, NY.

Can you change the datetime field to character field before the transfer?   Each database (for example Oracle and SQL Server) has its logic to process the date, that's why it is not...

Fact and dimension tables are totally different.

Fact table contains measures and different dimensions.  Dimension tables just contains information about that particular dimension.

I don't understand your question about fact table as...

Thanks all to your advises.  I feel you all care about me more than anyone around me at work or at home.  Once I told my husband I had some problems at work, he...

Another way

SELECT CASE WHEN ih.oppidfrom IS NOT NULL

            THEN 'YES'

            ELSE 'NO'  END

FROM Indicatorhour ih

  LEFT OUTER JOIN author a ON a.oppid = ih.oppid where empid=O.empid

 IF EXISTS (SELECT ih.oppid from Indicatorhour ih

                           inner join author a on

                                                a.oppid=ih.oppid

                            where empid=O.empid)

    SELECT 'YES'

ELSE

    SELECT 'NO'