I dont understand you requirement completely, but i think following will work for you.

SELECT   *

FROM      YourTable

WHERE    ETY_EMPNO = @EmpNo

AND        DatePart(MM, ETY_EVENTDATE) = @Month

AND        ETY_INTIME >= @InTime

AND        ETY_OUTTIME <= @OutTime

Thanks, but i have already solved the problem, well i took a different rout, i detached the database but it gave me an error that it is not available, but...

I think following should work

select A.*, B.*

FROM DBA.dbo.TABLEA A INNER JOIN

        DBB.dbo.TABLEB B ON A.Id = B.FId

thanks alot,

the picking up the configuration from table is a good idea, but what about the cube, i have to create the cube as well for each pair of configuration.

Jamie,

U also reffered me this article in my post, and i opened that link but its just about the explanation of the erros of Scheduling packages.

What i want to know...

Jason can u plz tell me how did u create the SQL Agent job for package, i need a detailed reply, what commands or functions did u use for packages....

Steve thanks for the information it is indeed useful, but actually i am just a beginner to the AS, so all this stuff was a bit high level for me

I have to use following four tables, but 2 are working fine, one is giving me error and one is not giving me the result........can some one suggest me the...

JG can u plz tell me wat error will be raised by the "other query"

Can u plz ellaborate the process of making the maintenance plan, as i cant see any thing related to maintenance plan in the Business Intelligent Studio.

Actually i want to write a code that will delete a job if it already exists,

Now i can use EXEC sp_delete_job to delete the...

also tell me is there any way to update the columns of more than one table in a single Update statement.