here's what i'm trying to do. i have a table that keeps track of dates for tasks on a object (a lot in this case) in the following way:
id projectid lotid taskid date
1 1 1 1 1/1/2006
what i need to do is create a stored procedure with only 4 columns where 2 of the columns come from criteria on the taskid. so say for instance i wanted to know all the dates entered on all lots for tasks 1 and 2 where those tasks are 2 of the columns
projectid lotid task1 task2
1 1 1/1/2006 1/1/2007
how would i go about doing this? i actually need to do this for only those lots where task1 and task2 both have dates (neither can be null), so if that makes it easier (not having to catch records that don't exist), all the better.