Thank you - I did feel this was the case but the data does not reflect the logic!?

Will now...

Sorry;

My question is;

Do I understand...

Hi Guys,

3 days to go ..... for the 2012 BI training ....

Is there any reference material ( Free PDF ) on BI basics for 2012 or reference sites that...

Sorry - just read the article.

Will have a go at setting this up and testing the data retreival against expected.

Many Thanks

Steve

Thanks - I see what you are doing and agree. But unclear about the "Tally" table and how that would be derived ?

Regards

Steve

J Livingston SQL (9/29/2012)

---

something along these lines......??

--===...

Unfortunately the tables are already defined in our ERP system -

we have - WIPMaster and WIPMaterials

The Master is the header and contains WOrksOrder, Parent and Qty2Make

The Materials contains the...

Sorry - the question is ;

How can I create a view inserting repeated records based on the calculation of two fields;

Congratulations -

When you go to the mcp.microsoft.com site - you will see the Logo's that are relevant to your qualifications. You can build up Virtual Business Cards and...

Brilliant - that is exactly what I was after.

Thank you for your assistance

Ok - sorry about this ....

data to be populated - Master table - InvSteve, link to BomSteve

drop table InvSteve

go

drop table BomSteve

go

create table InvSteve

(

StockCode [char] (30) NULL,

Rev ...

.

Thanks for your reply -

Just a couple of things ... Yes I totally agree that it will look good on the CV - but at the moment not looking...

When you first install sql you specify the collation to use as the default.

you are able to create views and at that time specify the translated collation to use if...

.

Looks like this is the cause of it !

Message

Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.