Click here to Skip to main content
12,301,935 members (58,483 online)
   

Database

 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 1:55
professionalSimon_Whale10-Apr-13 1:55 
GeneralRe: Table Design help with 2 computed columns Pin
Mycroft Holmes10-Apr-13 2:23
professionalMycroft Holmes10-Apr-13 2:23 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 2:24
professionalSimon_Whale10-Apr-13 2:24 
QuestionHow To Use Pivot in SQL SERVER Pin
srikrishnach9-Apr-13 23:55
membersrikrishnach9-Apr-13 23:55 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Eddy Vluggen10-Apr-13 0:35
mvpEddy Vluggen10-Apr-13 0:35 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Mycroft Holmes10-Apr-13 1:45
professionalMycroft Holmes10-Apr-13 1:45 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Shanalal Kasim12-Apr-13 0:06
memberShanalal Kasim12-Apr-13 0:06 
Questionproblem in join and update Pin
mehdi.sabet9-Apr-13 7:34
groupmehdi.sabet9-Apr-13 7:34 
hi
i wanna update some rows in files table but i face with error.
can every one help me?

my code is :
UPDATE [Common]..[com_Files] SET
      [ReferenceGuid] = (SELECT [Guid] FROM [Personnel]..Missions
            WHERE  [PersonnelSystem]..Missions.ID= [Common]..[com_Files].ReferenceID)
WHERE
      [ReferenceFlag] = 72 AND
      [ReferenceGuid] IS NULL AND
      [ReferenceSoftwareGuid] = '66944D9C-31F4-4594-9407-4E1F64C079D9' and
      [ReferenceID]= [PersonnelSystem]..Missions.ID
GO

thanks for any help
QuestionRe: problem in join and update Pin
Sandeep Mewara9-Apr-13 8:13
mvpSandeep Mewara9-Apr-13 8:13 
AnswerRe: problem in join and update Pin
mehdi.sabet9-Apr-13 8:28
groupmehdi.sabet9-Apr-13 8:28 
AnswerRe: problem in join and update Pin
Richard Deeming9-Apr-13 8:43
professionalRichard Deeming9-Apr-13 8:43 
GeneralRe: problem in join and update Pin
mehdi.sabet9-Apr-13 9:36
groupmehdi.sabet9-Apr-13 9:36 
QuestionMessage Automatically Removed Pin
8-Apr-13 3:46
groupnukalarajesh8-Apr-13 3:46 
QuestionSQL Pin
nukalarajesh8-Apr-13 3:43
groupnukalarajesh8-Apr-13 3:43 
AnswerRe: SQL Pin
Richard Deeming8-Apr-13 4:01
professionalRichard Deeming8-Apr-13 4:01 
AnswerRe: SQL Pin
Eddy Vluggen8-Apr-13 7:45
mvpEddy Vluggen8-Apr-13 7:45 
AnswerRe: SQL Pin
Mycroft Holmes8-Apr-13 12:59
professionalMycroft Holmes8-Apr-13 12:59 
AnswerRe: SQL Pin
GugliMugli9-Apr-13 3:11
memberGugliMugli9-Apr-13 3:11 
Questioncursor out of reference Pin
GugliMugli8-Apr-13 2:59
memberGugliMugli8-Apr-13 2:59 
AnswerRe: cursor out of reference Pin
Simon_Whale8-Apr-13 3:22
professionalSimon_Whale8-Apr-13 3:22 
GeneralRe: cursor out of reference Pin
GuyThiebaut8-Apr-13 4:13
memberGuyThiebaut8-Apr-13 4:13 
AnswerRe: cursor out of reference Pin
Simon_Whale8-Apr-13 4:33
professionalSimon_Whale8-Apr-13 4:33 
GeneralRe: cursor out of reference Pin
GugliMugli8-Apr-13 19:39
memberGugliMugli8-Apr-13 19:39 
Answerthis is solved now..thanks a lot Pin
GugliMugli10-Apr-13 2:38
memberGugliMugli10-Apr-13 2:38 
Questionhow to convert sql server 2008 r2 database to sql server 2005 Pin
reyhane ramezanian6-Apr-13 22:47
memberreyhane ramezanian6-Apr-13 22:47 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.160529.2 | Last Updated 27 May 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid