Are you recording history in your Dimension or just adding new records / updating existing records?

Hi

I've always done this as chances are you'll be using these in your joins

Using SSIS, how would...

Didn't see you had already sorted it!

Like this?

SELECT * FROM D

LEFT JOIN (SELECT *

FROM

A

WHERE

A.b = 1

) AS A

ON D.a = A.B

durai nagarajan (8/20/2012)

---

if you want the result like this

TranIDCode

201205AMDDOH

201206IXJRMI

then the query should be

select TranID , OriginCode + DestinationCode 'Code' from #Test

if this is not as per your output post a...

What indexes are on the tables?

Hi

If you have products in Table2 that do not exist in Table1 and you want NULLS to be populated change the join to a LEFT JOIN

CREATE TABLE #TEMP

(Date DATE, Product...

Difficult to say without knowing your table structures.

Have you looked into using a FULL OUTER JOIN?

Cheers

Andy

Which Query?

I may be misunderstanding what you are looking for:

If you would like to elaborate?

SELECT

country

,region

,SUM(Current_Actual_Saving) AS 'Current_Actual_Saving'

,SUM(Current_Forecast) AS 'Current_Forecast'

,SUM(Current_Metric) AS 'Current_Metric'

,SUM(Prior_Actual_Saving) AS 'Prior_Actual_Saving'

,SUM(Prior_Forecast) AS 'Prior_Forecast'

,SUM(Prior_Metric) AS 'Prior_Metric'

,SUM(Prior_2_Actual_Forecast) AS 'Prior_2_Actual_Forecast'

,SUM(Prior_2_Forecst)...

No

You can have a composite PK that consists of two (or more) keys but not two PK's

Yep, you are 100% correct Derek as far as I'm aware there is no script that will be a 'Catch All'!

However the OP didn't ask for a Catch All script...

All credits are in the comments:

USE master ;

GO

IF OBJECT_ID('master.dbo.sp_Blitz') IS NOT NULL

DROP PROC dbo.sp_Blitz ;

GO

CREATE PROCEDURE dbo.sp_Blitz

@CheckUserDatabaseObjects TINYINT = 1,

@CheckProcedureCache TINYINT...

Why does 99945678682 not appear in the results?

Andy

Best way of doing this is to join your dataset onto a calendar table in the SQL..

Andy