Click here to Skip to main content
15,307,172 members
Home / Discussions / Database
   

Database

 
QuestionUpdate DB Table based on another temp Table data Pin
Sachin k Rajput 19-May-14 4:11
MemberSachin k Rajput 19-May-14 4:11 
AnswerRe: Update DB Table based on another temp Table data Pin
PIEBALDconsult19-May-14 12:22
professionalPIEBALDconsult19-May-14 12:22 
Questionweird scenario after executing prepared statement mysql Pin
Gilbert Consellado15-May-14 23:15
professionalGilbert Consellado15-May-14 23:15 
AnswerRe: weird scenario after executing prepared statement mysql Pin
Kornfeld Eliyahu Peter17-May-14 8:21
professionalKornfeld Eliyahu Peter17-May-14 8:21 
GeneralRe: weird scenario after executing prepared statement mysql Pin
Gilbert Consellado21-May-14 23:53
professionalGilbert Consellado21-May-14 23:53 
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 
Dear,

It happens only when the multiple records are available with the correspondence of [Sheet1$].Id into the [Sheet2$] ([Sheet2$].Sheet2Id) Or [Sheet3$] ([Sheet3$].Sheet3Id).

Please check with the multiple records into the Both the Sheet 2 & 3.

If you dont want to remove the multiple records from those sheets then

Add distinct clause into the SELECT Query.

SQL
SELECT DISTINCT 
[Sheet1$].Sheet1DetailId,
[Sheet1$].Sheet1Id,
[Sheet2$].Sheet2Id,
LTrim(RTrim([Sheet3$].Mission)) + '-' + CStr(Format('01-' + [Sheet3$].Sheet3Date,"mm/dd/yyyy")) AS Sheet3DateColumn,
[Sheet1$].one,
[Sheet1$].two,
[Sheet1$].three,
[Sheet1$].four,
[Sheet1$].five,
[Sheet1$].six,
[Sheet1$].seven,
[Sheet1$].eight,
[Sheet1$].nine,
[Sheet1$].ten,
LTRIM(RTRIM([Sheet2$].Name)) AS Sheet2Name
FROM      (([Sheet1$])
INNER JOIN [Sheet2$] ON [Sheet1$].Id = [Sheet2$].Sheet2Id)
INNER JOIN [Sheet3$] ON [Sheet1$].Id = [Sheet3$].Sheet3Id

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 
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 

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.