SELECT ROW_NUMBER() OVER (ORDER BY CustomerID) AS SerialNo,

CustomerId,

CustomerName

FROM dbo.CustMaster

But,...

Also, there is no need for the highlighted section of the following line of code...

ON id BETWEEN 0 AND [highlight]ISNULL([/highlight]@Counter[highlight],0)[/highlight]

So, how did you manage to prepend the '0x' to the character data to get it to work correctly?

Any chance of listing the code for EXEC usp_Cash_Trans_pct? I wanna see what's in it that requires the RBAR associated with processing just one sales date at a time.

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the...

Michael Valentine Jones (3/20/2009)

---

Not that I would ever recommend using this to get the next ID for anything I was designing, but when someone has already put something like this...

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Derek Dongray (3/20/2009)

---

It looks like The Rant has run its course.

And from his description of his setup (sync software + 3 application tools + 5 databases),...

Robert Cary (3/14/2009)

---

Jeff Moden (3/13/2009)

---

Heh... sure... 7 to 8 seconds compared to just over a second. I'm sure your customers will think the same thing while they're waiting. ...

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

UPDATE...

Must've been named by that guy from MSDN, huh? 😛

arun.sas (3/19/2009)

---

Hi,

No need to put the ROWTERMINATOR, when the records in the line ie it row alignment.

So try to put all row data in one line then second row data...

halifaxdal (3/20/2009)

---

Thank you all for the reply, like I mentioned earlier, the problem has almost been resolved except: how to ignore the last line in the source file, so please...

Derek Dongray (3/20/2009)

---

It looks like The Rant has run its course.

And from his description of his setup (sync software + 3 application tools + 5 databases), I don't think changing...

J (3/20/2009)

---

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...

Select count(*) from table where thedate > 0