+1 with Merge you only have to run 1 query instead of 2 (one for insert one for update)

MERGE MSDN

what i expected to...

Lowell (5/7/2012)

---

i guess it depends on what you mean by failed. do you mean:

1. zero rows got deleted, but you expected it to delete something,

2. or do you...

T-Rex

its not 100 percent but when an index is rebuilt the statistics get updated. you can use the following to kinda see when the last time it was rebuilt....

your right those dont really look like bad fragmentation numbers. im at the end of my knowledge here. with the incorrect data getting in have you tried rebuilding...

what does the string look like? are there nice delimiters or is it a fixed width set up?

with delimiters have a look at Jeff Moden's DelimitedSplit8K[/url]. if its...

Coming from BOL:

then...

From my limited testing you can use the following code:

SET CURSOR_CLOSE_ON_COMMIT OFF

DECLARE @ID INT

DECLARE test CURSOR FOR

SELECT productID FROM product ORDER BY productID

OPEN test

FETCH NEXT FROM test INTO @ID

WHILE @@FETCH_STATUS...

bostonjoey (5/4/2012)

---

Hmm...seems like I was overthinking tremendously! Thank you for your help. I apologize for not being clearer in my explanation earlier, I should of posted the supplementary information. I...

Eugene Elutin (5/4/2012)

---

Jeff Moden (5/3/2012)

---

BWAAAA-HAAAA!!!!! Ask that question on the receiving end of an interview and...

i was attacking it the same way lynn was and my code is very similar. i may suggest making idLigne an INT instead of a VARCHAR as that would...

im having a little dificulty understanding your requirements. do you have multiple entries for a location and product id that you need to sum the cases for??

Can you post...

Here is the MSDN article on it...

Evil Kraig F (5/3/2012)

---

Considering the number of views of this and that noone's responded, and that I'm utterly boggled by the occurence as I understand your description, this might be...