mustish1
asked on
SQL Query
HOW WOULD YOU RESTRUCTURE THE DATA IN ACCESS or SQL SERVER IN ORDER TO EXECUTE THIS QUERY
QUERY--> "what is the effect of brain region, target location, and timing on kinematic response?"
ID Parameter UT_50 UT_0 UT_100 UT_250 MT_50 MT_0 MT_100 MT_250 LT_50 LT_0 LT_100 LT_250
20130318ED DLPFC 100ms angle 12.32174145 12.99330841 9.198294504 11.52222631 6.340282729 5.765893345 2.356281523 2.816760675 15.21706611 11.67522974 37.53215703 28.62763514
20130415AV DLPFC 100ms angle 6.643960487 2.681605064 45.47663277 13.03811801 11.46481681 11.70855284 16.70370681 21.46583857 4.024752731 20.52851436 12.07552518 18.812411
20130422PS DLPFC 100ms angle 27.05474266 24.54031814 13.64629434 22.24167306 17.14609102 10.07054778 7.698115749 15.96791456 12.69933214 29.42852496 13.32754867 13.01389084
20130429AB DLPFC 100ms angle 13.31082269 11.91017544 6.457531213 9.531094567 6.056097826 8.80621661 6.886299206 7.711310657 3.729936749 3.01717473 6.905232067 9.607273808
20130506JN DLPFC 100ms angle 5.049545403 5.967528912 3.863780423 15.23849361 12.90741906 11.2606615 6.935865509 8.657818408 4.562420907 24.74435935 14.83554088 18.92366217
20130513WD DLPFC 100ms angle 36.70301022 26.63866007 14.64716985 6.896767072 62.75687098 17.76465364 23.02631308 34.29193975 18.95470209 15.6362619 5.463278143 21.88485651
20130523VL DLPFC 100ms angle 16.56186768 3.067840624 17.52907656 15.09035332 8.630383858 16.48188211 7.649123584 18.03464645 37.87583362 10.83250461 25.90015454 21.33974508
20130530GJ DLPFC 100ms angle 16.45230425 15.48210833 21.21231913 12.21124296 3.698109404 9.09399832 4.991055353 12.9664634 18.82156068 18.03168153 17.41545993 17.99290701
20130318ED DLPFC 100ms magnitude 2.472441425 2.995341949 6.684022 1.634987298 2.032849809 2.91608829 2.959662376 3.268462592 2.302451044 1.205608313 3.991922838 2.587274676
DataFile.xlsx
QUERY--> "what is the effect of brain region, target location, and timing on kinematic response?"
ID Parameter UT_50 UT_0 UT_100 UT_250 MT_50 MT_0 MT_100 MT_250 LT_50 LT_0 LT_100 LT_250
20130318ED DLPFC 100ms angle 12.32174145 12.99330841 9.198294504 11.52222631 6.340282729 5.765893345 2.356281523 2.816760675 15.21706611 11.67522974 37.53215703 28.62763514
20130415AV DLPFC 100ms angle 6.643960487 2.681605064 45.47663277 13.03811801 11.46481681 11.70855284 16.70370681 21.46583857 4.024752731 20.52851436 12.07552518 18.812411
20130422PS DLPFC 100ms angle 27.05474266 24.54031814 13.64629434 22.24167306 17.14609102 10.07054778 7.698115749 15.96791456 12.69933214 29.42852496 13.32754867 13.01389084
20130429AB DLPFC 100ms angle 13.31082269 11.91017544 6.457531213 9.531094567 6.056097826 8.80621661 6.886299206 7.711310657 3.729936749 3.01717473 6.905232067 9.607273808
20130506JN DLPFC 100ms angle 5.049545403 5.967528912 3.863780423 15.23849361 12.90741906 11.2606615 6.935865509 8.657818408 4.562420907 24.74435935 14.83554088 18.92366217
20130513WD DLPFC 100ms angle 36.70301022 26.63866007 14.64716985 6.896767072 62.75687098 17.76465364 23.02631308 34.29193975 18.95470209 15.6362619 5.463278143 21.88485651
20130523VL DLPFC 100ms angle 16.56186768 3.067840624 17.52907656 15.09035332 8.630383858 16.48188211 7.649123584 18.03464645 37.87583362 10.83250461 25.90015454 21.33974508
20130530GJ DLPFC 100ms angle 16.45230425 15.48210833 21.21231913 12.21124296 3.698109404 9.09399832 4.991055353 12.9664634 18.82156068 18.03168153 17.41545993 17.99290701
20130318ED DLPFC 100ms magnitude 2.472441425 2.995341949 6.684022 1.634987298 2.032849809 2.91608829 2.959662376 3.268462592 2.302451044 1.205608313 3.991922838 2.587274676
DataFile.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the data is already in ste5an's [1] example but you need to get it to [2], you can use UNPIVOT in SQL Server.
ASKER
Can you please tell me a simple query as I copied the data into sql server 2012 as well as in access. Thanks.
Maybe I haven't explained my point well:
You're asking for a solution in a very specific field. A field - I guess - not many are fit in. Do you meet many people in the streets knowing a lot about neurophysics?
I'm fit in databases, programming and what some people call software enginieering. I would guess many others here don't have also the necessary background to answer your question.
So, I can help you in my field of expertise, but you need to provide more information to do so.
Sorry, but I don't know how to explain that in a better way.
You're asking for a solution in a very specific field. A field - I guess - not many are fit in. Do you meet many people in the streets knowing a lot about neurophysics?
I'm fit in databases, programming and what some people call software enginieering. I would guess many others here don't have also the necessary background to answer your question.
So, I can help you in my field of expertise, but you need to provide more information to do so.
Sorry, but I don't know how to explain that in a better way.
ASKER
Thanks
QUERY--> "what is the effect of brain region, target location, and timing on kinematic response?"
Encl: Detailed Data File.
DetailedFile.xlsx