Templates mean

2151

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

2009

Does the minimal spanning tree of a graph give the shortest distance between any 2 specified nodes?

1016

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

Explain the difference between free electron theory and band theory of solids?

1139

What are the activity lifecyle callbacks?

987

How to Implement static object hierarchies in ATL ?

3770

What steps have you taken to link these divers to your team's compensation?

1742

What types of pneumatic conveying systems are typically used?

1093

what is the difference between R/3 Internet sales and CRM Internet sales?can a plant be assigned to multiple company codes?can a sales org. be assigned?

2543

What is the difference between context filter to other filters?

436

How to initiate variable in angularjs?

846

How do you use the sort function?

888

On what conditions exchange 2013 can coexists with previous version of exchange servers?

1018

What are the Types of session management in ASP.NET

1084