1 Replies - 3285 Views - Last Post: 10 November 2012 - 06:15 AM

#1 seijurojushi  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 35
  • Joined: 24-July 12

How to query based on a span defined by two fields

Posted 10 November 2012 - 05:54 AM

Hello fellow DIC members!
My head is cracking trying to figure out how to query this.
I have a table containing information relating to the Star Wars movies.
The table has character names, planet names, movie numbers and arrival and departure times showing when the specified character visited a planet.

What I need to get is the characters that have been on the same planet at the same time during the same movie based on the arrival and departure time.

First of all it's difficult enough for me to imagine how to find the characters that have been on the same planet at the same time, but when I think about displaying an arbitrary number of names my brain crashes...

If someone could point me in the right direction logic wise, would be great, I just don't know how to go about it.

Is This A Good Question/Topic? 0
  • +

Replies To: How to query based on a span defined by two fields

#2 coder3788  Icon User is offline

  • D.I.C Head

Reputation: 38
  • View blog
  • Posts: 62
  • Joined: 06-November 12

Re: How to query based on a span defined by two fields

Posted 10 November 2012 - 06:15 AM

LINQ query samples :
http://code.msdn.mic...amples-3fb9811b

edit : sorry wrong link the first time

This post has been edited by coder3788: 10 November 2012 - 06:17 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1