select

T1.[ID], T1.CollectionID, T1.Department, T1.DocNum, T1.Title, T1.URL, T1.DateAdded, T1.[Description],

T2.[ID], T2.CollectionID, T2.Dept, T2.DocumentName, T2.Document, T2.LastModified, T2.ModifiedBy,

T2.OptionalField1, T2.OptionalField2, T2.OptionalField3, T2.OptionalField4, T2.OptionalField5

from table1 T1 inner join table2 T2 on T1.CollectionID...

No problem..........

Its always good to c u both Sushila and Remi ! Always follow u where ever I c u both together.BTW sushila! r u reffering to sqlservercentral.com when ever u...

What is the need to reverse the string? How abt this?

declare @STR varchar(32)

select @STR  = '0010A'

select(ltrim(replace('@str','0',' ')))

Thnks, I'm gng to do tht. I had it in my mind but I didn't have proper privillages to change it

I can't just use the IF because those columns are retrieved from so many tables, by so many joins, where clauses. It is abt 2 pages procedure and I cant...

Sorry for coming up with the same issue.

When I use Select distinct, then I am unable to use the order by with the other columns which are not pulled by...

sorry..............  forgot to add order by

select  top 1(color)from T,A

where A.[id] = T.order_id

group by color order by count(color) desc

I got what I need. Thanks both of you Sushila and Remi.

thanks

try this

select distinct(week_number), sum(total)

from 'your table'

thats what u need?

by the way r u SRG's pinky?

The query returns i value in the col2 (the count), 1 value in the col 1. I just have to select the col1 value and use it in a SP

I,m done a long back

thanks