45 years since I did algebra at college.

Thanks so much for the refresher guys.

Don't you just hate it when you cant see the wood for the trees.

Yep but how do we calculate Sell knowing Cost , FeeMargin and Margin

Assuming Cost = 500, FeeMargin = 10% and NettMargin = 5%

Sell - Cost - (Sell * FeeMargin) / Cost = NettMargin

Sell -500 - (Sell * 0.10) / 500 = 0.05

The...

Phil

I am struggling to explain this, hence  a valid result in the table.

I need to calculate the sell price by changing the nettmargin

The cost and FeeMargin will persist. The fee...

Hi

Bum data

INSERT #test (tid,data1,data2) VALUES(1111,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1211,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1311,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1111,'foo','foo')

Should read

INSERT #test (tid,data1,data2) VALUES(1111,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1211,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1311,'foo','foo')

INSERT #test (tid,data1,data2) VALUES(1411,'foo','foo')

toddasd

Bingo, thank you so much.

This is part of a database sync system. The commands are built inside a stored procedure they are not stored in tables, just the...

Yes i need to run the results of the SELECT 'DELETE..... statement

DELETE FROM #test where tid =1111 ...

arunyadav007

That only seems to execute the last statement.

I guess i need to somehow loop the results.

Alan

Jeff

I mentioned that there were too many recursions using a second cte, and ordering the tree was nigh on impossible.

We have a solution (or perhaps a botch).

We have created...

Jeff

yes it is 2008

Thanks again

Jeff

All your assumptions are correct. We can probably expect one or two changes to the tree per month.

I am currently working on an iterative loop to rebuild the tree data...

Jeff

The tree displays the categories for the result of either a product or manufacturer search for a website.

One solution we came up with was to number each branch from the...

Thanks for all the replies.

The first CTE is being populated bottom up. i.e. we are passing in a list of branch nodes and getting back each node to the root.

However...

Lutz

OK so I now have to eat my hat!

The results were correct as I imagined they should be. The results were incorrcet as SSMS was truncating the data I was...

Lutz

I am trying to replace the carriage returns with <br /> to display in html.

Increasing the size of the results text now gives me the desired results for the select...