Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinodparvathareddy
Starting Member
1 Post |
 Posted - 2012-01-24 : 07:32:18
|
| I Have SOURCE like below and I am expecting rows EXP:Source: Number Name from date end date 100 abc 1/1/2001 31/12/2001 100 abc 1/1/2002 31/12/2005 100 def 1/1/2006 31/12/2006 100 abc 1/1/2007 31/12/9999 exp: Number Name from date end date 100 abc 1/1/2001 31/12/2005 100 def 1/1/2006 31/12/2006 100 abc 1/1/2007 31/12/9999 Vinod Reddy |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2012-01-24 : 08:31:26
|
| try this thread. Looks like what you want:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=165984http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
 |
|
|
|
|
|
SQL QUERY