Click here to Skip to main content
15,390,952 members
Home / Discussions / Database
   

Database

 
QuestionJoin Query returning duplicated rows Pin
devenv.exe15-May-14 23:13
professionaldevenv.exe15-May-14 23:13 
AnswerRe: Join Query returning duplicated rows Pin
Mycroft Holmes16-May-14 13:20
professionalMycroft Holmes16-May-14 13:20 
AnswerRe: Join Query returning duplicated rows Pin
NitinDhapte6-Jun-14 23:07
MemberNitinDhapte6-Jun-14 23:07 
QuestionTranspose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 4:52
MemberDavidemazzuuu13-May-14 4:52 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Corporal Agarn13-May-14 5:46
professionalCorporal Agarn13-May-14 5:46 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:11
MemberDavidemazzuuu13-May-14 21:11 
AnswerRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 12:53
professionalMycroft Holmes13-May-14 12:53 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 21:04
MemberDavidemazzuuu13-May-14 21:04 
With PIVOT i get:

ObjectID - 41 - 46 - 47
--------------------------------------
1828 - 171 - 184 - 189

or

ObjectID - 41 - 46 - 47
--------------------------------------
1828 - 171 - 184 - 189
1828 - 170 - NULL - NULL

I must do:
select ObjectID from table where [41]=171 and [46]=184
select ObjectID from table where [41]=170 and [46]=184
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Mycroft Holmes13-May-14 21:30
professionalMycroft Holmes13-May-14 21:30 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Davidemazzuuu13-May-14 22:27
MemberDavidemazzuuu13-May-14 22:27 
GeneralRe: Transpose multiple rows into multiple columns in SQL Server Pin
Member 1026233013-May-14 21:34
MemberMember 1026233013-May-14 21:34 
QuestionSQL Server 2012 Cube Build failing. Pin
rnbergren12-May-14 9:52
Memberrnbergren12-May-14 9:52 
QuestionAccess DB Pin
Zeyad Jalil11-May-14 19:45
professionalZeyad Jalil11-May-14 19:45 
AnswerRe: Access DB Pin
Bernhard Hiller11-May-14 22:30
MemberBernhard Hiller11-May-14 22:30 
AnswerRe: Access DB Pin
sankarsan parida12-May-14 19:33
professionalsankarsan parida12-May-14 19:33 
Questionhow to return primary key when insert statement violates unique constraint Pin
Nico Haegens10-May-14 7:21
professionalNico Haegens10-May-14 7:21 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
PIEBALDconsult10-May-14 7:44
professionalPIEBALDconsult10-May-14 7:44 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens10-May-14 8:05
professionalNico Haegens10-May-14 8:05 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
PIEBALDconsult10-May-14 10:22
professionalPIEBALDconsult10-May-14 10:22 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens10-May-14 23:07
professionalNico Haegens10-May-14 23:07 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
PIEBALDconsult11-May-14 5:56
professionalPIEBALDconsult11-May-14 5:56 
AnswerRe: how to return primary key when insert statement violates unique constraint Pin
jschell11-May-14 8:17
Memberjschell11-May-14 8:17 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Nico Haegens12-May-14 3:20
professionalNico Haegens12-May-14 3:20 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Richard.Berry10012-May-14 7:55
MemberRichard.Berry10012-May-14 7:55 
GeneralRe: how to return primary key when insert statement violates unique constraint Pin
Eddy Vluggen12-May-14 8:49
professionalEddy Vluggen12-May-14 8:49 

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.