Yes jeff you are right. Just started to use this forum... I have just posted what I have tried first when I read that.

I know even in our product...

Hi Danny,

1. You can use the parameterized dynamic queries to solve your problem with the dynamic update query.

2. In future if the development project is going for any sort of...

DECLARE @Numbers TABLE (N INT)

DECLARE @MissingNumbers TABLE (N INT)

Declare @vMax int

Declare @vMIn int

INSERT INTO @Numbers

VALUES (50000001),(50000002),(50000019),(51000000)

--VALUES (1),(2),(19),(20)

Set @vMax = (Select MAX(N) from @Numbers)

Set @vMin = (Select MIN(N) from @Numbers)

while(@vMax >...

Hi Guys ,

Please excuse if the solution already exists... My first reply in SQL Central FORUMS..

Create Table TT(RecID int, RecType int, Hierachy smallint, Message char(1))

GO

Insert into TT(RecID, RecType, Hierachy)

Values(1,...