You need to look at changing how you make your call to the stored procedure. What you're describing sounds like something akin to messaging: you just request that the...

Steve Jones - Editor (12/7/2009)

---

Is a hot dog cooker inefficient? Having one means that my kid might be able to cook something without help. It might seem like a waste...

This could also be the slammer worm as well. Onnce compromised, the server would "generate a random IP" and start trying to connect to it.

Jeff Moden (12/5/2009)

---

The JPG's won't help me or you. I suspect the devil is in the data. My recommendation is that you need to start with a row...

Bru Medishetty (12/4/2009)

---

igngua (12/4/2009)

---

I didn´t get how tu use trim function.

I have a col with data and i need to erase all blank spaces to the right of the string....

Brandie Tarvin (12/3/2009)

---

In my experience, the Compliance team (or whatever name the watchdogs have) are not tech people. If a DBA wanted to get away with something, it would be...

GilaMonster (12/1/2009)

---

If...

Considering we're looking at a dev edition error log, this is possibly someone shutting the machine down (which could...

TheSQLGuru (12/1/2009)

---

I didn't use the NTILE function because it seemed the OP wanted the 'buckets' of leads per salesperson to be evenly distributed in desc order. Something semi-random such...

TheSQLGuru (12/1/2009)

---

Peter Schott (12/1/2009)

---

Keep forgetting about the Row_Number function, even though I've used it. SQL 2000 and lower habits are pretty deeply entrenched. 😛

Thanks for the reminder about that...

As long as it's only for Y/N, then Char(1) or NCHAR(1) is fine I suppose. That said - if it's also nullable, you can call it whatever you like...

Is there any case where items don't have descriptions? If that is NOT the case - you can do this in one pass and get rid of the cross...

bitbucket-25253 (11/23/2009)

---

String len 4 characters

Rows written to the table 68,600

Errors begin after 18,717 rows written

String Len 5 characters

Rows written to the table 591,200

Errors begin after rows written...

If you want to make sure the data isn't there - then why check at all? Just issue the delete statement, followed by an insert statement.

If no data matches,...

Some classes of errors pop the error outside of the current context and end up creating the error in the outer context .

Just for testing purposes - try setting up...