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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Case Statement.

Author  Topic 

stausif
Starting Member

5 Posts

Posted - 2012-06-20 : 21:32:15
I am writing a CASE statement in the select clause of the object which is giving me an error
The situation is something like this

CASE When Min(Date) then Customer.CustName


Any ideas how would I do it?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-20 : 21:37:51
can you explain your full scenario without we wont be able to understand what you're trying to achieve?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2012-06-21 : 09:30:52
Post some sample data with expected result

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -