Jeff Moden (3/19/2009)

---

J (3/19/2009)

---

And as was mentioned before, a LineNo is the normal way of forcing a specific order. Using the script already posted to increment the LineNo to be...

Foxjazz:

If you have millions of records, I think it would well be worth it. To allow testing without risking compromising the production database, you could make a copy of the...

Foxjazz,

If you need to use "bands"of IDENITY, you can around it by adding a Band column in your table and let SQL Server deal with IDENTITY key. And as was...

Bob Hovious (3/18/2009)

---

Hey Fox. Don't be overwhelmed by the rush of answers and questions after each post. There are a lot of people watching...

The user defines the sequence, it isn't alphabetical. So when inserting a record the user would give 2 as the sequence, and the rest of the records have to be...

Well, I have seen a case where...

Hmmm. In the LISP example I posted (((((((((()].

Note the last squared bracket in the end....

foxjazz (3/18/2009)

---

J, my dba wife pointed it out to me last night that set based solutions are not always superior to cursors. It depends on the database, however for batch...

Wut ? After all the effort...

Now, back to business. Foxjazz is on the edge of enlightenment. I think we should cut the man some slack, because he has dropped the insults and started trying to...

I agree that the first thing I would have done to correct the query would be to make it work by adding the obviously missing GROUP BY clause. AFTER that,...

A good reminder to look at the overall picture.

I have had to write a stored procedure to prepare invoices. There are several sub-tables such as general_ledger_distribution, invoice_discount, sales_invoice_product etc. If...

foxjazz (3/17/2009)

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

I agree. If I can do more stuff without the use of cursors, I am happier.

Some things just have to be looped. Like for instance, sequence numbers.

but we will...

foxjazz (3/17/2009)

---

Ok, I messed up.. The table I sent has and identity spec, I thought it didn't.

Some of the tables I have don't use ident.

So take out the identity spec...

Woops! with my limited command of the Englsih language (not my mother tonge) I assumed Lynn was a female...