tsql - How to refer to a variable create in the course of executing a query in T-SQL, in the WHERE clause? -

-

what title says, really.

if select [statement] whatever, why can't refer whatever column in body of clause? there kind of workaround? it's driving me crazy.

as far i'm aware, can't directly in sql server.

if have use column alias in clause, can this, seems overkill use subquery alias:

select *  (     select [yourcolumn] youralias, etc...    whatever ) yoursubquery youralias > 2

you're better off using contents of original column in clause.


Comments

Post a Comment

Popular posts from this blog

c++ - Compiling static TagLib 1.6.3 libraries for Windows -

-
i having super hard time compiling , using taglib 1.6.3 in qt project. i've tried can think of. taglib claims supported through cmake i'm not having luck. furthermore, i'm confused kinds of files need qt libs! i've built *.a files, *.lib, , *.dll. understand far... believe since i'm working in windows *.lib want. no matter do, end "undefined references" taglib functions try use when try compile qt project. have tried mingw32, msys, visual studio 2008, , cross-compiling windows on linux. turning nothing. what makes less sense me if compile same taglib source qt on mac (g++ think?) works fine! somewhere in windows compilation procedures have going wrong. have been smacking face on desk 30 (on , off) hours trying figure out. since qt uses mingw must compile taglib same compiler? if compile *.lib's visual studio not compatible? are *.a libraries usable in windows? (assuming mingw) i'm still trying handle on c++ stuff, after reading coun...
Read more

xslt - Umbraco and EXSLT sets do not work -

-
i'm creating xslt's using umbraco 4.5.2 , want add de set:distinct function exslt.org (http://www.exslt.org/set/functions/distinct/index.html) however, when reference set:distinct error: system.xml.xsl.xsltransformexception: cannot find script or extension object associated namespace 'http://exslt.org/sets'. i've added files, extension in xslt , namespace this: <?xml version="1.0" encoding="utf-8"?> <!doctype xsl:stylesheet [ <!entity nbsp "&#x00a0;"> ]> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:msxml="urn:schemas-microsoft-com:xslt" xmlns:exsl="http://exslt.org/functions" xmlns:set="http://exslt.org/sets" xmlns:umbraco.library="urn:umbraco.library" xmlns:exslt.exsltcommon="urn:exslt.exsltcommon" xmlns:exslt.exsltdatesandtimes="urn:exslt.exsltdates...
Read more

php - How can I merge Nodes & Webform Submissions into instances of one general Content Type in Drupal 6? -

-
i built site using drupal 6 allows users submit information site owner in 3 different ways. are: webform a : quick contact - collects name, email, phone , message. webform b : free pdf book email webform - collects info similar above, , sends user email pdf attachment book written site owner. node create : case evaluation - form node creation page using multi-step module, cck , lot of conditional fields. anonymous users can fill out form , node data emailed site owner based on rule created. all 3 of these forms work in terms of doing supposed site. webform submissions accessed webform node owner, , set table view manage node submissions. even though forms gathering different data, @ end of day, important data personal contact information (each 1 collects name, email and/or phone), , each form submission (from of forms) considered lead owner , followed on. i centralize these various form submissions (2 webforms + 1 node) 1 content type (leads) managed 1 page, rather t...
Read more