Click here to Skip to main content
15,116,654 members
Home / Discussions / Database
   

Database

 
GeneralRe: CHECKING NULL VALUES Pin
Ashfield26-Aug-09 2:43
MemberAshfield26-Aug-09 2:43 
Questionregarding foreignkey data Pin
kheer25-Aug-09 0:12
Memberkheer25-Aug-09 0:12 
AnswerRe: regarding foreignkey data Pin
dotnetcsharpdev25-Aug-09 0:33
Memberdotnetcsharpdev25-Aug-09 0:33 
GeneralRe: regarding foreignkey data Pin
kheer25-Aug-09 0:58
Memberkheer25-Aug-09 0:58 
GeneralRe: regarding foreignkey data Pin
dotnetcsharpdev25-Aug-09 1:16
Memberdotnetcsharpdev25-Aug-09 1:16 
GeneralRe: regarding foreignkey data Pin
Ashfield26-Aug-09 2:44
MemberAshfield26-Aug-09 2:44 
GeneralRe: regarding foreignkey data Pin
kheer26-Aug-09 23:01
Memberkheer26-Aug-09 23:01 
QuestionMerging multi results into one row Pin
Wouter Coinless24-Aug-09 10:12
MemberWouter Coinless24-Aug-09 10:12 
ID					Name			Access1	Access2	Access3	Access4	Access5 	
918a6fb8-573f-4744-b4de-019bc8322ce4	Gast			False	False	False	False	True
013b4a2b-3027-41b6-a7e1-e0e536dd0bbc	Administrator		True	True	True	True	False


I have multiple results for 1 user. In the example I want the results to get to one row, with the final result (True, True, True, True, True).
So the query has to go through all the results and check if the Access Right is True or False. Is one of them is True the result of the column is true.

I tried to use Temp Tables but im stuck Frown | :( Anyone has an idea?

I use MSSQL
AnswerRe: Merging multi results into one row Pin
Luc Pattyn24-Aug-09 10:39
sitebuilderLuc Pattyn24-Aug-09 10:39 
AnswerRe: Merging multi results into one row Pin
Eddy Vluggen24-Aug-09 10:51
professionalEddy Vluggen24-Aug-09 10:51 
AnswerRe: Merging multi results into one row Pin
Wouter Coinless24-Aug-09 10:54
MemberWouter Coinless24-Aug-09 10:54 
QuestionXML Save and Load to SQL Server 2005 database. Pin
ashwath197924-Aug-09 2:55
Memberashwath197924-Aug-09 2:55 
AnswerRe: XML Save and Load to SQL Server 2005 database. Pin
Henry Minute24-Aug-09 3:18
MemberHenry Minute24-Aug-09 3:18 
AnswerRe: XML Save and Load to SQL Server 2005 database. Pin
N a v a n e e t h24-Aug-09 7:19
MemberN a v a n e e t h24-Aug-09 7:19 
GeneralRe: XML Save and Load to SQL Server 2005 database. Pin
ashwath197925-Aug-09 2:40
Memberashwath197925-Aug-09 2:40 
GeneralRe: XML Save and Load to SQL Server 2005 database. Pin
N a v a n e e t h25-Aug-09 3:06
MemberN a v a n e e t h25-Aug-09 3:06 
RantFound some strange code. [moved] Pin
Gandalf_TheWhite24-Aug-09 2:23
professionalGandalf_TheWhite24-Aug-09 2:23 
GeneralRe: Found some strange code. Pin
PIEBALDconsult24-Aug-09 5:08
professionalPIEBALDconsult24-Aug-09 5:08 
QuestionTransferring SQL Express data Pin
hairy_hats24-Aug-09 1:07
Memberhairy_hats24-Aug-09 1:07 
AnswerRe: Transferring SQL Express data Pin
Henry Minute24-Aug-09 1:29
MemberHenry Minute24-Aug-09 1:29 
GeneralRe: Transferring SQL Express data Pin
hairy_hats24-Aug-09 1:36
Memberhairy_hats24-Aug-09 1:36 
GeneralRe: Transferring SQL Express data Pin
Henry Minute24-Aug-09 6:51
MemberHenry Minute24-Aug-09 6:51 
QuestionDatabase design questions Pin
Saksida Bojan23-Aug-09 23:51
MemberSaksida Bojan23-Aug-09 23:51 
AnswerRe: Database design questions Pin
Mycroft Holmes24-Aug-09 0:34
professionalMycroft Holmes24-Aug-09 0:34 
GeneralRe: Database design questions Pin
Saksida Bojan24-Aug-09 0:51
MemberSaksida Bojan24-Aug-09 0:51 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.