Post ur table structure in form of Create Table, and sample data in form of insert into scripts , image/visual representation of ur desired result, we will provide u a...

Mate, i guess u got my name wrong..i am ColdCoffee and SSC-Enthusiastic is the category what SqlServerCentral.com has assigned me to..

and for the function, it worked as ur...

Lowell, ur code works fine.. but i think u missed one part in mark's question..

Mark says that if there is match between the values present in the columns, then...

That function probably is not the best-perfomant, rather a clean-working one..

here is a table where i used taht function as computed column, it worked fine for me

create table testings

(

...

HI mark, here is your function

Sample table and data

if object_id('tempdb..#test') is not null

drop table #test

create table #test

(

A smallint,

B smallint,

C smallint,

D smallint,

E smallint

)

INSERT INTO #test

SELECT 1,2,3,5,4

UNION...

hi mark, can u pls post some visual examples of your table which has the count and your expected result.. i actually semi-understood ur question :(.. any help in this...

Please provide table structure, sample data, ur input , and YOUR DESIRED OUTPUT.. even if sentences in your post fail to educate us with ur requirement, the desired output part...

I appreciate your time for going thro the article and posting a table structure. Thanks 🙂

Whilst you were editing your post i was creating the table structure and sample data.

Table...

Please post ur table structure, sample data...

Go thro the following article to see how to post them

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Welcome Mate... and thanks for going thro the...

Lynn petis, jeff moden, steve jones, gail shaw, garadin, jack, rbarry, paul, anirban, gsquared, ninja , nabha ,cirqudesqliel etc etc etc etc- these are all stalwarts here, and u can...

Paul, i have a doubt here.. did i answer to OP's question.. i understood it in a way and i have provided the link.. do u think i have given...

Yes paul! 😉

Hi jfallsen, please post sample data, ur table structure, and ur desired output.. this is really pain staking to create them and then attend ur request.. as i had time...

Dear Will, please go through the following article by Jeff http://www.sqlservercentral.com/articles/Best+Practices/61537/ on forum etiquettes..

the information u have provided is not sufficient for us to help u... please post the table...