Will do.

DECLARE @Tour TABLE (tourID INT IDENTITY PRIMARY KEY

,tourName VARCHAR(50) NOT...

SELECT REPLICATE('0', 16 - LEN(LTRIM(RTRIM('SomeValue'))))

+ LTRIM(RTRIM('SomeValue'))

If Product can have only 1 Type:

SELECT ProductId

,[Type]

,COUNT(1) ProductCount

,AVG(MAN) MAN

,AVG(PUR) PUR

,AVG(SUB) SUB

,AVG(LB) LB

,AVG(OH) OH

,AVG(TotalCost)...

We have a job that runs every couple of minutes on all servers and populates table with the following information: LoginName, HostName, DatabaseName, CreateDT, LastModifiedDT, etc.

From this we can see...

Please try this:

CREATE TABLE dbo.TestDate (ID TINYINT IDENTITY

...

SELECT * FROM NoActivity

WHERE (BranchNumber = '135' ...

In SQL Server 2000 it is not possible to pass a table column as parameter for a table-valued function.

Not the most elegant solution, but maybe this will help:

SELECT ProductId

,COUNT(1) ProductCount

,SUM(MAN) MAN

,SUM(PUR) PUR

,SUM(SUB) SUB

,SUM(LB) LB

,SUM(OH) OH

...