Something else is going on, would need to see a more complete original statement and the table definition(s).

Many companies have clients that have a credit limit: they can't order over a certain amount without prior approval. [I've worked in 2 such companies at least already.]  That "remaining...

You seem fixated on tying the physical format of data to its use/display.  A value can be stored physically as an int without the value ever being directly used in...

I've had the same bank account for more than 20 years.  I'd hate to have to wait for them to compute a balance every time.

A balance is one of those...

UPDATE dbo.table_name

SET balance = balance - @amount

WHERE balance - @amount >= 0.0

a negative dollar amount followed by a non-negative dollar amount

Do you have something that can be sorted on to give the proper order of transactions?  If so, it's easy to...

You could consider using SQL's Change Tracking to keep track of the changes for you; you could then translate the tracking version into an actual datetime of change.  And it's...

• This reply was modified 6 years, 4 months ago by ScottPletcher.

Could you post the query plan, estimated is good enough for now, for this SQL:

delete lad from PA_LDG_HOLD_JRNAL_LINES_LAD lad inner join PA_LDG_JRNAL jrl on (lad.JRNAL_ID = jrl.HOLD_JRNAL_ID and lad.LINE_ID =...

SELECT DateCol1, Col2,
    STUFF(CASE WHEN [1] = 0 THEN ',1' ELSE '' END +
        CASE WHEN [2]...

NULL and 0.0 are not the same thing.

If you need the values to be 0.0, you should make sure they are INSERTed as 0.  Use a default value and a...

It's best to stop using INFORMATION_SCHEMA views.  They can contain inaccuracies (on ownership) and are incomplete now.

Stick to sys.columns and the other MS standard views.

I guessed you would want to sort/order by Item first; if not, you might want to reverse the GROUP BY to Name, Item.

SELECT Item, Name, 
 ...

Heh... while the world insists that...

A bit tricky really, unless you want to take the 90 separate log files approach.

For example, if you set a job to cycle the log every 15 days, then the...

I recommend one simplification to make your SQL coding and maintenance easier: use "*" in the inner query using ROW_NUMBER().  SQL will still only actually retrieve the data that is...