Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Nithindev

  1. Nithindev

    Trigger Locking the Table

    I am inserting records from excel sheet using SSIS package which can fire triggers.When I execute the package or just use insert statement to insert records the table gets locked and it shows error in SSIS messages and just shows "executing query..." and never completes the query.
  2. Nithindev

    Trigger Locking the Table

    The code is : USE [Religare] GO /****** Object: Trigger [dbo].[clientpanno] Script Date: 10/22/2008 11:16:40 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER trigger [dbo].[clientpanno] on [dbo].[ClientCode] for insert As Begin Declare @ccid as int Delete from...
  3. Nithindev

    Outer join returning more rows than in the table!

    Thanks all, the problem was client table had multiple rows with with same client_panno that's a logical error.We are not supposed to have it that way.
  4. Nithindev

    Outer join returning more rows than in the table!

    The two queries are returning two different no of rows.Outer join is not supposed to duplicate the rows in the first table right?How do I correct this. select * from clientcode order by cc_clientcode result:(5627 row(s) affected) select...
See more

Part and Inventory Search

Back
Top