Click here to Skip to main content
15,394,786 members
Home / Discussions / Database
   

Database

 
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 
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 
hi,
use this table as example:

SQL
COD    surname   name    CODCAU   from         from_time   to           to_time   period
1      ROSSI     MARCO   301      19/09/2005   0.00        23/09/2005   0.00      p1
1      ROSSI     MARCO   301      09/12/2005   0.00        09/12/2005   0.00      p2
1      BIANCHI   FABIO   301      12/01/2004   0.00        16/01/2004   0.00      p1
1      BIANCHI   FABIO   301      02/04/2004   0.00        02/04/2004   0.00      p2
1      BIANCHI   FABIO   301      02/05/2004   0.00        10/05/2004   0.00      p3


then to pivot:

SQL
select *
FROM
(
   --concatenate to create a period on unique column...
   SELECT surname,name,COD,from+' '+from_time+' '+to+' '+to_time as date,period
   FROM [pivot]
) as s
PIVOT
(
   --pivot aggregate by the columns different by 'date/period' -> (surname,name,COD)
   max(date)
   FOR period IN ([p1],[p2],[p3])
)AS p

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 

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.