Problem with left join, please help !

I am doing a left join in this query, but only the records that have a join
are displayed.
There is a record in "cases" with no "casecomments" but it is not displayed
.. please help:
SELECT *
FROM cases a
left join casecomments as b on a.id = b.caseid AND b.lastupdate = (SELECT
MAX(x.lastupdate) FROM casecomments x WHERE x.caseid=a.id)Please provide DDL, sample data and desired results, so we don't have to
guess about these things and so that we provide the right solution.
http://www.aspfaq.com/
(Reverse address to reply.)
"Aleks" <arkark2004@.hotmail.com> wrote in message
news:u0z2W0KKFHA.3928@.TK2MSFTNGP09.phx.gbl...
> I am doing a left join in this query, but only the records that have a
join
> are displayed.
> There is a record in "cases" with no "casecomments" but it is not
displayed
> .. please help:
> SELECT *
> FROM cases a
> left join casecomments as b on a.id = b.caseid AND b.lastupdate = (SELECT
> MAX(x.lastupdate) FROM casecomments x WHERE x.caseid=a.id)
>|||Well, I thought it was a fairly simple issue with the structure of the
query.
SELECT *
FROM cases a
left join casecomments as b on a.id = b.caseid AND b.lastupdate = (SELECT
MAX(x.lastupdate) FROM casecomments x WHERE x.caseid=a.id)
Seems like the left join has some issue because if I have a record in the
cases table and there is no record on the casecomments table with the same
caseid then the record is not displayed, that usually happens with 'inner
join', why would it happen with the statement above if it is a left join ?
A
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:O2O9F5KKFHA.2728@.TK2MSFTNGP10.phx.gbl...
> Please provide DDL, sample data and desired results, so we don't have to
> guess about these things and so that we provide the right solution.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Aleks" <arkark2004@.hotmail.com> wrote in message
> news:u0z2W0KKFHA.3928@.TK2MSFTNGP09.phx.gbl...
> join
> displayed
>|||> Well, I thought it was a fairly simple issue with the structure of the
> query.
Too many assumptions. If you can't be bothered to provide DDL and something
other than a word problem describing the solution you're after, I guess that
solution isn't too important to you. Next thread for me.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.|||Aleks,
Looking at your query, there is no reason why every record from the cases
table should not be displayed... Are you sure the record you are expecting t
o
see is in there? And that the sql you posted is exacttly what you ran ?
Sorry to question that, but what posted seems to me to be inconsistent with
the results you got...
"Aleks" wrote:

> I am doing a left join in this query, but only the records that have a joi
n
> are displayed.
> There is a record in "cases" with no "casecomments" but it is not displaye
d
> ... please help:
> SELECT *
> FROM cases a
> left join casecomments as b on a.id = b.caseid AND b.lastupdate = (SELECT
> MAX(x.lastupdate) FROM casecomments x WHERE x.caseid=a.id)
>
>|||Is not that I can't be bothered, is that I don't know how to do it.
A
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ee0XGPLKFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Too many assumptions. If you can't be bothered to provide DDL and
> something
> other than a word problem describing the solution you're after, I guess
> that
> solution isn't too important to you. Next thread for me.
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>|||You are right, it was something else, another inner join that should have
been left join, sorry, but thanks for the tip.
A
"CBretana" <cbretana@.areteIndNOSPAM.com> wrote in message
news:ADE383C9-0E7A-4B45-A73A-C849472AD2D6@.microsoft.com...
> Aleks,
> Looking at your query, there is no reason why every record from the
> cases
> table should not be displayed... Are you sure the record you are expecting
> to
> see is in there? And that the sql you posted is exacttly what you ran ?
> Sorry to question that, but what posted seems to me to be inconsistent
> with
> the results you got...
> "Aleks" wrote:
>|||> Is not that I can't be bothered, is that I don't know how to do it.
Did you even LOOK AT http://www.aspfaq.com/5006 ''|||Thank you, I was not aware of that page and you don't have to be so
agressive.
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23w97lrLKFHA.2396@.TK2MSFTNGP12.phx.gbl...
> Did you even LOOK AT http://www.aspfaq.com/5006 ''
>sql

Problem with installing SQL Server

Hi All,

I'm running into a problem when trying to install SQL Server onto my laptop that is running Windows XP. The error message that is displayed is:

"An error occurred while creating one or more registry entries. Please see
C:\Windows\sqlstp.log for details. The problem could be caused by a low
registry quota condition."

Does anyone know how to solve this?? Any help would be appreciated.

Thanks,

Pete

Seems to be a complex issue, may need sqlstp.log for trouble-shooting. For a quick check, please take a look at this link, which also mentioned an issue of installing SQL on WinXp:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=182716&SiteId=1

|||Typically this type of error (which isn't SQL Server specific) can/will happen if the account you are using can't access the registry to write/update new entries... or if there aren't enough empty 'slots' available.

Were you running/installing this as admin? (or were you trying to throw this instance on to a DC, etc?)

Try this link as well:
http://www.mcse.ms/archive82-2004-12-1281012.html

problem with images

I have a problem with images being displayed in a report when I select the
image source coming from the web.
The URL I am specifing is
http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742
In the layout i can see the image, in the preview i cannot nor in the
deployed report
when i navigate to this page in a browser the image is shown ok
http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742
I have downloaded service pack 1 which is supposed to resolve this problem
Can anyone help?
Thanks
RichardWell after much searching through the net for similar problems I finally
found the answer.
My page
http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742
returns a progressive jpeg with the content type image/pjpeg
Report services cannot handle this content type. As soon as I changed it to
image/jpeg all works well
Microsoft - This is a bug and it took me at least 8 hours of stress and hair
pulling!
Thanks
Richard
"Richard Wilde" <XXXXinfo@.rippo.co.ukXXXX> wrote in message
news:OJ9IOykHFHA.3628@.TK2MSFTNGP15.phx.gbl...
> I have a problem with images being displayed in a report when I select the
> image source coming from the web.
> The URL I am specifing is
> http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742
> In the layout i can see the image, in the preview i cannot nor in the
> deployed report
> when i navigate to this page in a browser the image is shown ok
> http://localhost/Scimitar/media/thumbnail.aspx?lmediaid=1742
> I have downloaded service pack 1 which is supposed to resolve this problem
> Can anyone help?
> Thanks
> Richard
>

Problem with display of International characters

Hi All,
I have a problem in displaying International characters in SQL Server 2000.
There are a few Russian characters that are displayed as '?' in query
analyzer. i have the database setup on 2 machines. On one DB server the
characters are displayed properly and on other it is shown as '?'.
The machine on which '?' are displayed, i queried syslanguages in which
'Traditional Chinese' and 'Thai' months are displayed incorrectly like small
squares.
Please let me know if there is any SQL server setting required to be changed
or it is some setup issue.
I have also checked 'Ansi to oem conversion' settings.
Thanks
Regards
Sudesh.
This is not a SQL Server problem. Try installing the supplemental language
support files.
1. From Control Panel, select Regional and Language Options
2. From the Languages tab, select the check boxes under Supplement Language
Support.
That should resolve your problem.
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"Sudesh" <sudesh.h@.polaris.co.in> wrote in message
news:4A4B2435-1E31-4E6A-92BA-835D87E68B13@.microsoft.com...
> Hi All,
> I have a problem in displaying International characters in SQL Server
> 2000.
> There are a few Russian characters that are displayed as '?' in query
> analyzer. i have the database setup on 2 machines. On one DB server the
> characters are displayed properly and on other it is shown as '?'.
> The machine on which '?' are displayed, i queried syslanguages in which
> 'Traditional Chinese' and 'Thai' months are displayed incorrectly like
> small
> squares.
> Please let me know if there is any SQL server setting required to be
> changed
> or it is some setup issue.
> I have also checked 'Ansi to oem conversion' settings.
> --
> Thanks
> Regards
> Sudesh.

Problem with Deployed Report

I deployed my phone directory to the server and now dynamic images are no longer being displayed. They are specifically employee photos based on a naming convention. I used the path as ''file:/// etc.'' and when I open up my start menu and throw it into run it works fine. It also runs fine in my visual studio report, but for whatever reason when its deployed it no-longer runs. Does anyone know what could eb causing this problem?

Hello,

You may check to see if the reporting services execution account has access to the file share where the photo's are stored.

Jarret