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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anithamg
  • Content: Threads
  • Order by date
  1. anithamg

    Batch Insert using trigger

    We are transferring huge amount of data btn SQL Server. Let's say there are 3 destination tables 1. Tabe A [Master Table] ID Name 2. B ID1 Name 3. C ID2 Name All the ID's aren't autonumbers. That means I need to take max(ID)+1 and insert into them. For each 'A' record there are...
  2. anithamg

    XML input to Stored Procedure

    I've a SQL stored procedure with an xml input parameter and an integer output parameter. Whenever there's a large xml input feed to the stored procedure, I get wrong output value with some large number. I've even tried not including any statment in the stored procedure and hard coded return...
  3. anithamg

    XML parameter to Stored Procedure

    I've a SQL stored procedure with an xml input parameter and an integer output parameter. Whenever there's a large xml input feed to the stored procedure, I get wrong output value with some large number. I've even tried not including any statment in the stored procedure and hard coded return...
  4. anithamg

    Subquery in delete statement

    delete tbltravel as tt1 where tt1.travelerid, tt1.recordlocator in (SELECT tblTravel.TravelerID, tblTravel.RecordLocator,max(TravelDate) FROM tblTravel group by travelerid,recordlocator having max(traveldate) < date()-30) This doesn't work def.. I need a solution where u can condition on 2...
  5. anithamg

    SELECT QUERY IN IIF STATEMENT

    SELECT IIF((SELECT COUNT(*) FROM TBLITINS)>0,1,0)) FROM TBLHOTELS DOESN'T WORK. CAN I'VE A QUERY IN IIF STATEMENT??

Part and Inventory Search

Back
Top