Forum Replies Created

Viewing 15 posts - 1 through 15 (of 40 total)

  • RE: Query

    Sorry ignore the previous one....

    SELECT    ETY_EMPNO, ETY_EVENTDATE, MIN(ETY_INTIME), MAX (ETY_OUTTIME)

    FROM      YourTable

    WHERE    ETY_EMPNO = @EmpNo

    AND        DatePart(MM, ETY_EVENTDATE) = @Month

    GROUP BY ETY_EMPNO, ETY_EVENTDATE

  • RE: Query

    SELECT    ETY_EMPNO, MIN(ETY_INTIME), MAX(ETY_OUTTIME)

    FROM      YourTable

    WHERE    ETY_EMPNO = @EmpNo

    AND        DatePart(MM, ETY_EVENTDATE) = @Month

    GROUP BY ETY_EVENTDATE

  • RE: Copying one or two tables from a different server

    I think following will work for you.

    Run this script on your Server

    USE [Master]

    GO

    EXEC

    March 20, 2006 at 11:38 pm

    #627787

  • RE: Query

    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

  • RE: Databases are not accessible

    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...

  • RE: Query between join database

    I think following should work

    select A.*, B.*

    FROM DBA.dbo.TABLEA A INNER JOIN

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

  • RE: Scripts of Cubes and DTS packages

    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.

  • RE: SSIS Job run in SQL Agent

    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...

  • RE: SSIS Job run in SQL Agent

    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....

  • RE: 3 Questions

    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

  • RE: Info of Jobs & Schedules

    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...

  • RE: Avoiding Subquery in UPDATE

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

  • RE: Scheduling Backups

    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.

  • RE: Info of Jobs & Schedules

    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...

  • RE: Avoiding Subquery in UPDATE

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

Viewing 15 posts - 1 through 15 (of 40 total)