Click here to Skip to main content
       

Database

 
GeneralRe: Table Design help with 2 computed columns PinprofessionalSimon_Whale10-Apr-13 1:55 
GeneralRe: Table Design help with 2 computed columns PinprofessionalMycroft Holmes10-Apr-13 2:23 
GeneralRe: Table Design help with 2 computed columns PinprofessionalSimon_Whale10-Apr-13 2:24 
QuestionHow To Use Pivot in SQL SERVER Pinmembersrikrishnach9-Apr-13 23:55 
AnswerRe: How To Use Pivot in SQL SERVER PinmvpEddy Vluggen10-Apr-13 0:35 
AnswerRe: How To Use Pivot in SQL SERVER PinprofessionalMycroft Holmes10-Apr-13 1:45 
AnswerRe: How To Use Pivot in SQL SERVER PinmemberShanalal Kasim12-Apr-13 0:06 
Questionproblem in join and update Pingroupmehdi.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 PinmvpSandeep Mewara9-Apr-13 8:13 
AnswerRe: problem in join and update Pingroupmehdi.sabet9-Apr-13 8:28 
AnswerRe: problem in join and update PinprofessionalRichard Deeming9-Apr-13 8:43 
GeneralRe: problem in join and update Pingroupmehdi.sabet9-Apr-13 9:36 
QuestionMessage Automatically Removed Pingroupnukalarajesh8-Apr-13 3:46 
QuestionSQL Pingroupnukalarajesh8-Apr-13 3:43 
AnswerRe: SQL PinprofessionalRichard Deeming8-Apr-13 4:01 
AnswerRe: SQL PinmvpEddy Vluggen8-Apr-13 7:45 
AnswerRe: SQL PinprofessionalMycroft Holmes8-Apr-13 12:59 
AnswerRe: SQL PinmemberGugliMugli9-Apr-13 3:11 
Questioncursor out of reference PinmemberGugliMugli8-Apr-13 2:59 
AnswerRe: cursor out of reference PinprofessionalSimon_Whale8-Apr-13 3:22 
GeneralRe: cursor out of reference PinmemberGuyThiebaut8-Apr-13 4:13 
AnswerRe: cursor out of reference PinprofessionalSimon_Whale8-Apr-13 4:33 
GeneralRe: cursor out of reference PinmemberGugliMugli8-Apr-13 19:39 
Answerthis is solved now..thanks a lot PinmemberGugliMugli10-Apr-13 2:38 
Questionhow to convert sql server 2008 r2 database to sql server 2005 Pinmemberreyhane ramezanian6-Apr-13 22:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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
Web04 | 2.8.140821.2 | Last Updated 21 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid