SQL Clone
SQLServerCentral is supported by Redgate
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, 611 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, 605 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, 773 reads

Posted in Help With SQL on 18 May 2011

Newer posts