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)
 How to find a row which is having maximum records

Author  Topic 

thendraljazz
Starting Member

26 Posts
Posted - 2011-12-27 : 06:26:17
Hi,

I need to get a row which is having maximum no of records in a table.

How can i achieve this?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-12-27 : 06:37:44
whats does that mean? can you elaborate with sample data? do you row with maximum size or row with maximum non null column values?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

thendraljazz
Starting Member

26 Posts
Posted - 2011-12-27 : 06:48:29
i have more than 100 columns in my table.using join query i took high price and low price.
now i want to take that particular row which is having maximum number of records(for example the row id:7 is having values in 98 fields means i need to take that particular row)
Is this explanation enough?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-12-27 : 06:55:04
quote:
Originally posted by thendraljazz

i have more than 100 columns in my table.using join query i took high price and low price.
now i want to take that particular row which is having maximum number of records(for example the row id:7 is having values in 98 fields means i need to take that particular row)
Is this explanation enough?

are all the 98 fields of same datatype?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

goodman2253
Yak Posting Veteran

88 Posts
Posted - 2011-12-27 : 06:55:29
can you show the small sample table and the corresponding output which you want.
Then it will be easy to write the query
Go to Top of Page

thendraljazz
Starting Member

26 Posts
Posted - 2011-12-27 : 07:05:04
CREATE TABLE [dbo].[merchantlists2](
[updateddate1] [datetime] NULL,
[MPN1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant1] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice1] [decimal](15, 2) NULL,
[Shipping1] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax1] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice1] [decimal](15, 2) NULL,
[updateddate2] [datetime] NULL,
[MPN2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant2] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice2] [decimal](15, 2) NULL,
[Shipping2] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax2] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice2] [decimal](15, 2) NULL,
[updateddate3] [datetime] NULL,
[MPN3] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant3] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice3] [decimal](15, 2) NULL,
[Shipping3] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax3] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice3] [decimal](15, 2) NULL,
[updateddate4] [datetime] NULL,
[MPN4] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant4] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice4] [decimal](15, 2) NULL,
[Shipping4] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax4] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice4] [decimal](15, 2) NULL,
[updateddate5] [datetime] NULL,
[MPN5] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant5] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice5] [decimal](15, 2) NULL,
[Shipping5] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax5] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice5] [decimal](15, 2) NULL,
[updateddate6] [datetime] NULL,
[MPN6] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant6] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice6] [decimal](15, 2) NULL,
[Shipping6] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax6] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice6] [decimal](15, 2) NULL,
[updateddate7] [datetime] NULL,
[MPN7] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant7] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice7] [decimal](15, 2) NULL,
[Shipping7] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax7] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice7] [decimal](15, 2) NULL,
[updateddate8] [datetime] NULL,
[MPN8] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant8] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice8] [decimal](15, 2) NULL,
[Shipping8] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax8] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice8] [decimal](15, 2) NULL,
[updateddate9] [datetime] NULL,
[MPN9] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant9] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice9] [decimal](15, 2) NULL,
[Shipping9] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax9] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice9] [decimal](15, 2) NULL,
[updateddate10] [datetime] NULL,
[MPN10] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant10] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice10] [decimal](15, 2) NULL,
[Shipping10] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax10] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice10] [decimal](15, 2) NULL,
[updateddate11] [datetime] NULL,
[MPN11] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant11] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice11] [decimal](15, 2) NULL,
[Shipping11] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax11] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice11] [decimal](15, 2) NULL,
[updateddate12] [datetime] NULL,
[MPN12] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant12] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice12] [decimal](15, 2) NULL,
[Shipping12] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax12] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice12] [decimal](15, 2) NULL,
[updateddate13] [datetime] NULL,
[MPN13] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant13] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice13] [decimal](15, 2) NULL,
[Shipping13] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax13] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice13] [decimal](15, 2) NULL,
[updateddate14] [datetime] NULL,
[MPN14] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant14] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice14] [decimal](15, 2) NULL,
[Shipping14] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax14] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice14] [decimal](15, 2) NULL,
[updateddate15] [datetime] NULL,
[MPN15] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant15] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice15] [decimal](15, 2) NULL,
[Shipping15] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax15] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice15] [decimal](15, 2) NULL,
[updateddate16] [datetime] NULL,
[MPN16] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant16] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice16] [decimal](15, 2) NULL,
[Shipping16] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax16] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice16] [decimal](15, 2) NULL,
[updateddate17] [datetime] NULL,
[MPN17] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant17] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice17] [decimal](15, 2) NULL,
[Shipping17] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax17] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice17] [decimal](15, 2) NULL,
[updateddate18] [datetime] NULL,
[MPN18] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant18] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice18] [decimal](15, 2) NULL,
[Shipping18] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax18] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice18] [decimal](15, 2) NULL,
[updateddate19] [datetime] NULL,
[MPN19] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant19] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice19] [decimal](15, 2) NULL,
[Shipping19] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax19] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice19] [decimal](15, 2) NULL,
[updateddate20] [datetime] NULL,
[MPN20] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant20] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice20] [decimal](15, 2) NULL,
[Shipping20] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax20] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice20] [decimal](15, 2) NULL,
[updateddate21] [datetime] NULL,
[MPN21] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant21] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice21] [decimal](15, 2) NULL,
[Shipping21] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax21] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice21] [decimal](15, 2) NULL,
[updateddate22] [datetime] NULL,
[MPN22] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant22] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice22] [decimal](15, 2) NULL,
[Shipping22] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax22] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice22] [decimal](15, 2) NULL,
[updateddate23] [datetime] NULL,
[MPN23] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant23] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice23] [decimal](15, 2) NULL,
[Shipping23] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax23] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice23] [decimal](15, 2) NULL,
[updateddate24] [datetime] NULL,
[MPN24] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant24] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice24] [decimal](15, 2) NULL,
[Shipping24] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax24] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice24] [decimal](15, 2) NULL,
[updateddate25] [datetime] NULL,
[MPN25] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant25] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice25] [decimal](15, 2) NULL,
[Shipping25] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax25] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice25] [decimal](15, 2) NULL,
[updateddate26] [datetime] NULL,
[MPN26] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant26] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice26] [decimal](15, 2) NULL,
[Shipping26] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax26] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice26] [decimal](15, 2) NULL,
[updateddate27] [datetime] NULL,
[MPN27] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant27] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice27] [decimal](15, 2) NULL,
[Shipping27] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax27] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice27] [decimal](15, 2) NULL,
[updateddate28] [datetime] NULL,
[MPN28] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant28] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice28] [decimal](15, 2) NULL,
[Shipping28] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax28] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice28] [decimal](15, 2) NULL,
[updateddate29] [datetime] NULL,
[MPN29] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant29] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice29] [decimal](15, 2) NULL,
[Shipping29] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax29] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice29] [decimal](15, 2) NULL,
[updateddate30] [datetime] NULL,
[MPN30] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant30] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice30] [decimal](15, 2) NULL,
[Shipping30] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax30] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice30] [decimal](15, 2) NULL,
[updateddate31] [datetime] NULL,
[MPN31] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant31] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice31] [decimal](15, 2) NULL,
[Shipping31] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax31] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice31] [decimal](15, 2) NULL,
[updateddate32] [datetime] NULL,
[MPN32] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant32] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice32] [decimal](15, 2) NULL,
[Shipping32] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax32] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice32] [decimal](15, 2) NULL,
[updateddate33] [datetime] NULL,
[MPN33] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant33] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice33] [decimal](15, 2) NULL,
[Shipping33] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax33] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice33] [decimal](15, 2) NULL,
[updateddate34] [datetime] NULL,
[MPN34] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant34] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice34] [decimal](15, 2) NULL,
[Shipping34] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax34] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice34] [decimal](15, 2) NULL,
[updateddate35] [datetime] NULL,
[MPN35] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant35] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice35] [decimal](15, 2) NULL,
[Shipping35] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax35] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice35] [decimal](15, 2) NULL,
[updateddate36] [datetime] NULL,
[MPN36] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant36] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice36] [decimal](15, 2) NULL,
[Shipping36] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax36] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice36] [decimal](15, 2) NULL,
[updateddate37] [datetime] NULL,
[MPN37] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Merchant37] [varchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Baseprice37] [decimal](15, 2) NULL,
[Shipping37] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax37] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BLPrice37] [decimal](15, 2) NULL
) ON [PRIMARY]


this is my table..from tat one row contains record for all fields..i want to find that row and display that row value as first in my gridview(that is sort by number of values)
Go to Top of Page

thendraljazz
Starting Member

26 Posts
Posted - 2011-12-27 : 08:05:18
How can i solve this?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2011-12-27 : 08:17:15
you need to convert all to varchar and use something like

CASE WHEN Col IS NULL THEN 0 ELSE 1 END + ... AS Cnt

and take MAX(Cnt)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts
Posted - 2011-12-27 : 09:22:00
You can solve this by normalizing your tables!

http://en.wikipedia.org/wiki/Database_normalization

http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

vijays3
Constraint Violating Yak Guru

354 Posts
Posted - 2012-01-05 : 12:30:46

You need all column name in the query to sum it

SELECT

CASE WHEN VALUE IS NULL THEN 0 ELSE 1 END +
CASE WHEN VALUE2 IS NULL THEN 0 ELSE 1 END +
CASE WHEN VALUE3 IS NULL THEN 0 ELSE 1 END +
CASE WHEN VALUE4 IS NULL THEN 0 ELSE 1 END+
CASE WHEN VALUE5 IS NULL THEN 0 ELSE 1 END
FROM TableName
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site