Link to home
Start Free TrialLog in
Avatar of Briancslnet
BriancslnetFlag for United States of America

asked on


Heres a good one for everybody;

I have a report which uses an SQL database.  I have 4 tables which are linked in the report.
The first table references the second table on a field called "Part_id".  What I want to select is those records in the first table which DO NOT exist in the second table.
I have tried "select...from..... WHERE Part_ID in secondtable IS NULL AND  blah.blah.blah...

the program just hangs in preview mode with reporting services.  Cannot seem to figure this out.
Any help or booting in the correct direction would be appreciated.
Avatar of edlunad
Flag of United States of America image

You query does run if you execute it directly in your Sql Server?

Have you tried to restart the service SQL Server Reporting Services?
First check result set size,if it's more records,May be memory constraint in your pc.

Soln: Result set stored in Separate Table and use Table in SSRS.

seelct  PARTID from table1  
where not exists(select 'x' from table2 where  table1.partid=table2.partid)

Avatar of Briancslnet


Not sure we are on the same page, I will try to explain with more depth.

I have a table of Part numbers. I use this table as my primary table for an SQL query (i.e.  SELECT * FROM PARTTABLE)

I have a second table of existing orders.  We call these REQUIREMENTS

I am creating a report of PARTS which have NO requirements.

In addition I then need to extract specific data from 2 additional tables (i.e. a CUSTOMER table and a PARTDESCRIPTION table)

I have a very limited knowledge of SQL formats and hope somebody can give me  the syntax for a select statement, or at least send me in the right direction.
Avatar of edlunad
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mike McCracken
Mike McCracken

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.