please help

I need to run a query to get all the items out of a table where they are not
in a different table... is this possible?
Thanks
GavinGav
SELECT * FROM TableA WHERE NOT EXISTS
(SELECT * FROM TableB WHERE TableA.col=TableB.col)
"Gav" <spam@.spam.com> wrote in message
news:#Rr6tAPDEHA.2564@.TK2MSFTNGP11.phx.gbl...
> I need to run a query to get all the items out of a table where they are
not
> in a different table... is this possible?
> Thanks
> Gavin
>|||perfect thanks for that
Regards
Gavin
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23Bn4AJPDEHA.3804@.TK2MSFTNGP09.phx.gbl...
> Gav
> SELECT * FROM TableA WHERE NOT EXISTS
> (SELECT * FROM TableB WHERE TableA.col=TableB.col)
> "Gav" <spam@.spam.com> wrote in message
> news:#Rr6tAPDEHA.2564@.TK2MSFTNGP11.phx.gbl...
> not
>

Please Assist... Report Templates to save time in designing

In RS 2000 I was able to create a template report and put it in the Project
Items directory, then when I would select New Report Item, I could choose my
template report instead of redesigning everything from scratch.
Where is this folder, or to better phrase this question:
Where do I put my template reports that I want to show up when I choose "Add
new report item" in the designer in SQL 2005 RS?
I have checked the folders - but obviously I am missing something.
Thanks in advance!
=-ChrisI had to search through my computer for *.rdl files. Finally I think I found
the templates at
C:\Program Files\Microsoft Visual Studio
8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject
Kaisa M. Lindahl Lervik
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> wrote in message
news:uOtrsue%23GHA.1220@.TK2MSFTNGP05.phx.gbl...
> In RS 2000 I was able to create a template report and put it in the
> Project
> Items directory, then when I would select New Report Item, I could choose
> my
> template report instead of redesigning everything from scratch.
> Where is this folder, or to better phrase this question:
> Where do I put my template reports that I want to show up when I choose
> "Add
> new report item" in the designer in SQL 2005 RS?
> I have checked the folders - but obviously I am missing something.
> Thanks in advance!
> =-Chris
>