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.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2004-06-30 : 01:52:19
|
| hi, i have 3 tables clients, fileinfo and backpdfinfo.client upload files in both table. when i m getting results from 3 tables it's also showing client record from fileinfo and backpdfinfo which has not uploaded files yet. i want only clients which has uploaded files. A client upload last time. my qry is.select caclientsloginid, (select max(upload_date)from fileinfo as Bwhere right(rtrim(filename),3)= 'zip' andfilename <> 'NULL' andb.caclientsloginid=a.caclientsloginidgroup by caclientsloginid)as 'Un-Processed',(select max(upload_date) as 'Processed Send' from backpdfinfo as c where c.caclientsloginid=a.caclientsloginidand filename <> 'NULL'group by caclientsloginid) as 'Processed' ,( select sum(noofmonths) from backpdfinfo where caclientsloginid = A.caclientsloginid group by A.caclientsloginid )as 'No. Of Months'from caclientslogin as A order by caclientsloginid |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-06-30 : 05:48:51
|
| Does FILENAME contain the text value "NULL", or is it set to NULL - i.e. should you be using... filename IS NOT NULL ...instead?Kristen |
 |
|
|
imughal
Posting Yak Master
192 Posts |
Posted - 2004-07-01 : 00:05:44
|
| file name contain text value. |
|
|
|
|
|
|
extract data