Click here to Skip to main content
   

Database

 
QuestionRe: EXEC sp_helptext Pinmemberjojoba201127-Nov-12 0:38 
AnswerRe: EXEC sp_helptext Pinmemberdjj5527-Nov-12 1:59 
QuestionRe: EXEC sp_helptext [modified] Pinmemberjojoba201127-Nov-12 4:09 
AnswerRe: EXEC sp_helptext PinmemberEddy Vluggen27-Nov-12 14:33 
QuestionRECORD VALIDATION IN ACCESS Pinmemberteto26-Nov-12 6:19 
SuggestionRe: RECORD VALIDATION IN ACCESS PinmemberAndré Kraak26-Nov-12 6:56 
AnswerRe: RECORD VALIDATION IN ACCESS Pinmemberdjj5526-Nov-12 7:05 
Questionhow to compare an operation in where expression In sql [modified] PinmemberGREG_DORIANcod26-Nov-12 5:29 
hi everybody I need to do something like that:
 
select x.ProductName, sum(x.field1+y.field2) as Mysum, y.field2 from tablexxx as x inner join tableyyy as y on x.id =y.id where as Mysum - y.field2 > 0
 
obviously it doesnt work!, but I'm looking for suggestions

modified 26-Nov-12 10:42am.

AnswerRe: how to compare an operation in where expression In sql Pinmembers_magus26-Nov-12 6:20 
AnswerRe: how to compare an operation in where expression In sql PinmemberMycroft Holmes26-Nov-12 12:56 
Questiongrant permission on table in another database PinmemberDan_K26-Nov-12 4:55 
QuestionRe: grant permission on table in another database PinmemberChris Meech26-Nov-12 9:25 
QuestionHow to mearge local database with server database PinmemberJitendra Parida198723-Nov-12 23:00 
AnswerRe: How to mearge local database with server database PinmemberMycroft Holmes23-Nov-12 23:17 
AnswerRe: How to mearge local database with server database Pinmemberdjj5525-Nov-12 3:48 
GeneralRe: How to mearge local database with server database PinmemberJitendra Parida198725-Nov-12 19:13 
GeneralRe: How to mearge local database with server database PinmemberGREG_DORIANcod26-Nov-12 6:56 
AnswerRe: How to mearge local database with server database PinmemberDeepak Kumar1128-Nov-12 2:31 
RantStupid bloody idiot PinmemberMycroft Holmes18-Nov-12 22:25 
GeneralRe: Stupid bloody idiot PinmemberJ4amieC18-Nov-12 23:39 
GeneralRe: Stupid bloody idiot PinmemberRichard Deeming19-Nov-12 2:46 
GeneralRe: Stupid bloody idiot PinmemberMycroft Holmes19-Nov-12 12:43 
Questionlogin with another user faile problem Pingroupmehdi.sabet18-Nov-12 22:11 
AnswerRe: login with another user faile problem PinmemberMycroft Holmes18-Nov-12 22:20 
AnswerRe: login with another user faile problem PinmemberJoy Sinha22-Nov-12 21:02 

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.150123.1 | Last Updated 25 Jan 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid