Post the cursor and some info about what it's supposed to be doing.  A little table info would help, too.  You'd be amazed at what folks can do about getting...

I gotta look that one up, Steve...  I very well could be having a problem with convincing the DBA if my definition of what a heap is is incorrect.   My...

Thanks... that's gotta be a 2005 thing, huh?  Wondered when they would get around to forcing that issue...

I'm not at work right now... I'll dig it up when I get there.  I normally have access from home but not on this particular DB...

Not sure what you mean, Ronda.  What kind of a sort are you talking about?

My real concern is over "entity integrity".... or, if you will, a table without a Primary...

http://www.sqlservercentral.com/columnists/jmoden/calculatingworkdays.asp

Heh... maybe that's it!  I should thank him, huh?

Yep... that's the position I was taking... just wanted to make sure there wasn't some exotic reason I was missing.  Thanks for the feedback, folks.

Yep... check Books Online... SQL Server has had it for a while now.  It also has ROLLUP which is like CUBE but without all the extra subtotals.

It would be done pretty much the same way in MS-SQL Server as you did in Oracle... unless you used a cursor which is not the most effective way to...

No, Sir, David... you're not wrong... but not for the reasons you state...

First, let's build a small table of only 10,000 rows with only the data with which we are...

Yeah... that's what I mean Stuff like that...

Heh... my boss' boss says that all the time... it's why our projects seem to go in so fast... who cares if it takes six months extra to fix what we...

Thanks, guys.  Yeah, the only thing I could think of was a minimal logging bulk insert staging table but he's not using it for that...  it's a permanent cross-reference table...

Who are you and what have you done with the real Serqiy?  The real Serqiy I know would have said something about going back and fixing the database so there...