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 |
Franck
Starting Member
1 Post |
Posted - 2014-07-29 : 17:49:42
|
Hello,I really have a basic knowledge of the SQL and I'm stuck with a SQL request. I have a table which summarize datas collected from a form.On each ID of the table I collected several "authors" for each document submitted.Some of them (I have 16 colums of authors) are considered as "leaders". Then, after each authors I have a column with TRUE or FALSE depending on the status of the authors (leader or not)I would like to write an SQL query which will give me the full list of "leaders" only.I guess I need to play with the IF but I didn't figure out yet. Is someone could help me?Kind regards,Franck |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-29 : 17:51:37
|
http://www.sqlservercentral.com/articles/Best+Practices/61537/Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|