You are not checking for existence. 

IF EXISTS( SELECT * FROM PhotoXRef WHERE itemid = @itemid AND BPCSProdId = @BPCSProdId)

     BEGIN

          INSERT

     END

ELSE

     BEGIN

         ...

Boy I hope someone in my wife's company reads this!  They have their data center in Florida.  Having been through a Hurricane (Fran) in NC - this is truly EXCELLENT...

I gotta go with Remi and Kenneth on this one! We use Crystal too, (it is very picky).

This is a process problem and probably something you cannot directly effect...

Whoa!  I think Kenneth just offered another alternative, (derived table select)....   

Personally, I like having a plethora of alternatives...

I generally work through lunch and often bring stuff home - but I also try and keep up with my co-workers.  Religion has often a topic of conversation, (like politics,...

Doh!  A least I was consistently knuckleheaded....   

Thanks folks! 

I agree with much of what you said, SA from CA.  But I do not see any malice in John's thread.  I doubt he would think you unfit... 

Good thinking! 

got me... I couldn't think of anything better to say...

(I got family in Canada and you'se guys talk funny....) 

frickin' frackin' show-offs!!!  (and tattle-tales...). 

Sometime look up Coulomb's Law and compare it with the Theories of atomic structure.  I have faith that the floor will not push a hole into itself when I make...

One of the signs of a good leader is knowing when to delegate...  

ain't cracked...  you know-it-all people can mask a URL with fancy-schmancy words (like Hair Thread). 

You should learn from sushila - she's got 'text' funny-bones riddled through her body...  

I said "with" humor....