what do u mean by

non-fully-qualified field of Sender in where clause.

CASE WHEN @param5 IS NOT NULL THEN @return+' AND Sender LIKE '''+@param5+'%''' ELSE '' END+

this is my where clause...

I solved it. So dont worry.

The reportid and viewid are mainly used for linking the files with the resultset for user to view those files.

Thats it guys,

Is there no way out that i can get unique values through...

I tried this too

elect @sql = 'SELECT c.Case30.Case_no#,c.Last_name,c.[First Name],c.Determination,c.Sender,c.[Case Type],c.Date,c.[Qwik Due],c.[Qwik sent date],c.[Final due],c.[Final sent date],c.[on hold code],f.reportid,f.type,u.viewid FROM

(SELECT DISTINCT c.*FROM (SELECT DISTINCT Case30.Case_no#,Case30.Last_name,Case30.[First Name],Case30.Determination,Case30.Sender,Case30.[Case Type],Case30.Date,Case30.[Qwik Due],Case30.[Qwik sent...

Data is duplicated in tblFileNames (Case_no#,reportid,type)

Data is duplicated in userviewed (viewid,reportid)

Data is not duplicated in Case30 and caseold

hey,

This is my exact problem. If anybody can help out? In my Case30 and Caseold tables all the values are unique...

Hi David,

If i execute this statement then i get duplicate values but in the same statement if i take out f.reportid and u.viewid then i dont get duplicate values but...

hi schwab and burrows,

Friends u are right. I...

hi david,

The columns which are duplicated are tblfilenames.case_id and because of that case30 and caseoldr.caseNo# also gets duplicated. Other colums...

Hi burrows,

I tried ur way but it still give me duplicates. It gives 304 rows instead of...

Hi Len,

I tried your way too but i am getting error that error near = sign and i also dont know...

Thanks for all the help from everybody. But it was just Brown and 5409045121009 that came near to my query. Brown I tried to do in the way which you...

Thanks for all your help man. But I think u guys have still not understood my problem properly. Read the solution given by Brown. Its preety much what i want...

Thanks for it. Do u think using a temp table in this example would be helpful? If yes then how to do it. I would really appreciate if you can...