Search results for query: *

Here are several more things to try: 1) Restart the Biztalk Service on the Biztalk Server If that doesn't resolve the problem... 2) Make sure the map file contains the latest changes made to the input and output specifications. Replace source and destination specification in the mapper...

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

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

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

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

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