Click here to Skip to main content
15,868,051 members
Home / Discussions / Database
   

Database

 
AnswerRe: combine multiple rows in single row Pin
Mycroft Holmes17-Oct-10 20:43
professionalMycroft Holmes17-Oct-10 20:43 
Questionchange master collation Pin
jojoba201117-Oct-10 8:13
jojoba201117-Oct-10 8:13 
AnswerRe: change master collation Pin
Karthik. A17-Oct-10 16:59
Karthik. A17-Oct-10 16:59 
Questiondate manipulation Pin
scottichrosaviakosmos16-Oct-10 21:37
scottichrosaviakosmos16-Oct-10 21:37 
AnswerRe: date manipulation Pin
Mycroft Holmes16-Oct-10 22:19
professionalMycroft Holmes16-Oct-10 22:19 
GeneralRe: date manipulation Pin
scottichrosaviakosmos16-Oct-10 22:40
scottichrosaviakosmos16-Oct-10 22:40 
GeneralRe: date manipulation Pin
Mycroft Holmes17-Oct-10 2:02
professionalMycroft Holmes17-Oct-10 2:02 
AnswerRe: date manipulation Pin
Alegria_Lee17-Oct-10 19:01
Alegria_Lee17-Oct-10 19:01 
How about "case when" ?
case when 
     cast(right(@dates,2) as int) > 1
then 
     convert(char(8),dateadd(month,1,cast(left(@dates,6) + '01' as datetime(8))),112) 
else 
     @dates 
end

QuestionInsert Excel OR CSV File into MySQL OR MSSQL Database Pin
jasonmp16-Oct-10 12:17
jasonmp16-Oct-10 12:17 
AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
Mycroft Holmes16-Oct-10 12:37
professionalMycroft Holmes16-Oct-10 12:37 
AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
SimulationofSai16-Oct-10 14:31
SimulationofSai16-Oct-10 14:31 
AnswerRe: Insert Excel OR CSV File into MySQL OR MSSQL Database Pin
SQLMechanic29-Oct-10 5:47
SQLMechanic29-Oct-10 5:47 
QuestionMultiple Rows to Single Rows Pin
Chris Meech15-Oct-10 8:32
Chris Meech15-Oct-10 8:32 
AnswerPivot Pin
David Mujica15-Oct-10 9:06
David Mujica15-Oct-10 9:06 
AnswerRe: Multiple Rows to Single Rows Pin
PIEBALDconsult15-Oct-10 12:44
mvePIEBALDconsult15-Oct-10 12:44 
AnswerRe: Multiple Rows to Single Rows Pin
Alegria_Lee15-Oct-10 17:01
Alegria_Lee15-Oct-10 17:01 
GeneralRe: Multiple Rows to Single Rows Pin
Blue_Boy16-Oct-10 5:51
Blue_Boy16-Oct-10 5:51 
GeneralRe: Multiple Rows to Single Rows Pin
Chris Meech18-Oct-10 4:17
Chris Meech18-Oct-10 4:17 
GeneralRe: Multiple Rows to Single Rows Pin
Alegria_Lee18-Oct-10 4:48
Alegria_Lee18-Oct-10 4:48 
Questionsplitting one column into many Pin
rakeshs31215-Oct-10 0:42
rakeshs31215-Oct-10 0:42 
AnswerRe: splitting one column into many Pin
J4amieC15-Oct-10 1:17
J4amieC15-Oct-10 1:17 
GeneralRe: splitting one column into many Pin
rakeshs31215-Oct-10 2:23
rakeshs31215-Oct-10 2:23 
GeneralRe: splitting one column into many Pin
J4amieC15-Oct-10 2:53
J4amieC15-Oct-10 2:53 
AnswerRe: splitting one column into many Pin
PIEBALDconsult15-Oct-10 3:07
mvePIEBALDconsult15-Oct-10 3:07 
AnswerRe: splitting one column into many Pin
Rajesh Anuhya19-Oct-10 23:57
professionalRajesh Anuhya19-Oct-10 23:57 

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.