Oh... almost forgot... the code I posted allows you to reserve more than one ID using an "increment". If you can't figure out how to use that for more...

mweber26 (1/2/2009)

---

I need some help with an identity-type column in a table. I have a order table that has an order number field, the order number is a incrementing...

Grant Fritchey (1/2/2009)

---

Absolutely. One of the biggest problems we have where I work, an ANCIENT insurance company, is the entrenched knowledge, "We've always done it this way," even though what...

Steve Jones - Editor (1/2/2009)

---

As with everything, it depends.

I think it's as likely that it's thrown in there to limit the candidates as it is just an addition by HR...

bnordberg (1/1/2009)

---

I agree it is a nice to have industry experience, but absolutly not necessary.

Further I think single industry experience is a detrement. For example in healthcare (At least...

RBarryYoung (1/2/2009)

---

Assuming that we are talking about SQL Server 2005/2008, I know...

If that's not a fair "Pork Chops are immenent" warning, then there's no such thing. 😛

TheSQLGuru (1/1/2009)

---

I wonder if poor Mr. Wagner Crivelini is aware of the recent firestorm of posts engendered by an article writer who had the audacity to take on cursors on...

Thanks, Barry.... it...

SQLBOT (1/2/2009)

---

RBarryYoung (1/2/2009)

---

SQLBOT (1/2/2009)

---

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

It...

LSAdvantage (1/2/2009)

---

In response to sudhanvag, who stated:

But i want a result like this

---------------------------------

codName (no column name)

abc 1 281 444 5555 , 55...

wagner crivelini (1/2/2009)

---

My point in this article is "Whenever you suspect your code is not running as expected, no matter it uses cursors or not, you should check your code's...

robert.letts (1/2/2009)

---

Excellent article on cursors, Wagner.

Here is a weird problem that made me choose a cursor. The incoming data was in a header / detail format. The header had 5...

No! It's NOT! It still uses a declared loop and it's still just as bad as...

wagner crivelini (1/2/2009)

---

In fact, concatenating strings will not do on this example.

This works when you have one scalar value to return, instead of a whole table.

But there are workarounds, of...