Click here to Skip to main content
11,432,168 members (66,322 online)
   

Database

 
AnswerRe: how to create the databse?? Pin
Shanalal Kasim12-Apr-13 1:03
memberShanalal Kasim12-Apr-13 1:03 
AnswerRe: how to create the databse?? Pin
indrakurnia13-May-13 7:57
memberindrakurnia13-May-13 7:57 
QuestionTable Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 1:14
professionalSimon_Whale10-Apr-13 1:14 
AnswerRe: Table Design help with 2 computed columns Pin
Eddy Vluggen10-Apr-13 1:23
mvpEddy Vluggen10-Apr-13 1:23 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 2:28
professionalSimon_Whale10-Apr-13 2:28 
AnswerRe: Table Design help with 2 computed columns Pin
Mycroft Holmes10-Apr-13 2:50
professionalMycroft Holmes10-Apr-13 2:50 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 2:55
professionalSimon_Whale10-Apr-13 2:55 
GeneralRe: Table Design help with 2 computed columns Pin
Mycroft Holmes10-Apr-13 3:23
professionalMycroft Holmes10-Apr-13 3:23 
GeneralRe: Table Design help with 2 computed columns Pin
Simon_Whale10-Apr-13 3:24
professionalSimon_Whale10-Apr-13 3:24 
QuestionHow To Use Pivot in SQL SERVER Pin
srikrishnach10-Apr-13 0:55
membersrikrishnach10-Apr-13 0:55 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Eddy Vluggen10-Apr-13 1:35
mvpEddy Vluggen10-Apr-13 1:35 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Mycroft Holmes10-Apr-13 2:45
professionalMycroft Holmes10-Apr-13 2:45 
AnswerRe: How To Use Pivot in SQL SERVER Pin
Shanalal Kasim12-Apr-13 1:06
memberShanalal Kasim12-Apr-13 1:06 
Questionproblem in join and update Pin
mehdi.sabet9-Apr-13 8:34
groupmehdi.sabet9-Apr-13 8: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 9:13
mvpSandeep Mewara9-Apr-13 9:13 
AnswerRe: problem in join and update Pin
mehdi.sabet9-Apr-13 9:28
groupmehdi.sabet9-Apr-13 9:28 
AnswerRe: problem in join and update Pin
Richard Deeming9-Apr-13 9:43
professionalRichard Deeming9-Apr-13 9:43 
GeneralRe: problem in join and update Pin
mehdi.sabet9-Apr-13 10:36
groupmehdi.sabet9-Apr-13 10:36 
QuestionMessage Automatically Removed Pin
8-Apr-13 4:46
groupnukalarajesh8-Apr-13 4:46 
QuestionSQL Pin
nukalarajesh8-Apr-13 4:43
groupnukalarajesh8-Apr-13 4:43 
AnswerRe: SQL Pin
Richard Deeming8-Apr-13 5:01
professionalRichard Deeming8-Apr-13 5:01 
AnswerRe: SQL Pin
Eddy Vluggen8-Apr-13 8:45
mvpEddy Vluggen8-Apr-13 8:45 
AnswerRe: SQL Pin
Mycroft Holmes8-Apr-13 13:59
professionalMycroft Holmes8-Apr-13 13:59 
AnswerRe: SQL Pin
GugliMugli9-Apr-13 4:11
memberGugliMugli9-Apr-13 4:11 
Questioncursor out of reference Pin
GugliMugli8-Apr-13 3:59
memberGugliMugli8-Apr-13 3:59 
AnswerRe: cursor out of reference Pin
Simon_Whale8-Apr-13 4:22
professionalSimon_Whale8-Apr-13 4:22 
GeneralRe: cursor out of reference Pin
GuyThiebaut8-Apr-13 5:13
memberGuyThiebaut8-Apr-13 5:13 
AnswerRe: cursor out of reference Pin
Simon_Whale8-Apr-13 5:33
professionalSimon_Whale8-Apr-13 5:33 
GeneralRe: cursor out of reference Pin
GugliMugli8-Apr-13 20:39
memberGugliMugli8-Apr-13 20:39 
Answerthis is solved now..thanks a lot Pin
GugliMugli10-Apr-13 3:38
memberGugliMugli10-Apr-13 3:38 
Questionhow to convert sql server 2008 r2 database to sql server 2005 Pin
reyhane ramezanian6-Apr-13 23:47
memberreyhane ramezanian6-Apr-13 23:47 
AnswerRe: how to convert sql server 2008 r2 database to sql server 2005 Pin
Mycroft Holmes7-Apr-13 0:14
professionalMycroft Holmes7-Apr-13 0:14 
GeneralMessage Removed Pin
Maciej Los7-Apr-13 7:41
mvpMaciej Los7-Apr-13 7:41 
GeneralRe: how to convert sql server 2008 r2 database to sql server 2005 Pin
Mycroft Holmes7-Apr-13 13:54
professionalMycroft Holmes7-Apr-13 13:54 
GeneralRe: how to convert sql server 2008 r2 database to sql server 2005 Pin
Maciej Los7-Apr-13 20:53
mvpMaciej Los7-Apr-13 20:53 
AnswerRe: how to convert sql server 2008 r2 database to sql server 2005 Pin
Maciej Los7-Apr-13 20:50
mvpMaciej Los7-Apr-13 20:50 
Questiondiffrence between with and temp table in sql Pin
mehdi.sabet6-Apr-13 9:46
groupmehdi.sabet6-Apr-13 9:46 
AnswerRe: diffrence between with and temp table in sql Pin
Mycroft Holmes7-Apr-13 0:12
professionalMycroft Holmes7-Apr-13 0:12 
GeneralRe: diffrence between with and temp table in sql Pin
mehdi.sabet7-Apr-13 3:58
groupmehdi.sabet7-Apr-13 3:58 
Questionwhat's the problem with this?! Pin
Jassim Rahma6-Apr-13 5:11
memberJassim Rahma6-Apr-13 5:11 
AnswerRe: what's the problem with this?! Pin
Mycroft Holmes7-Apr-13 0:09
professionalMycroft Holmes7-Apr-13 0:09 
AnswerRe: what's the problem with this?! Pin
Richard MacCutchan7-Apr-13 2:16
mvpRichard MacCutchan7-Apr-13 2:16 
Questioncompare performance between two query Pin
mehdi.sabet5-Apr-13 0:30
groupmehdi.sabet5-Apr-13 0:30 
AnswerRe: compare performance between two query Pin
Tim Carmichael5-Apr-13 4:11
memberTim Carmichael5-Apr-13 4:11 
AnswerRe: compare performance between two query Pin
PIEBALDconsult5-Apr-13 4:21
memberPIEBALDconsult5-Apr-13 4:21 
SuggestionRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 8:21
mvpEddy Vluggen5-Apr-13 8:21 
GeneralRe: compare performance between two query Pin
mehdi.sabet5-Apr-13 9:44
groupmehdi.sabet5-Apr-13 9:44 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 9:54
mvpEddy Vluggen5-Apr-13 9:54 
GeneralRe: compare performance between two query Pin
mehdi.sabet5-Apr-13 10:01
groupmehdi.sabet5-Apr-13 10:01 
GeneralRe: compare performance between two query Pin
Eddy Vluggen5-Apr-13 10:04
mvpEddy Vluggen5-Apr-13 10:04 

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
Web02 | 2.8.150428.2 | Last Updated 4 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid