I installed SQL Server 2008R2 it has BI tools, and I started SSAS Project, by that I'm thinking SSAS was installed?? that's what I thought

SSAS

Hi Steve

I don't understand what do you mean by that. Service being installed as an instance or the default instance.

I installed BIDS 2008 R2. anything further than that, I'm...

I edited the code to the following.

Firstly I have this table:

CREATE TABLE [dbo].[Hosea_tblDef_Cloning_Ref_Table](

[ID] [int] IDENTITY(1,1) NOT NULL,

[CLONE_ID] [int] NOT NULL,

[DESCRIPTION] [varchar](50) NOT NULL,

[ACTIVE] [char](1) NULL,

[PROCESSED] [char](1) NULL

CONSTRAINT [un_clone_id] UNIQUE...

Thank you. So much.

That Scenario True: old product_Id would be AGP and old Fund_Id E01..

then later I want to creat another product with the same attributes as AGP product, except this new product...

Yes, any columns in the Hosea_tblDef_Cloning_Table, under the column [COLUMN_NAME], will be the combination.. In our select list selecting new values and where clause comparing with old values..

Product_ID and FundID are from Hosea_tblDef_Cloning_Table, from the column COLUMN_NAME, so any value in that column will always be there in the WHERE CLAUSE. on this case is (Product_ID and...

Product_ID and FundID are from Hosea_tblDef_Cloning_Table, from the column COLUMN_NAME, so any value in that column will always be there in the WHERE CLAUSE. on this case is (Product_ID and...

Yes that's what I'm tempting.

Can I also mention my Code has changed to this:

declare

@New_Value varchar(50),

@Col varchar(50),

@TableName varchar(50)

select @TableName = [TABLE_NAME]

from [Hosea_tblDef_Cloning_Table]

select @New_Value = [NEW_VALUE]

from [Hosea_tblDef_Cloning_Table]

SELECT '[' + t.table_schema + '].[' + t.table_name +...

CREATE TABLE [dbo].[Hosea_tblDef_RETURNSSSS](

[RETURNS_ID] [int] IDENTITY(1,1) NOT NULL,

[REPORT_ID] [varchar](50) NOT NULL,

[COMPANY] [varchar](150) NULL,

[PRODUCT_TYPE] [varchar](150) NULL,

[PRODUCT_ID] [varchar](150) NULL,

[PRODUCT_DESC] [varchar](150) NULL,

[FUND_ID] [varchar](150) NULL,

[FUND_INCEPTION_DATE] [varchar](6) NULL,

[RETURNS_TYPE_KEY] [varchar](150) NULL,

[RETURNS_TYPE_FILTER] [varchar](150) NULL,

[RETURNS_MONTH_FILTER] [varchar](150) NULL,

CONSTRAINT [PK_tblDef_RETURNSSSS] PRIMARY...

Which script, the ones I sent first or last..

Any luck Chris??

CREATE TABLE [dbo].[Hosea_tblDef_RETURNS](

[RETURNS_ID] [int] IDENTITY(1,1) NOT NULL,

[REPORT_ID] [varchar](50) NOT NULL,

[COMPANY] [varchar](150) NULL,

[PRODUCT_TYPE] [varchar](150) NULL,

[PRODUCT_ID] [varchar](150) NULL,

[PRODUCT_DESC] [varchar](150) NULL,

[FUND_ID] [varchar](150) NULL,

[FUND_INCEPTION_DATE] [varchar](6) NULL,

[RETURNS_TYPE_KEY] [varchar](150) NULL,

[RETURNS_TYPE_FILTER] [varchar](150) NULL,

[RETURNS_MONTH_FILTER] [varchar](150) NULL,

CONSTRAINT...