How can I deal with this situation, The #Header:

select

UPLN.PRDID

,UPLN.PLNID

,UPLN.PLNNM

,UBRC.BRCNM

,UMBR.MBRANM

,UMBR.MBRID

,UINTH.INTID

,UINTH.INTEDT

,UPLN.PLNSCD

from ebl2ulif.UMBR

,ebl2ulif.UPLN

,ebl2ulif.UBRC

,ebl2ulif.UINTH

where UPLN.PLNID = UMBR.PLNID

and UPLN.PRDID = UMBR.PRDID

...

Thought I maybe be wrong, wanted to confirm.

So what about the data types from #Header and #Body since we going to Union both queries?

I'm running the Code in Toad Oracle, so #temp doesn't work there.

Then it's serial I'm looking for.

What I want it's for the results of the second query to be joined to the results of the first query. I don't know if that's parallel or not.

I managed to get it.

Resolved.

Hi Chris

This is what I tried and I'm still getting the same error

DECLARE @CloneID int,

@Active char(1),

@Processed char(1)

SET @CloneID = 1

SELECT TOP 1 ct.table_name,ct.Clone_ID, crt.ACTIVE,...

I need to Use SSAS, I want to learn about Cubes and all of that, the SSAS part of BI. It's for learning purpose nothing more.

I searched for it I can't seem to find it. Is it there anywhere or I can only purchase it??

which...

which version is this 2012 installation, maybe I can download it and start working with it.

Well in that case, Installation that I have doesn't have SSAS as a Check Box. All I have is

Database Engine Services

- SQL Server Replication

- Full-Text Search

Reporting Services

Shared...

Can you provide me with the link to download SSAS, I have googled it and downloaded what I believed to be it, but I still get the same error. I...