Not exactly sure what you want but here goes

First result - users in BOTH tables

Select *

FROM

INNER JOIN UserProfile

ON [User].UserID=UserProfile.UserID

Second result - users only in table

select *

from

where...

Look up the following books:

The Data Warehouse Toolkit

and

The Data Warehouse ETL Toolkit

Both by Ralph Kimball

They are critical resources for any DW designer/developer

Brandie Tarvin (5/18/2009)

---

When you say "obviously ignoring any aggregated values", how am I supposed to do that when the totals already are aggregated? That's the part that I don't get....

SQL? MDX? Reporting Services? Excel? Table structure?

Need a few more details pal!

I think you'll have to stop using the wizard!

Create your own data source view (DSV), you can create named queries in place of tables and generate the source for the...

agreed:-)

I got it working without the dynamic SQL 2 minutes later and corrected my post 😀

I can't get your version working though... doesn't return...

Posted too quick (and I hate not getting something working!!)

declare @xml as xml

set @xml = '

Somevalue1

somevalue2

somevalue3

'

declare @language as int

set @language =...

Should have added

There is a lot of material here:

http://msdn.microsoft.com/en-us/library/ms345117.aspx

I've not done much with XML so thought I would have a play and came up with this:

declare @xml as xml

set @xml = '

...

If you're a non-profit org then it might be worthwhile having a nice word with red-gate 🙂

have a look here:

http://www.databasejournal.com/features/mssql/article.php/3594926/SQL-Server-2005-TableDiff-Utility.htm

for a table diff utility

the following should help:

Select *

from tableA

where case

when @Type = 'Lname' then Lname...

All my Fuzzy lookup packages are on laptop which is at home...

Try these instead

have a look here:

http://www.sqlteam.com/article/using-fuzzy-lookup-transformations-in-sql-server-integration-services

and here:

http://blogs.conchango.com/jamiethomson/archive/2005/03/30/SSIS_3A00_-Adventures-with-Fuzzy-Matching.aspx

dump the results into a temp table

DECLARE @db_id SMALLINT;

DECLARE @object_id INT;

SET @db_id = DB_ID(N'Wallet0000');

SET @object_id = OBJECT_ID(N'dbo.AuditCollection');

IF @db_id IS NULL

BEGIN;

PRINT N'Invalid database';

END;

ELSE IF...

Red gate offer a tool for comparing SQL Server database schema, its very well priced at $245 too

I'm not aware of any free tools, although (and without wanting to...

I use the following:

right('00'+cast(datepart(month, getdate()) as varchar), 2)

means only 1 reference to the date column