I managed to get this working with some tweaking. I used a derived column transform to create a field that concatenates the lookup fields with a semi colon delimeter. The...

After a while I have decided to create the lookup functionality in T-SQL. I have achieved this by using left outer joins and returning the same column for each join...

Hey thanks for that. That has given me some ideas. Will go away and test.

I am not sure what you mean. Could you expand a little please

I mananged to solve it b creating a script task and splitting the parameter into an array and loading the array into an object variable. Then using th ForLoop to...

Many thanks. Will do some research and let you know If I find more information.

Much appreciated for the info. Will check it out.

CREATE TABLE PRODUCTS(

Product_id int CONSTRAINT pk_products_pid PRIMARY KEY

,ProductName varchar(10) null

,ProductType varchar(10) null

,cost_price float null

)

CREATE TABLE SALES(

SalesOrder_id int CONSTRAINT pk_Orders_sid PRIMARY KEY,

Product_id INT CONSTRAINT fk_productSales_pid FOREIGN KEY REFERENCES Products(Product_id),

,quantity int null

,sales_price...

Yeah, i am just looking for a notification error to in for the user that this employe cannot intern more the twice. I will go with the proc to check...

Joe I didn't realise my post would cause such controversy.

The denormalised table that i created was based on a csv source file we get from one of our vendors. It...

worked like a charm!! much appreciated.

I managed to get the desired result by using a recursive CTE as follows.

CREATE TABLE #tstDimPortfolio

(

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

[UPI] [varchar](20) NOT NULL,

[MF_CODE] [varchar](10) NULL,

[BH_Code] [varchar](10) NULL,

[CR_Code] [varchar](10) NULL,

[ValidFrom][varchar](10) NOT...

HI this is almost what I want need. However if a change occurs on two different attributes for one upi how can i bring those chnages through to the subsequent...

thanks, this is what i wanted. Apologies for my poor explanations at the beginning

In the example I gave there are only 3 different packages. However what if there were 2000 packages. I like to have a generic query that will select all the...