My Opera is closing 3rd of March

In my Thoughts

"Dream is Not that What you see in Sleep. Dream is the thing Which Does Not Allow You to Sleep."

Sqlserver Case Statement Tricks

Friday, May 22, 2009 4:40:31 AM

Sql Server Case Statement Tricks

Please Refer

http://balavardhanreddy.over-blog.com/article-30089931.html

Datetime Formates and Date time manipulations in SQL ServerGOTO statement in C#

Comments

Unregistered user Saturday, December 5, 2009 6:13:38 PM

PV writes: hi Bala, is anyway i can write following code in Case statement. Please guid me thank you a lot -PV ( ( ( @Variable('EntityType') = 'DEPARTMENT' ) AND ( @Variable('EntityCode') = '--ALL--' ) ) OR ( (@Variable('EntityType') = 'DEPARTMENT') AND(@Variable('EntityCode') != '--ALL--' ) AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.DEPT_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) OR ((@Variable('EntityType') = 'RAILROAD') AND (@Variable('EntityCode') = '--ALL--')) OR ((@Variable('EntityType') = 'RAILROAD') AND (@Variable('EntityCode') !='--ALL--') AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.RAILROAD_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) OR ((@Variable('EntityType') = 'DIVISION') AND (@Variable('EntityCode') = '--ALL--')) OR ((@Variable('EntityType') = 'DIVISION') AND (@Variable('EntityCode') !='--ALL--') AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.DIVISION_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) OR ((@Variable('EntityType') = 'FUNCTION') AND (@Variable('EntityCode') = '--ALL--')) OR ((@Variable('EntityType') = 'FUNCTION') AND (@Variable('EntityCode') !='--ALL--') AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.FUNCTION_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) OR ((@Variable('EntityType') = 'SUBFUNCTION') AND (@Variable('EntityCode') = '--ALL--')) OR ((@Variable('EntityType') = 'SUBFUNCTION') AND (@Variable('EntityCode') !='--ALL--') AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.SUBFUNCTION_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) OR ((@Variable('EntityType') = 'RESCEN') AND (@Variable('EntityCode') = '--ALL--')) OR ((@Variable('EntityType') = 'RESCEN') AND (@Variable('EntityCode') !='--ALL--') AND (LTRIM(RTRIM(Alias_dbo_SAF_ORG_STRUCTURE.RESCEN_CD)) IN (select * from ufn_multi_value_to_tbl(@Variable('EntityCode'))))) )

Write a comment

New comments have been disabled for this post.