Forum Replies Created

Viewing 15 posts - 10,321 through 10,335 (of 15,374 total)

  • RE: Need to show cumulative time

    Nice job posting ddl and sample data. Unfortunately it is very unclear what you are trying to do. Can you explain how you came up with the values that you...

    October 19, 2012 at 8:11 am

    #1550888

  • RE: Logic problem in "SET [Quantity_Remaining] = [Quantity_Remaining] - 1"

    briancampbellmcad (10/19/2012)

    Did I get the data you needed or other information for the testing? Just can't seem to find what could be wrong with this trigger...

    CREATE TRIGGER [dbo].[trDecrementBulkPurchases]

    ON [dbo].[tblTransactions]

    AFTER INSERT

    AS

    BEGIN

    UPDATE...

    October 19, 2012 at 7:42 am

    #1550868

  • RE: sql server checking equality of tables

    gowri.4ever (10/18/2012)

    with the script you provided I need to check for every table in the database..and there are more than 100 tables....it will be a very complicated and time taking...could...

    October 18, 2012 at 2:28 pm

    #1550684

  • RE: sql server checking equality of tables

    gowri.4ever (10/18/2012)

    I want to check if they have same column names and if their data type is same

    So run the query I posted. It will show you that information and...

    October 18, 2012 at 12:38 pm

    #1550652

  • RE: sql server checking equality of tables

    gowri.4ever (10/18/2012)

    hi,

    I cannot use the redgate and all...what i was asked to do is to copy all the tables in a database into a temp table and then do the...

    October 18, 2012 at 12:32 pm

    #1550649

  • RE: sql server checking equality of tables

    gowri.4ever (10/18/2012)

    Hello Everyone,

    I need to check if all the tables in a database are same(have same columns and datatypes) to all the tables in another database. and these two databases...

    October 18, 2012 at 12:12 pm

    #1550637

  • RE: Logic problem in "SET [Quantity_Remaining] = [Quantity_Remaining] - 1"

    Your trigger is intended to update tblBulkPurchases. I don't have any data in that table. I can' test your trigger because the update has no rows to update.

    October 18, 2012 at 10:48 am

    #1550608

  • RE: Logic problem in "SET [Quantity_Remaining] = [Quantity_Remaining] - 1"

    briancampbellmcad (10/18/2012)

    How should I paste the needed data? It becomes rather scrambled copying from SQL Server.

    PO_NumberBuyer_InitialSoftware_IDQuantityQuantity_RemainingUnit_PriceSoftware_DescriptionAllocationAccountPurchaseAccountHeatTicketNumberPurchaseCostCenterPO_DateTransaction_DateTransaction_NumberTransaction_Type

    3321809JDMNULL61956195NULLSYMANTEC ENDPOINT ENCRYPTION FULL DISKNULLNULL1581886NULL2011-10-132011-10-1322Bulk Purchase

    5447441TRE405050315.22OfficePro1321353424244445242145154222012-05-122012-09-1517350Bulk Purchase

    5465115OCC51200200120.20Apache3354825193219415995112542012012-05-122012-09-1517300Bulk Purchase

    5965215OCC51100100120.20Apache3354825193219415995112452012012-05-122012-09-1517309Bulk Purchase

    The best is to post an insert...

    October 18, 2012 at 8:58 am

    #1550542

  • RE: Create select statement for the query

    pwalter83 (10/18/2012)

    Sean Lange (10/18/2012)

    Thank you for the ddl and sample data. However your requirement mentions a column TEU. This is not present on any of the tables you provided.

    Sorry Sean,...

    October 18, 2012 at 8:15 am

    #1550519

  • RE: Are the posted questions getting worse?

    ChrisM@home (10/18/2012)

    Brandie Tarvin (10/17/2012)

    It's a disgrace, a disgrace I say. Why do you want to know what I know I know? It's a disgrace, a disgrace I say.

    Young fella, do...

    October 18, 2012 at 7:29 am

    #1550474

  • RE: Create select statement for the query

    Thank you for the ddl and sample data. However your requirement mentions a column TEU. This is not present on any of the tables you provided.

    October 18, 2012 at 7:26 am

    #1550470

  • RE: While Loop SQL Query Help......

    Gail is totally right. There is no need for a while loop here at all. All you are doing is copying a table to another table.

    insert #tblTest

    select cn, dn

    from #tblGroups

    Not...

    October 17, 2012 at 1:44 pm

    #1550211

  • RE: truncate table

    kapil_kk (10/17/2012)

    truncate is not working..

    Gives error-

    Cannot truncate table 'rolemaster' because it is being referenced by a FOREIGN KEY constraint.

    Did you read Gail's post?

    Pay close attention to the second part.

    or,...

    October 17, 2012 at 1:38 pm

    #1550207

  • RE: truncate table

    beebkhan (10/17/2012)

    you need to find the table that is referencing the data in your rolemaster table and remove it before you remove it. otherwhilst you will have a lot of...

    October 17, 2012 at 1:37 pm

    #1550206

  • RE: Create select statement for the query

    pwalter83 (10/17/2012)

    robert.gerald.taylor (10/16/2012)

    pwalter83 (10/16/2012)

    I have a requirement to create a CASE statement for the following condition:

    SUM of NCV_BL.TEU where NCV_BL.POL_LOCATION_CD or NCV_BL.POD_LOCATION_CD is not present in MG_VSLVOY_SCHEDULE.PORT_CD for the SAISAN_VESSEL_CD,...

    October 17, 2012 at 1:34 pm

    #1550204

Viewing 15 posts - 10,321 through 10,335 (of 15,374 total)