Look up the OVER clause

No problem.

Did you test both methods to see which performs better?

In SQL, something like this -

BEGIN TRAN

--Sample data

CREATE TABLE timing (timing INT)

INSERT INTO timing

SELECT *

FROM (VALUES(50),(24),(20),(1),(16),(360),(14000))a(timing)

SELECT timing,

CASE WHEN (timing / 24) = 1

THEN CONVERT(VARCHAR(6),(timing /...

Also, if Operation always contains every Operation then you could do it like this instead: -

--Actual query version 2

SELECT StockCode,

MAX(CASE Route WHEN 0 THEN Route ELSE NULL END) AS...

No problem

BEGIN TRAN

--Sample data

CREATE TABLE BomOperations (StockCode CHAR(5), Route TINYINT, Operation TINYINT)

INSERT INTO BomOperations

SELECT 'PARTA', 0, 1

UNION ALL SELECT 'PARTA', 0, 2

UNION ALL SELECT 'PARTA', 0, 3

UNION ALL SELECT 'PARTA', 0,...

BEGIN TRAN

CREATE TABLE #tables (--all columns here--)

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL + CHAR(10),'') +

'UNION ALL SELECT * FROM ' + QUOTENAME(name)

FROM sysobjects

WHERE (xtype = 'U') AND (name LIKE...

Jnrstevej (1/11/2012)

---

Many thanks for your reply

The problem that i see with the example that you have provided is that is sets the vendor to 1001.

I want the code...

That's a different requirement to...

I guess I don't understand why you're having difficulty...

Sean Lange (1/10/2012)

---

Cadavre (1/10/2012)

---

I can't remember whether or not Jeff Moden's string splitter[/url] already does that, or if I had to edit it but I do know that the TALLY...

Sha_ (1/10/2012)

---

Thanks, Cadavre, for your response.

I'm not sure what 1.79E+308 represents or means. Which one of the two exceeded this value (and how)?

To answer your question, there are large...

Bear in mind that this will break if the tables have different structures.

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL + CHAR(10),'') +

'UNION ALL SELECT * FROM ' + QUOTENAME(name)

FROM sysobjects

WHERE...

Float only goes up to 1.79E+308 IIRC.

What are you doing to need to go higher than that?

I can't remember whether or not Jeff Moden's string splitter[/url] already does that, or if I had to edit it but I do know that the TALLY table method he...