Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 3

Starting Member

21 Posts

Posted - 04/24/2013 :  06:52:30  Show Profile  Reply with Quote
Hi MIK I really don't know about that. I ran a query for all portfolios that have this one service, selecting in addition the associated ID fields for their columns to see if there was any descrepency. It returned over 22200 rows.

But that being said I still would not be able to determine how to select those that no longer have the specific service.

When I am in the software we use I see a portfolio in a sense as a container, much like the common definition of a portfolio. Like a folder with seperate pages only the services are the pages. Now if I have thousands of portfolio's that all have the correct number of pages but in that pile there are maybe a hundred or so that are missing a page how can I seach or compare them without manually going through them one by one?

I understand that in SQL the columns and tables are like containers and in this scenario the records are held in seperate containers. The software we use pulls those records toether to simulate a "Porfolio" container.

I'm thinking there must be some way to compare "those containers".

As of right now it don't seem possible.

Thanks for all the effort.


Go to Top of Page

Flowing Fount of Yak Knowledge

1054 Posts

Posted - 04/24/2013 :  07:49:07  Show Profile  Reply with Quote
Thats alright James, the team would certainly like to help you out, if you could somehow examplify the issue with the help of sample data and desired output. I know its hard for you right now, but when you able to .. do share it with us. I am sure someone would quickly sort it out for you. :)

And yes, just a thought, if you're not famaliar with Join Types; Inner join, Left Join, Right Join, Full Outer Join and Cross Join, then I would strongly recommend that you should read about them in BOL/google pages. I am quite sure that by using correct join(s) you may find out the required missing records/information.

Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000