SQL statement help for comparing

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

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

SQL statement help for comparing

Author

Topic

195
Starting Member

2 Posts

Posted - 2009-10-21 : 12:14:04

I am a SQL novice. I am looking to compare the differences between two Collections. In the query below, I am comparing the differences between a single collection. Could this be modified to compare one collection against another?

************************
SELECT DisplayName0, Count(*) AS 'Count', Publisher0, Version0, @CollID as CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0
HAVING COUNT(*) <
(SELECT COUNT(*)
FROM v_FullCollectionMembership X
WHERE X.CollectionID = @CollID)
ORDER BY Publisher0, Version0
************************

I am sure I am leaving out some valuable information, so let me know what you need and I'll answer it.

Thanks for the help! :)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-21 : 12:23:31

you need to provide more info ...may be some sample data and what you want as o/p out of it

195
Starting Member

2 Posts

Posted - 2009-10-21 : 12:49:29

Thanks for the quick reply. The boss wants to compare a group of Windows XP workstations with a gold image to see if there are any differences. The query below counts the differences in add/remove programs between workstations in a single collection (CollID). What I want to do is compare v_Add_Remove_Programs from one collection to either a single machine (ResourceID) or a different collection (CollectionID).

The output would be a list of all applications in add/remove programs that are different from the gold image and a count of how many workstations are different per application.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-10-21 : 12:51:37

learn how to post a question with right supplementary data

http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources