GilaMonster (1/26/2009)

---

Jeff Moden (1/26/2009)

---

The backup to such a "break" for the quirky update method is that the ORDER BY method also works although it works at about half the speed....

Wow... they don't write 'em like that anymore.

Heh... WOW! C-O-F-F-E-E N-E-E-D-E-D H-E-R-E! 😛

You still haven't answered my question... what does the VB Script do? Also, which direction is the BCP in?

Go back and look at my previous post... problem is NOT in the rowcount... it's how you're doing the math. Integer math will only yield integers and you need...

Heh... there are some places in Oracle that require RBAR... try writing a set based trigger in Oracle sometime... 😛

GilaMonster (1/27/2009)

---

The query, as written won't. The DMV includes that info...

I actually believe it was just the opposite... I think it was severe over confidence... why else would the prices on houses have gone so high? Gas prices more...

I don't know which would be preferred, which is why I didn't dupe check them into oblivion.

Steve Berry (1/27/2009)

---

The output is created by a series of select statements, as sample is shown bellow:

--Output Report Master Header

set @output = 'Weekly Stock Report - Year '+ @yearcode +...

Thanks for the info... just trying to understand so we can do this in as high a performance method as possible...

In your original post on this thread, you have (obviously)...

Thanks David... the article was first published over a year ago. Seems like some different folks jumped in this time and dang near doubled the length of the comments....

Can't tell... not enough information. You need to prove to yourself that you're passing something besides a null or a negative number for pages, pages, and rows per page....

Steve Berry (1/27/2009)

---

Its part of a scheduled job, that runs overnight and outputs to a text file...which then gets picked up by another package and sent out to remote locations...

The other thing is that SQL is not SQL between vendors... you're looking for a DB2 solution which could be quite different than the SQL Server solutions you'll get. ...