Problem with query

Hi,
I have a query that is supposed to return records and make a left join where
one field is not null, but for some reason is not working properly and
returns the records even though they are null.
SELECT *
FROM cases a
left join activities as w on a.id = w.caseid AND w.Dateinitiated = (Select
MAX(y.Dateinitiated)
From Activities y Where y.caseid = a.id AND y.ActType ='HISTORY' and
y.dateinitiated IS NOT NULL and y.processtep IS NOT NULL)
Any help is greately appreciated.
AleksAleks,
The reason the query seems to be returnning records from Activities,
where the Dateinitiated column is null, is because you have specified an
Outer Join.
When you specify An Outer Join, Al records from the Outer table are
returned, even when there is no match on the other side. You actually are
NOT returning any data from Activities Table where Dateinitiated column is
null. If you look at those rows, you'll probably notice that all the field
s
from Activities table are null there...
"Aleks" wrote:

> Hi,
> I have a query that is supposed to return records and make a left join whe
re
> one field is not null, but for some reason is not working properly and
> returns the records even though they are null.
> --
> SELECT *
> FROM cases a
> left join activities as w on a.id = w.caseid AND w.Dateinitiated = (Select
> MAX(y.Dateinitiated)
> From Activities y Where y.caseid = a.id AND y.ActType ='HISTORY' and
> y.dateinitiated IS NOT NULL and y.processtep IS NOT NULL)
> --
> Any help is greately appreciated.
> Aleks
>
>

Problem with PDF Exports in RS 2000 SP2....

Hello All,

when we export to pdf, keeptogether functionality is not working properly in Table.Is this fixed in RS2005?

Does anyone know when rs2005 will be released?.

Thanks in Advance.

rs2005 was released with SQL2005 together some months ago.|||

Hi,

Keeptogether is not working for report export to PDF in VS2005... I have a 4 column report and the List (with embedded List) does not wrap as I expected with Keeptogether=False. Am I doing something wrong? Is there a trick I'm missing.

Thanks.... Frank

|||I have this problem too, in SRS2005, list w/ embedded list acts as if keeptogether is on when export to PDF or print. Mine is only 1 column. Did you ever find a solution? Possibly a bug with embedded lists?

Problem with PDF Exports in RS 2000 SP2....

Hello All,

when we export to pdf, keeptogether functionality is not working properly in Table.Is this fixed in RS2005?

Does anyone know when rs2005 will be released?.

Thanks in Advance.

rs2005 was released with SQL2005 together some months ago.|||

Hi,

Keeptogether is not working for report export to PDF in VS2005... I have a 4 column report and the List (with embedded List) does not wrap as I expected with Keeptogether=False. Am I doing something wrong? Is there a trick I'm missing.

Thanks.... Frank

|||I have this problem too, in SRS2005, list w/ embedded list acts as if keeptogether is on when export to PDF or print. Mine is only 1 column. Did you ever find a solution? Possibly a bug with embedded lists?

Problem with PDF Exports in RS 2000 SP2....

Hello All,

when we export to pdf, keeptogether functionality is not working properly in Table.Is this fixed in RS2005?

Does anyone know when rs2005 will be released?.

Thanks in Advance.

rs2005 was released with SQL2005 together some months ago.|||

Hi,

Keeptogether is not working for report export to PDF in VS2005... I have a 4 column report and the List (with embedded List) does not wrap as I expected with Keeptogether=False. Am I doing something wrong? Is there a trick I'm missing.

Thanks.... Frank

|||I have this problem too, in SRS2005, list w/ embedded list acts as if keeptogether is on when export to PDF or print. Mine is only 1 column. Did you ever find a solution? Possibly a bug with embedded lists?