Click here to Skip to main content
       

Database

 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 1:32 
GeneralRe: Having a bad SQL day [modified] PinmemberJörgen Andersson13-Feb-13 1:40 
GeneralRe: Having a bad SQL day PinmemberBernhard Hiller13-Feb-13 4:24 
GeneralRe: Having a bad SQL day PinmemberTheComputerMan13-Feb-13 4:33 
AnswerRe: Having a bad SQL day PinmemberShameel13-Feb-13 1:53 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 1:56 
GeneralRe: Having a bad SQL day PinmemberPIEBALDconsult13-Feb-13 5:01 
GeneralRe: Having a bad SQL day PinmemberJörgen Andersson13-Feb-13 7:27 
Yes, thats equivalent. I just prefer the readability of the CTE (which is merely an opinion) plus that you can refer to a CTE in more than one place.
"The ones who care enough to do it right care too much to compromise."
Matthew Faithfull

QuestionWhat is Ado.net PinmemberHimanshu Sharma 88812-Feb-13 20:20 
AnswerRe: What is Ado.net PinmvpRichard MacCutchan12-Feb-13 23:31 
GeneralRe: What is Ado.net PinmemberShameel13-Feb-13 1:44 
GeneralRe: What is Ado.net PinmemberThomas Gabriel20-Feb-13 23:42 
AnswerRe: What is Ado.net PinmvpSandeep Mewara13-Feb-13 1:23 
QuestionSQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 7:47 
AnswerRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 8:48 
GeneralRe: SQL 2008 Truncate vs Delete Pinmembermrfalk12-Feb-13 9:27 
GeneralRe: SQL 2008 Truncate vs Delete PinmvpEddy Vluggen12-Feb-13 9:36 
GeneralRe: SQL 2008 Truncate vs Delete PinmemberKhorshed Alam, Dhaka18-Feb-13 19:09 
AnswerRe: SQL 2008 Truncate vs Delete PinmemberNickPace12-Feb-13 11:09 
AnswerRe: SQL 2008 Truncate vs Delete Pinmemberdjj5513-Feb-13 4:59 
AnswerRe: SQL 2008 Truncate vs Delete Pinmembergvprabu20-Feb-13 22:37 
QuestionSQL Server 2008 PinmemberVishwaKL10-Feb-13 18:51 
AnswerRe: SQL Server 2008 PinmemberShameel10-Feb-13 23:33 
AnswerRe: SQL Server 2008 Pinmemberjschell11-Feb-13 9:20 
Questionupdate values in a table in single query Pinmembernainakarri7-Feb-13 21:07 

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.141220.1 | Last Updated 19 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid