Archive for July 6th, 2009
SQL For Programmers – New Question
July 6th, 2009 | 
Author: 
I got this question last week that I thought would be worth discussing on the blog.
I would like to create a table that lists contributions by date, amount, and designation. In some cases one gift was split two (or more) ways. For example, a contribution of $1000 was given, and $500 went to the scholarship fund and $500 to athletics. The gift date would be the same for both gifts, but they must be recorded separately in order to split the gift. In my new table, I want to list them in rows like this:
date| amount| designation1, designation2, designation3, etc.Would it be best to use a cursor or a stored procedure. I’ve never done anything like this before, so I’m not sure where to begin.
Other Related Items:
Beginner's SQL Server 2000 T-SQL Programming on DVDLearn SQL Server 2000/TSQL Programming as you watch DVDs on your TV or laptop DVD player. This 2-disc set contains 7 lessons that provide you a revi... Read More >
Posted in 
Tags: 
