Oh that's a BIG help.

I guess it will tell me when I've gone too far.

Thanks anyway, Drew.

What would the expected results your sample data look like from your example above? Please don't describe it. Just draw us a picture. 🙂

You cannot choose columns...

To be clear, part of the purpose of the Holiday table is to serve as a join when creating the calendar table. In the previous calendar...

Understood. Thanks for the reply.

Why can't you create triggers on the tables?

Why on earth are you duplicating rows in that table instead of just adding a separate column for LBS??

I just sent you an update query. It's not going to solve your problem of duplicate data in the table.

Agreed. You have to substitute the table name into your string and then execute it.

Without seeing the layout of your numbers_table table (which is redundundant by the way) and some sample data, we have no way of telling why you're seeing duplicates in...

declare @mytable table (FC int, OrigNum varchar(50))

insert into @mytable (OrigNum)

values

('7 1601081408920063')

,('7 1601081408920063')

,('7 1507210892006300')

,('7 1507210892006300')

update @mytable

set FC = left(OrigNum,1)

,Orignum = right(OrigNum, len(OrigNum)-2)

select * from @mytable

To close to bedtime to code and test, but you should just be able to use the LAG and LEAD operations in a cte to look at the previous [price]...

you should specify the window frame (generally ROWS UNBOUNDED PRECEDING), because the default is RANGE UNBOUNDED PRECEDING, and which is much slower than specifying the range using the ROWS...

You will find some good example code as well as some other considerations in the discussion HERE.

Do NOT follow my example of a loop with DELETE TOP(5000)....

I'll bet you do. Sounds like a dream job.

Thanks for answering, promptly. I was having trouble ceasing to imagine a tiny little couch for bytes.

How can I argue with that? 😀

Some people have yet to implement a calendar table though. Even those who have might get asked for a period which...