books for sql 2005

I am trying to get into SSIS I am not a developer but a complete
newbie, I want and need to bring together data from different sources
for reporting services, score carding and anaysis services ect for our
company I am managing to move data from a to b ok however this does
not cover all the tasks i will need to do, can you recoment any good
books for the complete novice for SSIS and for creating cubes i know
to very different subjects.
thanksHello,
For SQL 2005 issue, please go to
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005&sl
cid=us
You shall get more qualified response there.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: Blackduke <blackduke@.nospam.nospam>
| Subject: books for sql 2005
| Date: Fri, 26 Aug 2005 01:48:31 +0100
| Message-ID: <5mpsg1dvm35tnapekonjsshtfn7c94bo3o@.4ax.com>
| X-Newsreader: Forte Agent 3.0/32.763 trialware
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: win020-25977-rtr-adsl-168.altohiway.com 213.83.108.168
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:68476
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I am trying to get into SSIS I am not a developer but a complete
| newbie, I want and need to bring together data from different sources
| for reporting services, score carding and anaysis services ect for our
| company I am managing to move data from a to b ok however this does
| not cover all the tasks i will need to do, can you recoment any good
| books for the complete novice for SSIS and for creating cubes i know
| to very different subjects.
|
|
| thanks
||||The rational guides are designed to get you up to speed quickly at an
inexpensive price point.
Donald Farmer (Microsoft?s Group Program Manager for SQL Server
Integration Services) has one on SSIS and Roger Wolter (Microsoft?s
Group Program Manager for SQL Server Service Broker) has one on
Service Broker. Needless to say, both of these guys are well respected
in the industry.
*Disclaimer* I have a couple of books in this series (not for the
technologies you mentioned however).
http://www.rationalpress.com
HTH ...
--
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
<blackduke@.nospam.nospam> wrote:
>I am trying to get into SSIS I am not a developer but a complete
>newbie, I want and need to bring together data from different sources
>for reporting services, score carding and anaysis services ect for our
>company I am managing to move data from a to b ok however this does
>not cover all the tasks i will need to do, can you recoment any good
>books for the complete novice for SSIS and for creating cubes i know
>to very different subjects.
>
>thanks|||Thanks
On Fri, 26 Aug 2005 10:41:59 -0500, Joe Webb
<joew@.webbtechsolutions.com> wrote:
>The rational guides are designed to get you up to speed quickly at an
>inexpensive price point.
>Donald Farmer (Microsoft?s Group Program Manager for SQL Server
>Integration Services) has one on SSIS and Roger Wolter (Microsoft?s
>Group Program Manager for SQL Server Service Broker) has one on
>Service Broker. Needless to say, both of these guys are well respected
>in the industry.
>*Disclaimer* I have a couple of books in this series (not for the
>technologies you mentioned however).
>http://www.rationalpress.com
>
>HTH ...|||I bought the book but I think it is missing a lot with Script Task like how
to access the current running package's property or how to get the collection
of tasks in the running package......
Maybe I am missing something here!?
"Joe Webb" wrote:
> The rational guides are designed to get you up to speed quickly at an
> inexpensive price point.
> Donald Farmer (Microsoftâ's Group Program Manager for SQL Server
> Integration Services) has one on SSIS and Roger Wolter (Microsoftâ's
> Group Program Manager for SQL Server Service Broker) has one on
> Service Broker. Needless to say, both of these guys are well respected
> in the industry.
> *Disclaimer* I have a couple of books in this series (not for the
> technologies you mentioned however).
> http://www.rationalpress.com
>
> HTH ...
> --
> Joe Webb
> SQL Server MVP
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
> On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
> <blackduke@.nospam.nospam> wrote:
> >I am trying to get into SSIS I am not a developer but a complete
> >newbie, I want and need to bring together data from different sources
> >for reporting services, score carding and anaysis services ect for our
> >company I am managing to move data from a to b ok however this does
> >not cover all the tasks i will need to do, can you recoment any good
> >books for the complete novice for SSIS and for creating cubes i know
> >to very different subjects.
> >
> >
> >thanks
>

books for sql 2005

I am trying to get into SSIS I am not a developer but a complete
newbie, I want and need to bring together data from different sources
for reporting services, score carding and anaysis services ect for our
company I am managing to move data from a to b ok however this does
not cover all the tasks i will need to do, can you recoment any good
books for the complete novice for SSIS and for creating cubes i know
to very different subjects.
thanks
Hello,
For SQL 2005 issue, please go to
http://communities.microsoft.com/new...lserver2005&sl
cid=us
You shall get more qualified response there.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: Blackduke <blackduke@.nospam.nospam>
| Subject: books for sql 2005
| Date: Fri, 26 Aug 2005 01:48:31 +0100
| Message-ID: <5mpsg1dvm35tnapekonjsshtfn7c94bo3o@.4ax.com>
| X-Newsreader: Forte Agent 3.0/32.763 trialware
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: win020-25977-rtr-adsl-168.altohiway.com 213.83.108.168
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:68476
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I am trying to get into SSIS I am not a developer but a complete
| newbie, I want and need to bring together data from different sources
| for reporting services, score carding and anaysis services ect for our
| company I am managing to move data from a to b ok however this does
| not cover all the tasks i will need to do, can you recoment any good
| books for the complete novice for SSIS and for creating cubes i know
| to very different subjects.
|
|
| thanks
|
|||The rational guides are designed to get you up to speed quickly at an
inexpensive price point.
Donald Farmer (Microsofts Group Program Manager for SQL Server
Integration Services) has one on SSIS and Roger Wolter (Microsofts
Group Program Manager for SQL Server Service Broker) has one on
Service Broker. Needless to say, both of these guys are well respected
in the industry.
*Disclaimer* I have a couple of books in this series (not for the
technologies you mentioned however).
http://www.rationalpress.com
HTH ...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg...l/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
<blackduke@.nospam.nospam> wrote:

>I am trying to get into SSIS I am not a developer but a complete
>newbie, I want and need to bring together data from different sources
>for reporting services, score carding and anaysis services ect for our
>company I am managing to move data from a to b ok however this does
>not cover all the tasks i will need to do, can you recoment any good
>books for the complete novice for SSIS and for creating cubes i know
>to very different subjects.
>
>thanks
|||Thanks
On Fri, 26 Aug 2005 10:41:59 -0500, Joe Webb
<joew@.webbtechsolutions.com> wrote:

>The rational guides are designed to get you up to speed quickly at an
>inexpensive price point.
>Donald Farmer (Microsofts Group Program Manager for SQL Server
>Integration Services) has one on SSIS and Roger Wolter (Microsofts
>Group Program Manager for SQL Server Service Broker) has one on
>Service Broker. Needless to say, both of these guys are well respected
>in the industry.
>*Disclaimer* I have a couple of books in this series (not for the
>technologies you mentioned however).
>http://www.rationalpress.com
>
>HTH ...
|||I bought the book but I think it is missing a lot with Script Task like how
to access the current running package's property or how to get the collection
of tasks in the running package......
Maybe I am missing something here!?
"Joe Webb" wrote:

> The rational guides are designed to get you up to speed quickly at an
> inexpensive price point.
> Donald Farmer (Microsoft’s Group Program Manager for SQL Server
> Integration Services) has one on SSIS and Roger Wolter (Microsoft’s
> Group Program Manager for SQL Server Service Broker) has one on
> Service Broker. Needless to say, both of these guys are well respected
> in the industry.
> *Disclaimer* I have a couple of books in this series (not for the
> technologies you mentioned however).
> http://www.rationalpress.com
>
> HTH ...
> --
> Joe Webb
> SQL Server MVP
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg...l/-/0972688811
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
> On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
> <blackduke@.nospam.nospam> wrote:
>
sql

books for sql 2005

I am trying to get into SSIS I am not a developer but a complete
newbie, I want and need to bring together data from different sources
for reporting services, score carding and anaysis services ect for our
company I am managing to move data from a to b ok however this does
not cover all the tasks i will need to do, can you recoment any good
books for the complete novice for SSIS and for creating cubes i know
to very different subjects.
thanksHello,
For SQL 2005 issue, please go to
http://communities.microsoft.com/ne...qlserver2005&sl
cid=us
You shall get more qualified response there.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: Blackduke <blackduke@.nospam.nospam>
| Subject: books for sql 2005
| Date: Fri, 26 Aug 2005 01:48:31 +0100
| Message-ID: <5mpsg1dvm35tnapekonjsshtfn7c94bo3o@.4ax.com>
| X-Newsreader: Forte Agent 3.0/32.763 trialware
| MIME-Version: 1.0
| Content-Type: text/plain; charset=us-ascii
| Content-Transfer-Encoding: 7bit
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: win020-25977-rtr-adsl-168.altohiway.com 213.83.108.168
| Lines: 1
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:68476
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I am trying to get into SSIS I am not a developer but a complete
| newbie, I want and need to bring together data from different sources
| for reporting services, score carding and anaysis services ect for our
| company I am managing to move data from a to b ok however this does
| not cover all the tasks i will need to do, can you recoment any good
| books for the complete novice for SSIS and for creating cubes i know
| to very different subjects.
|
|
| thanks
||||The rational guides are designed to get you up to speed quickly at an
inexpensive price point.
Donald Farmer (Microsofts Group Program Manager for SQL Server
Integration Services) has one on SSIS and Roger Wolter (Microsofts
Group Program Manager for SQL Server Service Broker) has one on
Service Broker. Needless to say, both of these guys are well respected
in the industry.
*Disclaimer* I have a couple of books in this series (not for the
technologies you mentioned however).
http://www.rationalpress.com
HTH ...
Joe Webb
SQL Server MVP
~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/t...il/-/0972688811
I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)
On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
<blackduke@.nospam.nospam> wrote:

>I am trying to get into SSIS I am not a developer but a complete
>newbie, I want and need to bring together data from different sources
>for reporting services, score carding and anaysis services ect for our
>company I am managing to move data from a to b ok however this does
>not cover all the tasks i will need to do, can you recoment any good
>books for the complete novice for SSIS and for creating cubes i know
>to very different subjects.
>
>thanks|||Thanks
On Fri, 26 Aug 2005 10:41:59 -0500, Joe Webb
<joew@.webbtechsolutions.com> wrote:

>The rational guides are designed to get you up to speed quickly at an
>inexpensive price point.
>Donald Farmer (Microsofts Group Program Manager for SQL Server
>Integration Services) has one on SSIS and Roger Wolter (Microsofts
>Group Program Manager for SQL Server Service Broker) has one on
>Service Broker. Needless to say, both of these guys are well respected
>in the industry.
>*Disclaimer* I have a couple of books in this series (not for the
>technologies you mentioned however).
>http://www.rationalpress.com
>
>HTH ...|||I bought the book but I think it is missing a lot with Script Task like how
to access the current running package's property or how to get the collectio
n
of tasks in the running package......
Maybe I am missing something here!?
"Joe Webb" wrote:

> The rational guides are designed to get you up to speed quickly at an
> inexpensive price point.
> Donald Farmer (Microsoft’s Group Program Manager for SQL Server
> Integration Services) has one on SSIS and Roger Wolter (Microsoft’s
> Group Program Manager for SQL Server Service Broker) has one on
> Service Broker. Needless to say, both of these guys are well respected
> in the industry.
> *Disclaimer* I have a couple of books in this series (not for the
> technologies you mentioned however).
> http://www.rationalpress.com
>
> HTH ...
> --
> Joe Webb
> SQL Server MVP
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/t...il/-/0972688811
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
> On Fri, 26 Aug 2005 01:48:31 +0100, Blackduke
> <blackduke@.nospam.nospam> wrote:
>
>

blonde to write query or design fault

Dear All,

Im wondering if its the design that needs to be changed or I simply cant put this together.

I have 3 tables.

1. people (peopId, peopFName, peopSName etc.)
2. codes (codeId, codeName)
3. codedPeople(codePeopleId, peopId, codeId)

Codes represent different skills of people, example the sort of job functions theyve held in their employment. Like:

t-CEO,
t-CFO
t-Founder
etc.

people, clearly holds data about people.

CodedPeople holds data about which people are coded. So person1 can be coded as t-CEO as well t-Founder, and person2 coded as t-CFO

What I need is a query that returns all distinct people records and takes a number of codeNames as input. So if I throw in t-CEO OR t-Founder I get person1, again if I define t-CEO AND t-Founder I get person1.

However when I add t-CEO OR t-CFO I get person1 and person2 but when the query takes t-CEO AND t-CFO I get no result.

I cant seem to come up with anything that would give me a good starting point. Is there a design fault here? All opinions are much appreciated, thanks in advance!"the query takes t-CEO AND t-CFO I get no result."

Is that wrong? No person is t-CEO AND t-CFO in your example.

Please tell us what you want the result to be.|||Thanks for getting back!

Ok, so I have 3 codes and 2 people in the database. (In reality its about 250 different codes and about 10,000 people, growth is about 5000 / year)

I coded person1 as a technology-Chief Executive Officer and also as a technology-Founder (t-CFO, t-Founder)

I also coded person2 as a technology-Chief Financial Officer (t-CFO)

I want to write a query that takes codes as parameters:

t-CEO AND t-Founder = returns person1 (as hes coded as a t-CEO and t-Founder)
t-CEO OR t-CFO = returns person1 and person2 (as person1 is coded as t-CEO and person2 is coded as t-CFO)

t-CEO AND t-CFO = returns no result ( as no person in the db is coded as both a t-CEO and also a t-CFO)

t-CFO or t-Founder = returns person1 and person2 (as person1 is coded as a t-Founder and person2 is coded as a t-CFO)

Am I describing it correctly?

Of course the query need to be flexible as Ill using it from ASP.NET dropping in the parameters so codeName Like t-CEO OR codeName Like t-Founder

I have:

SELECT people.peopId, peopFName, peopSName, peopPhoneHome, peopPhoneMobile, peopEmail, codes.codeId, codename
FROM people INNER JOIN codedPeople ON people.peopId = codedPeople.peopId
INNER JOIN codes ON codes.codeId = codedPeople.codeId
WHERE ( ( codeName LIKE 't-CEO' ) OR ( codeName LIKE 't-CFO' ) )
ORDER BY peopSName, peopFName

But thats useless!|||Let me correct that, I have mixed up the similar codes of t-CEO and t-CFO, the correct one is:

Thanks for getting back!

Ok, so I have 3 codes and 2 people in the database. (In reality its about 250 different codes and about 10,000 people, growth is about 5000 / year)

I coded person1 as a technology-Chief Executive Officer and also as a technology-Founder (t-CEO, t-Founder)

I also coded person2 as a technology-Chief Financial Officer (t-CFO)

I want to write a query that takes codes as parameters:

t-CEO AND t-Founder = returns person1 (as hes coded as a t-CEO and t-Founder)
t-CEO OR t-CFO = returns person1 and person2 (as person1 is coded as t-CEO and person2 is coded as t-CFO)

t-CEO AND t-CFO = returns no result ( as no person in the db is coded as both a t-CEO and also a t-CFO)

t-CFO OR t-Founder = returns person1 and person2 (as person1 is coded as a t-Founder and person2 is coded as a t-CFO)

Am I describing it correctly?

Of course the query need to be flexible as Ill using it from ASP.NET dropping in the parameters so codeName Like t-CEO OR codeName Like t-Founder

I have:

SELECT people.peopId, peopFName, peopSName, peopPhoneHome, peopPhoneMobile, peopEmail, codes.codeId, codename
FROM people INNER JOIN codedPeople ON people.peopId = codedPeople.peopId
INNER JOIN codes ON codes.codeId = codedPeople.codeId
WHERE ( ( codeName LIKE 't-CEO' ) OR ( codeName LIKE 't-CFO' ) )
ORDER BY peopSName, peopFName

But thats useless!

blank cells cause trouble on join

I have a few tables that I am joining together and one of the joins is on a
field that almost always has a code in it. Sometimes it is a blank (not a
null) if the clerk didn't type anything into it. The table that I am joining
to this one, has many cells in the join field thhat are blank and those rows
are used for commenting the other records in the table (I know it is stupid
but I didn't design it).
If I do a regular join whenever it comes upon one of these blanks it joins
to all of the comment records in the 2nd table.
What would be the easiest way to get around this problem?
Below is the statement as far as I got befor the last join messed me up.
cdockets.cdevnttyp has the occasional blank in it and ccodes.codevent is
blank in all rows where they are being used as comments.
SELECT cdcaseid as caseID, cdevtno as eventNum, replace()cdevtdt as
eventDate, cdevtcgpy as ChargedParty, cdcasetyp as caseType,
cdevtjm as Judge, cdevtattny as Attorney,cpcaseid, cpcasetyp,
cpartynum,cpname,cpattny, cgcur9, cgcur3, codeshort, codelong,
codentry
from osmccsdb.cdocket
left outer join osmccsdb.cparty
on osmccsdb.cparty.cpcaseid=osmccsdb.cdocket.cdcaseid
left outer join osmccsdb.ccharge
on osmccsdb.ccharge.cgcaseID = osmccsdb.cdocket.cdcaseid
left outer join osmccsdb.ccodes
on osmccsdb.cdocket.cdevttyp = osmccsdb.ccodes.codentry
order by osmccsdb.cdocket.cdevtdt descLinda,
A LEFT JOIN will return all of the records from the table on left side of
the JOIN keyword and any matching records on the right. I don't have any
sample data to work with but you might look at the NULLIF function and see
if it might help you in your situation.
HTH
Jerry
"Linda Ibarra" <LindaIbarra@.discussions.microsoft.com> wrote in message
news:8953B911-7B98-4A20-BD74-C9FFA335B9B2@.microsoft.com...
>I have a few tables that I am joining together and one of the joins is on a
> field that almost always has a code in it. Sometimes it is a blank (not a
> null) if the clerk didn't type anything into it. The table that I am
> joining
> to this one, has many cells in the join field thhat are blank and those
> rows
> are used for commenting the other records in the table (I know it is
> stupid
> but I didn't design it).
> If I do a regular join whenever it comes upon one of these blanks it joins
> to all of the comment records in the 2nd table.
> What would be the easiest way to get around this problem?
> Below is the statement as far as I got befor the last join messed me up.
> cdockets.cdevnttyp has the occasional blank in it and ccodes.codevent is
> blank in all rows where they are being used as comments.
> SELECT cdcaseid as caseID, cdevtno as eventNum, replace()cdevtdt as
> eventDate, cdevtcgpy as ChargedParty, cdcasetyp as caseType,
> cdevtjm as Judge, cdevtattny as Attorney,cpcaseid, cpcasetyp,
> cpartynum,cpname,cpattny, cgcur9, cgcur3, codeshort, codelong,
> codentry
> from osmccsdb.cdocket
> left outer join osmccsdb.cparty
> on osmccsdb.cparty.cpcaseid=osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccharge
> on osmccsdb.ccharge.cgcaseID = osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccodes
> on osmccsdb.cdocket.cdevttyp = osmccsdb.ccodes.codentry
> order by osmccsdb.cdocket.cdevtdt desc|||I see this with some tools and it is kind of a pain. First thing I would
note is that it is usually a bad idea to have user inputted values being
what you are joining on (but I know you said you didn't design it)
I would probaby just add a condition to your join that says something like:
AND ccodes.codevent <> '' AND the other column too
This will eliminate them from the join. Or if you want the '' rows from one
side, but not the other, then change the '' in the join:
case when ccodes.codevent = '' then 'NOT POSSIBLE' else ccodes.codevent end
Or you could use NULL instead of 'NOT POSSIBLE'
It might not be great for performance, so you might have to do some
trickiness if you have scads of data, but that is just the price you pay :)
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"Linda Ibarra" <LindaIbarra@.discussions.microsoft.com> wrote in message
news:8953B911-7B98-4A20-BD74-C9FFA335B9B2@.microsoft.com...
>I have a few tables that I am joining together and one of the joins is on a
> field that almost always has a code in it. Sometimes it is a blank (not a
> null) if the clerk didn't type anything into it. The table that I am
> joining
> to this one, has many cells in the join field thhat are blank and those
> rows
> are used for commenting the other records in the table (I know it is
> stupid
> but I didn't design it).
> If I do a regular join whenever it comes upon one of these blanks it joins
> to all of the comment records in the 2nd table.
> What would be the easiest way to get around this problem?
> Below is the statement as far as I got befor the last join messed me up.
> cdockets.cdevnttyp has the occasional blank in it and ccodes.codevent is
> blank in all rows where they are being used as comments.
> SELECT cdcaseid as caseID, cdevtno as eventNum, replace()cdevtdt as
> eventDate, cdevtcgpy as ChargedParty, cdcasetyp as caseType,
> cdevtjm as Judge, cdevtattny as Attorney,cpcaseid, cpcasetyp,
> cpartynum,cpname,cpattny, cgcur9, cgcur3, codeshort, codelong,
> codentry
> from osmccsdb.cdocket
> left outer join osmccsdb.cparty
> on osmccsdb.cparty.cpcaseid=osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccharge
> on osmccsdb.ccharge.cgcaseID = osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccodes
> on osmccsdb.cdocket.cdevttyp = osmccsdb.ccodes.codentry
> order by osmccsdb.cdocket.cdevtdt desc|||I would prefer updating those columns with some value,say string and
eliminate that in the where clause. and make it default so that problem wil
l
not come again
--
Regards
R.D
--Knowledge gets doubled when shared
"Linda Ibarra" wrote:

> I have a few tables that I am joining together and one of the joins is on
a
> field that almost always has a code in it. Sometimes it is a blank (not a
> null) if the clerk didn't type anything into it. The table that I am joini
ng
> to this one, has many cells in the join field thhat are blank and those ro
ws
> are used for commenting the other records in the table (I know it is stupi
d
> but I didn't design it).
> If I do a regular join whenever it comes upon one of these blanks it joins
> to all of the comment records in the 2nd table.
> What would be the easiest way to get around this problem?
> Below is the statement as far as I got befor the last join messed me up.
> cdockets.cdevnttyp has the occasional blank in it and ccodes.codevent is
> blank in all rows where they are being used as comments.
> SELECT cdcaseid as caseID, cdevtno as eventNum, replace()cdevtdt as
> eventDate, cdevtcgpy as ChargedParty, cdcasetyp as caseType,
> cdevtjm as Judge, cdevtattny as Attorney,cpcaseid, cpcasetyp,
> cpartynum,cpname,cpattny, cgcur9, cgcur3, codeshort, codelong,
> codentry
> from osmccsdb.cdocket
> left outer join osmccsdb.cparty
> on osmccsdb.cparty.cpcaseid=osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccharge
> on osmccsdb.ccharge.cgcaseID = osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccodes
> on osmccsdb.cdocket.cdevttyp = osmccsdb.ccodes.codentry
> order by osmccsdb.cdocket.cdevtdt desc|||You are a freaking genius!!! I am not sure that I will be allowed to do tha
t
but if I can what a relief! These are court records and I am not sure how
weird they will be about me changing data.
"R.D" wrote:
> I would prefer updating those columns with some value,say string and
> eliminate that in the where clause. and make it default so that problem w
ill
> not come again
> --
> Regards
> R.D
> --Knowledge gets doubled when shared
>
> "Linda Ibarra" wrote:
>|||It was also pointed out to me that if I just created a view of this data
where the records with blank fields were not included and used that for the
join, that that would also eliminate this problem.
"Linda Ibarra" wrote:

> I have a few tables that I am joining together and one of the joins is on
a
> field that almost always has a code in it. Sometimes it is a blank (not a
> null) if the clerk didn't type anything into it. The table that I am joini
ng
> to this one, has many cells in the join field thhat are blank and those ro
ws
> are used for commenting the other records in the table (I know it is stupi
d
> but I didn't design it).
> If I do a regular join whenever it comes upon one of these blanks it joins
> to all of the comment records in the 2nd table.
> What would be the easiest way to get around this problem?
> Below is the statement as far as I got befor the last join messed me up.
> cdockets.cdevnttyp has the occasional blank in it and ccodes.codevent is
> blank in all rows where they are being used as comments.
> SELECT cdcaseid as caseID, cdevtno as eventNum, replace()cdevtdt as
> eventDate, cdevtcgpy as ChargedParty, cdcasetyp as caseType,
> cdevtjm as Judge, cdevtattny as Attorney,cpcaseid, cpcasetyp,
> cpartynum,cpname,cpattny, cgcur9, cgcur3, codeshort, codelong,
> codentry
> from osmccsdb.cdocket
> left outer join osmccsdb.cparty
> on osmccsdb.cparty.cpcaseid=osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccharge
> on osmccsdb.ccharge.cgcaseID = osmccsdb.cdocket.cdcaseid
> left outer join osmccsdb.ccodes
> on osmccsdb.cdocket.cdevttyp = osmccsdb.ccodes.codentry
> order by osmccsdb.cdocket.cdevtdt desc|||yup, you can always have a view. yet what if you want to use data in another
sproc or function or in another view. To solve this permanently have
amechanism where either you dont allow such values(?) or such blanks are
automatically replace with something like 'No Data'
--
Regards
R.D
--Knowledge gets doubled when shared
"Linda Ibarra" wrote:
> It was also pointed out to me that if I just created a view of this data
> where the records with blank fields were not included and used that for th
e
> join, that that would also eliminate this problem.
> "Linda Ibarra" wrote:
>