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 2000 Forums
 Transact-SQL (2000)
 dought in sqlserver2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-03 : 08:04:44
shyam writes "sir,
I have databse with name qc_observation and i had
12 column's with the name of
observation_id,
observation_time,
item_code,
sco_no
dim_value1,
dim_value2,
dim_value3,
dim_value4,
dim_value5,
dim_value6,
dim_value7,
dim_value8 from qc_observations and i want to display this observation_time,
dim_value1,
dim_value2,
dim_value3,
dim_value4,
dim_value5,
dim_value6,
dim_value7,
dim_value8 but the columns does not null values . if the columns contaion null values doesn't display please write query for this nad send me sir"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-03 : 10:15:03
Make sure the table is normalised
http://www.datamodel.org/NormalizationRules.html

What do you want to display if the columns are NULL?

Madhivanan

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

- Advertisement -