Click here to Skip to main content
15,501,968 members
Home / Discussions / Database
   

Database

 
AnswerRe: Handle to chat room with mysql database Pin
data modeling guy16-Jul-14 18:42
Memberdata modeling guy16-Jul-14 18:42 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 22:28
MemberMember 1094998616-Jul-14 22:28 
GeneralRe: Handle to chat room with mysql database Pin
data modeling guy17-Jul-14 0:52
Memberdata modeling guy17-Jul-14 0:52 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998617-Jul-14 2:45
MemberMember 1094998617-Jul-14 2:45 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Mangesh678616-Jul-14 3:04
MemberMangesh678616-Jul-14 3:04 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Eddy Vluggen16-Jul-14 6:03
professionalEddy Vluggen16-Jul-14 6:03 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 14:39
professionalPIEBALDconsult17-Jul-14 14:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 14:05
Membermrfalk15-Jul-14 14:05 
Need to write extract file providing 2 employee emergency contacts with one phone number each in one record. Going to order by emergency contact name when selecting which contact and sort by phone type when selecting phone. I'm at a loss at how to do this and would appreciate any help


Fields in Row:
EmpNum EmergencyContact1 Relation1 PhType1 Phone1 EmergencyContact2 Relation2 PhType2 Phone2


EmpNum	EmpEmergencyContact	Relation	PhType	Phone			
123456	Rick Grimes		SP		Cell	9999999999
123456	Rick Grimes		SP		Work	8888888888
123456	Daryl Dixon		FR		Cell	7777777777
123456	Daryl Dixon		FR		Home	3333333333
123456	Maggie Greene		CH		Cell	5555555555
123456	Maggie Greene		CH		Home	6666666666

AnswerRe: Extract Data in Single Record Pin
data modeling guy15-Jul-14 20:32
Memberdata modeling guy15-Jul-14 20:32 
AnswerRe: Extract Data in Single Record Pin
Richard Deeming16-Jul-14 3:42
mveRichard Deeming16-Jul-14 3:42 
AnswerRe: Extract Data in Single Record Pin
PIEBALDconsult17-Jul-14 14:54
professionalPIEBALDconsult17-Jul-14 14:54 
Questionlinked list using CTE Pin
Ali Al Omairi(Abu AlHassan)14-Jul-14 23:29
professionalAli Al Omairi(Abu AlHassan)14-Jul-14 23:29 
AnswerRe: linked list using CTE Pin
Ali Al Omairi(Abu AlHassan)15-Jul-14 0:14
professionalAli Al Omairi(Abu AlHassan)15-Jul-14 0:14 
QuestionOVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 5:44
MemberAmbertje14-Jul-14 5:44 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:13
professionalPIEBALDconsult14-Jul-14 6:13 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 6:15
MemberAmbertje14-Jul-14 6:15 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 6:27
professionalEddy Vluggen14-Jul-14 6:27 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 6:29
professionalPIEBALDconsult14-Jul-14 6:29 
QuestionRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 8:47
professionalEddy Vluggen14-Jul-14 8:47 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 9:33
professionalJörgen Andersson14-Jul-14 9:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Mycroft Holmes14-Jul-14 13:54
professionalMycroft Holmes14-Jul-14 13:54 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 23:20
professionalJörgen Andersson14-Jul-14 23:20 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 23:12
MemberAmbertje14-Jul-14 23:12 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
jschell14-Jul-14 11:07
Memberjschell14-Jul-14 11:07 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
GuyThiebaut14-Jul-14 22:33
professionalGuyThiebaut14-Jul-14 22:33 

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.