Forum Replies Created

Viewing 14 posts - 1 through 14 (of 14 total)

  • RE: Check Duplicates/Insert is failing

    The problem is that it will not insert my records if NOT EXISTS is true and if for example I have one matching record in my destination table that one...

    October 19, 2004 at 8:43 am

    #527193

  • RE: DTS Package Failed

    Thank you very much for your replies. I will try your suggestions.

    October 19, 2004 at 7:25 am

    #527174

  • RE: Best way to check for the existence of a record

    Thank you very much for your replies. Your help is greatly appreciated.

    July 28, 2004 at 5:25 am

    #516540

  • RE: Count(distinct columnName) Problem

    Thank you very much for your solution.  The query runs beautifully.

    June 10, 2004 at 10:20 am

    #509912

  • RE: Count(distinct columnName) Problem

    Thank you for your quick reply. This is what I came up with:

    SELECT     COUNT(DISTINCT A.serialnumber) AS Direct, COUNT(DISTINCT B.SerialNumber) AS Total, COUNT(DISTINCT A.serialnumber)

                          * 100 / COUNT(DISTINCT B.SerialNumber) AS...

    June 10, 2004 at 8:45 am

    #509892

  • RE: "Insert" Problems

    Thank you very much for your help.

    I specified column names in my insert statement and implemented the missing values in the Select statement, so that my Select statement is retrieving...

    June 2, 2004 at 6:13 am

    #508632

  • RE: Stored Procedure issue

    Hi,

    I modified the query a little bit and now I am getting exactly what I want.  Thank you very much for your replies.  I would not be able to figure...

    April 15, 2004 at 7:55 am

    #502933

  • RE: Stored Procedure issue

    No. The first record daily total should be 476.  This number should be calculated after the product is calculated (146)

    April 15, 2004 at 6:47 am

    #502909

  • RE: Stored Procedure issue

    Hi,

    I ran the stored procedure and got the following output.  Everything is working fine except that my data is not being grouped by date.  As you can see I am...

    April 15, 2004 at 6:17 am

    #502897

  • RE: Stored Procedure issue

    Hi David,

    It worked. I have to check the output next but so far so good.

    Thank you very much for your replies, I would not be able to figure it...

    April 14, 2004 at 9:21 am

    #502757

  • RE: Stored Procedure issue

    I added the )a and now I am getting the following message: Incorrect syntax near the keyword 'THEN', Incorrect syntax near 'a'. By the way what is 'a' used for...

    April 14, 2004 at 8:52 am

    #502749

  • RE: Stored Procedure issue

    Hi David,

    I like what you did with the query.  It looks much "cleaner" than before. However, I get the following message: Line 59 (highlighted): Incorrect syntax near 'Daily Total'

    Thank you.

    CREATE...

    April 14, 2004 at 8:32 am

    #502741

  • RE: Stored Procedure issue

    Hi Prasad,

    I fixed the comma before holidays but the error was the same as before.  My overtime fields need to be part of an aggregate function or contained in the...

    April 14, 2004 at 7:52 am

    #502724

  • RE: Stored Procedure issue

    Hi Prasad Bhogadi,

    Thank you for the fast reply but unfortunately it still did not work. This is the message I am getting:

    April 14, 2004 at 6:49 am

    #502698

Viewing 14 posts - 1 through 14 (of 14 total)