December 26, 2011 at 6:27 am
We have one application in which we insert into table (say A) from table B
INSERT INTO A
SELECT
B.IPT_CODE
FROM B
INNER JOIN PM ON PM.P_CODE = B.P_CODE.
At client place we are getting junk values(example ´) in table A some times but there is no junk value in table B.
Junk value like 'ABC-218005P19´' instead of 'ABC-218005P194'.
This does not happen regularly and is happening for other columns in other client Database as well in a week time or so.
Its happening in Sql server 2000 and Sql server 2005.
What can be the reason for this.
Please guide..
December 28, 2011 at 10:36 pm
Please suggest !!
February 8, 2012 at 4:14 am
do you have any triggers on either of these tables?, can you replicate this in test or DEV? process of elimination i think needed here, sounds to me at the point of insert into table B table A had value that was junc perhaps that is where you need to focus on?? maybe add in some validation into your insert script to eliminae any junc and or create an alert to warn you that junc has been inserted/updated into table A
***The first step is always the hardest *******
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply