Performance

hi,
my query
Select A.COL1,B.COL1 from
A,B
where convert(varchar(8),A.COL3,108)= convert(varchar(8),B.COL3,108)
provided COL3 is part of the key in both the tables.
So if we try to convert the index of the table to time alone the performance
of the query is affected and it's taking a longer time to execute...
how to solve this?
thanks
vanithaTo add to John's , I think you are going to run into a wrong approach
Why would you want to JOIN these tables ON time column ? Would ut be better
much to add Primary key and Foreing Keu and then to JOIN them . You will be
able to add a WHERE clause for TIME columns as John suggested to store
separately.
"vanitha" <vanitha@.discussions.microsoft.com> wrote in message
news:908FCB48-56DD-4A57-A348-8A0419B48E35@.microsoft.com...
> hi,
> my query
> Select A.COL1,B.COL1 from
> A,B
> where convert(varchar(8),A.COL3,108)= convert(varchar(8),B.COL3,108)
> provided COL3 is part of the key in both the tables.
> So if we try to convert the index of the table to time alone the
> performance
> of the query is affected and it's taking a longer time to execute...
> how to solve this?
> thanks
> vanitha
>

Percentage Calulation in RS

Hey all,
I need to calculate % bases on 2 columns (Col1 and Col2), and my result that
I want is in Col3(%). Please see the layout below. Is that possible?
Col1 Col2 Col3(%)
--
A 5 50%
B 2 20%
C 3 30%
D 0 0%
Total 10 100%
Thanks in advance!
Calculate Percentage> Col1 Col2 Col3(%)
> --
> A 5 (textbox2) 50%
> B 2 (textbox2) 20%
> C 3 (textbox2) 30%
> D 0 (textbox2) 0%
> Total 10(textbox34) 100%
Assuming you have Tabular report Design,
Expression in Col3 can be -
= Reportitems!textbox2.value/Reportitems!textbox34.value
and Format field with %
(My formula syntax can be wrong, use textbox reading syntax)