Click here to Skip to main content
14,358,698 members
   

Database

 
GeneralRe: MS Sql normalization Pin
Jörgen Andersson20-Mar-13 22:33
protectorJörgen Andersson20-Mar-13 22:33 
GeneralRe: MS Sql normalization Pin
Per Söderlund22-Mar-13 11:59
memberPer Söderlund22-Mar-13 11:59 
Questionlinked server Pin
rocksonedmond19-Mar-13 6:45
memberrocksonedmond19-Mar-13 6:45 
SuggestionRe: linked server Pin
Maciej Los19-Mar-13 8:39
protectorMaciej Los19-Mar-13 8:39 
AnswerRe: linked server Pin
RedDk22-Mar-13 9:23
memberRedDk22-Mar-13 9:23 
QuestionThreading and insert/update issues. Pin
mjackson1118-Mar-13 19:06
membermjackson1118-Mar-13 19:06 
AnswerRe: Threading and insert/update issues. Pin
Mycroft Holmes18-Mar-13 20:33
memberMycroft Holmes18-Mar-13 20:33 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 4:53
membermjackson1119-Mar-13 4:53 
The routine uses the MERGE statement to determine if a record for the particular observation exists. If it does not, it inserts a new record. If a record does exist, it updates the appropriate field.

Problem comes in that there are three raw import records for the particular observation. So the first merge may try to insert something for a high temperature while at the same time the system is trying to insert for the low temperature.

I can use a cursor to cycle through the imported data row by row but want to avoid the speed hit.

I also can't change the main table to hold a record for each individual type of temperature because of the huge number of records (~17 million per observation cycle)
AnswerRe: Threading and insert/update issues. Pin
PIEBALDconsult19-Mar-13 5:10
protectorPIEBALDconsult19-Mar-13 5:10 
AnswerRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 6:17
professionalGuyThiebaut19-Mar-13 6:17 
GeneralRe: Threading and insert/update issues. Pin
mjackson1119-Mar-13 6:58
membermjackson1119-Mar-13 6:58 
GeneralRe: Threading and insert/update issues. Pin
GuyThiebaut19-Mar-13 7:07
professionalGuyThiebaut19-Mar-13 7:07 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:18
memberkalula17-Mar-13 15:18 
AnswerRe: how did i add calender to my site Pin
NotPolitcallyCorrect17-Mar-13 15:22
memberNotPolitcallyCorrect17-Mar-13 15:22 
AnswerRe: how did i add calender to my site Pin
Mycroft Holmes17-Mar-13 20:57
memberMycroft Holmes17-Mar-13 20:57 
Questionhow did i add calender to my site Pin
kalula17-Mar-13 15:16
memberkalula17-Mar-13 15:16 
AnswerRe: how did i add calender to my site Pin
thatraja4-Oct-13 21:39
protectorthatraja4-Oct-13 21:39 
QuestionSkeptical about Trigger! Pin
Thiru615-Mar-13 0:10
memberThiru615-Mar-13 0:10 
QuestionRe: Skeptical about Trigger! Pin
gvprabu15-Mar-13 0:52
membergvprabu15-Mar-13 0:52 
AnswerRe: Skeptical about Trigger! Pin
Thiru616-Mar-13 0:22
memberThiru616-Mar-13 0:22 
SuggestionRe: Skeptical about Trigger! Pin
gvprabu17-Mar-13 19:37
membergvprabu17-Mar-13 19:37 
GeneralRe: Skeptical about Trigger! Pin
Thiru617-Mar-13 20:16
memberThiru617-Mar-13 20:16 
AnswerRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 0:58
memberMycroft Holmes15-Mar-13 0:58 
GeneralRe: Skeptical about Trigger! Pin
Jörgen Andersson15-Mar-13 3:16
protectorJörgen Andersson15-Mar-13 3:16 
GeneralRe: Skeptical about Trigger! Pin
Mycroft Holmes15-Mar-13 14:23
memberMycroft Holmes15-Mar-13 14:23 

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.