DECLARE @Source TABLE (Id int, ServerName char(7), DateFrom datetime, DateTo datetime)

INSERT INTO @Source SELECT 1, 'APAXSG1', '01/01/2007', '01/31/2007'

UNION SELECT 2, 'APAXSG1', '01/15/2007', '02/15/2007'

UNION SELECT 3, 'APAXSG1', '02/01/2007',...

UPDATE TableName

SET EndDate =

CASE

WHEN StartDate > '2003/01/01' THEN DATEADD(day, Days, StartDate)

WHEN StartDate < '2003/01/01' THEN ??? ((1/1/2003-1/1/2000)+1) is what date? why not add 10?

ELSE ???????? /* StartDate = '2003/01/01' */

END

search this forum on sp_MSforeachdb

Although nothing is returned, your script generates no syntax (or any) error.

SrockCode12 uses StockCode20.

So it is not shown.

I'm only displaying the lowest level item.

DECLARE @BOM TABLE (Product varchar(11), Part varchar(11))

INSERT INTO @BOM SELECT 'StockCode1', 'StockCode2'

UNION ALL SELECT 'StockCode1', 'StockCode3'

UNION ALL SELECT 'StockCode1', 'StockCode4'

UNION ALL SELECT 'StockCode1', 'StockCode5'

UNION ALL SELECT 'StockCode2', 'StockCode10'

UNION ALL SELECT...

UNION will combine dupilcate result sets to a single set.

UNION ALL will produce the same result as the second query and performance will be similar.

noeld (10/30/2007)

---

This a little "simpler 😉

CREATE TABLE #tmp (EmpID INT , LocationID INT , Amount NUMERIC(9,2))

INSERT #tmp

SELECT 1, 1, 15.00 UNION ALL

...

WITH Counts (EmpID, LocationID, Number) AS

(SELECT EmpID, LocationID, COUNT(*) FROM tblTransactions GROUP BY EmpID, LocationID)

SELECT A.EmpID,

(SELECT MAX(Z.LocationID) FROM Counts Z WHERE Z.EmpID = A.EmpID AND Z.Number = (SELECT MAX(Y.Number) FROM...

I think that the problem is the sequence of importing tables.

Referenced tables need to be imported before referencing tables can be.

DECLARE @a TABLE (Name char(4), Date datetime, ID int)

INSERT INTO @a SELECT 'mary', '10/01/2006', 1

UNION SELECT 'john', '10/13/2006', 2

UNION SELECT 'john', '12/17/2006', 2

UNION SELECT 'bob', '01/01/2006',...

How to use a temp table in a view?

DATEADD(day,-10,GETDATE()) AS DateSent

DECLARE @D datetime

SELECT @D = GETDATE()

SELECT DATEADD(day, - DAY(@D), @D)

It maybe that there are no ELSE parts in CASE statements.