hi there,

please post table structures and sample data

cheers

yip you right:-)

the primary key constraint reqiures values to be unique, by deleting a value, you are still satisfying that reqiurement.

i dont see why you can't

Are you referring to nested triggers?

code will help

run this sql

declare @s-2 nvarchar(200)

set @s-2= '[Q1 ''10] ,[Q2 ''10] ,[Q3 ''10] ,[Q4 ''10] '

select @s-2

--this is the result

[Q1 '10] ,[Q2 '10] ,[Q3...

allow your label to read as [Q4 '10], but your value as [Q4 ''10].

you can achieve this by selecting your quarters as labels and use a replace quarters for values.

hope...

Hi again,

i inserted the data as

select * into test2 from (

select 'a1' Value, 'S9' Value2,NULL Date, 'M1' as Value3

union all

select 'b1' ,'S3' ,NULL ,'B1'

union all

select 'b1' ,'S3' ,'2010-01-27 00:00:00.000', 'B1'

union...

Or select cast(18900 as float)/3600 instead of 2 conversions

if you can post some sample data, it would help.

but to answer your question, a'where date is not null' should get what you are looking for

Apart from dynamic sql, i dont see how this can be done.

Here's an example...

declare @s-2 nvarchar(200)

declare @w nvarchar(200)

declare @col nvarchar(200)

declare @sql nvarchar(200)

set @s-2 ='Select...

Hi,

will this not work?

declare @selectColumns nvarchar(400)

declare @W nvarchar(200)

set @selectColumns ='[Q1 ''10] ,[Q2 ''10] ,[Q3 ''10] ...

I agree, thus the "True" below,

Again i was answering the 'why is the data...

True,

I was just answering nguyennd's question above:-)

Hi nguyennd,

The answer is simple. you do have a clustered index(Primary Key) on the key column. SQL will store data based on this column.

If i have to alter your create...

Hi there,

You looking to divide by 3600

eg. 18900/3600=5.25