Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Forum Fun: Running Calculation SQL

A discussion about a forum post for handling a running subtraction in a SQL query.

For my first forum fun post, I’m going to discuss a running calculation SQL question posted by a user, asyssolvers, on the SQLTeam website here. Here’s the question [slightly shortened]:

I need to get…

Read more

0 comments, 242 reads

Posted in Help With SQL on 21 May 2011

Answering SQL Questions and Forum Fun Overview

Why SQL questions are interesting and how I'm using forums to challenge myself and help others.

I like a good SQL challenge. If I see a problem and it looks complex but do-able, I jump at it. Similar to how some people work through a crossword puzzle or a Sudoku… Read more

0 comments, 313 reads

Posted in Help With SQL on 19 May 2011

Where to put the logic? SQL? Code?

A discussion of where logic should go and why SQL might be the best place.

SQL is a powerful language and is very good at what it was made for – querying sets of data. C#, Java, and other languages are also powerful – more powerful than SQL in many… Read more

0 comments, 322 reads

Posted in Help With SQL on 18 May 2011

Newer posts