I've done work with many of the different databases over the years.  Every time I get back to working with Oracle it always astonishes me that they were still case...

If you're doing it for research and learning, good for you.  The T-SQL Help from query analyzer will give you all you need to know.  Spend some time understanding the...

this doesn't work?

declare @d numeric(19, 0 )

       ,@d2 numeric(19,2)

select @d = 999

select @d2 = @d/100.00

select @d2, @d

Solve a cursor problem with the next most misused feature of SQL Server (triggers)????

If you really, really, absolutely have to do something a row at a time, use a loop...

OK, I'll take up the opposing position and it's really quite simple:

Voting is fundamentally immoral and unethical.  Once you choose to go down that road, what the heck does it...

Ok, but what color?

I'm in agreement, though I'd prefer to be one full bubble off.

There's too many people these days suffering from too much of the entitlement delusion.  And paying...

Maybe.

Provided your data does not have characters that will confuse BCP (extra carriage return/linefeeds:

Bulk copy the entire row into one TEXT datatype column staging table

Then use substring to parse out...

I'm confused after reading the examples.  Is this for purposes of humor?  That is, the stupidest rules you can think of?  Rules for the sake of rules? 

(Why does nobody...

use IS NULL or ISNULL( ) like:

where colname = ISNULL( @var, '' ) OR colname IS NULL

major kluge:

You can always script a series of BCPs (1 for each row/output .jpg), but you'd probably have to script a separate fmt file for each with 0 length prefix...

select *

   from tablea

          cross join ( select max( months ) as max_months from tablea ) w

Nothing has ever yet come close to the speed of development of Powerbuilder.  It's a shame that they were too stupid to price it competitively at a time when it...

I don't know the answer to what you are asking, but in the old days, it all depended on the size of the fields in the index and the page...

Actually, now that I think of it there is one thing missing...

It's what do you do with those questions posted that are so vast and intricate insisting on source code...

You probably do have the best solution as it is now (I think that's what you were trying to say).

Rating is a bad idea.  There are so few contributors to...