Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RAFAY
Starting Member
1 Post |
 Posted - 2004-06-03 : 12:41:55
|
| Hello!I got a small problem but i m stuck on it ...if you ppl can help me in this ..the thing is .. i got a sql query that is .. calling some UDF function .. and result will be displayed as a coloumn .. i want to use the result od the same function on the second column .. how we arr going to perform that .. for eg.Select func1(), case when func1() > 0 then 'a' else 'b' end from xyz table ..Is it possible to perform that .. but calling the func1() only once ...thanksrafay |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2004-06-03 : 13:05:09
|
| select case when a.value > 0 then 'a' else 'b' end from (select func1() as value from xyz) as aJay White{0} |
 |
|
|
|
|
|
Dymanic SQL