Click here to Skip to main content
14,267,388 members
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
adminChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
adminChris Maunder10-Nov-05 16:30 
QuestionSQL Remote Connection Problem Pin
Kevin Marois11hrs 37mins ago
professionalKevin Marois11hrs 37mins ago 
AnswerRe: SQL Remote Connection Problem Pin
Richard Deeming10hrs 44mins ago
mveRichard Deeming10hrs 44mins ago 
GeneralRe: SQL Remote Connection Problem Pin
Kevin Marois10hrs 8mins ago
professionalKevin Marois10hrs 8mins ago 
GeneralRe: SQL Remote Connection Problem Pin
Richard Deeming10hrs 1 min ago
mveRichard Deeming10hrs 1 min ago 
GeneralRe: SQL Remote Connection Problem Pin
Kevin Marois9hrs 47mins ago
professionalKevin Marois9hrs 47mins ago 
QuestionDate format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling21hrs 14mins ago
memberjan Meeling21hrs 14mins ago 
QuestionRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan20hrs 35mins ago
protectorRichard MacCutchan20hrs 35mins ago 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling17hrs 50mins ago
memberjan Meeling17hrs 50mins ago 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Victor Nijegorodov16hrs 9mins ago
memberVictor Nijegorodov16hrs 9mins ago 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Richard MacCutchan15hrs 6mins ago
protectorRichard MacCutchan15hrs 6mins ago 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Victor Nijegorodov19hrs 10mins ago
memberVictor Nijegorodov19hrs 10mins ago 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling17hrs 46mins ago
memberjan Meeling17hrs 46mins ago 
AnswerRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Eddy Vluggen18hrs 17mins ago
mveEddy Vluggen18hrs 17mins ago 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
jan Meeling17hrs 34mins ago
memberjan Meeling17hrs 34mins ago 
GeneralRe: Date format in SQL Database export to Excel 23/01/1990 00:00:00 instat of 23/01/1990 Pin
Eddy Vluggen17hrs 26mins ago
mveEddy Vluggen17hrs 26mins ago 
QuestionProduct Architecture Pin
Chiranjana13-Aug-19 0:50
memberChiranjana13-Aug-19 0:50 
AnswerRe: Product Architecture Pin
David Mujica13-Aug-19 3:50
memberDavid Mujica13-Aug-19 3:50 
GeneralRe: Product Architecture Pin
Chiranjana13-Aug-19 5:05
memberChiranjana13-Aug-19 5:05 
AnswerRe: Product Architecture Pin
Mycroft Holmes13-Aug-19 12:50
memberMycroft Holmes13-Aug-19 12:50 
Questioncookies vs sessions for storing users id for ecommerce site Pin
djtrixy2-Aug-19 21:48
memberdjtrixy2-Aug-19 21:48 
AnswerRe: cookies vs sessions for storing users id for ecommerce site Pin
Afzaal Ahmad Zeeshan3-Aug-19 4:02
mveAfzaal Ahmad Zeeshan3-Aug-19 4:02 
QuestionI didn't design it but I need to get data out of it. Pin
rnbergren2-Aug-19 4:23
memberrnbergren2-Aug-19 4:23 
So lets say I have a table (Ports) with an Identifier and then a compacted not XML field that is semi structured.

select * from Ports --Yields this.
ID Categories
1 Town:York, Street:Main, Phone:712-542-3423

The Categories field might have two fields in it. Town and Street or it might have 15.

I need to get these out into separate fields as soo
ID Town Street Phone
1 York Main 712......

ideas on SQL SQL server 2016 is what we are running.

Ideas?
To err is human to really mess up you need a computer

AnswerRe: I didn't design it but I need to get data out of it. Pin
Richard Deeming2-Aug-19 4:51
mveRichard Deeming2-Aug-19 4:51 

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.