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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Help for SQL request in a table

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -