I think Whenriksen summed it all up when he said "Writing the expression once was enough for me." While working out calculations to...

Jeff Moden (10/13/2016)

I missed that on the first read. Thanks,...

Thanks for the explanation. Without seeing a column for "Barn" we have no way of knowing that. But my previous set of options remains...

Not today. 🙂

You should be ashamed, Lynn. 😀

First I'd make sure that your data was correct and that somebody hadn't fat-fingered a flock number.

You have a number of options as I see...

Good read, Chris. Thanks.

Define cascading please. Output from itvf_1 becomes input to itvf_2 ??

WHOA !! THOSE ARE LARGER THAN LIFE !!!!! :w00t:

Eirikur Eiriksson (10/3/2016)

Luis Cazares (10/3/2016)

Jeff Moden (10/2/2016)

Just curious.... what are you doing that...

Hope you get an A....

declare @input table (ID int, Schedule int, ISCI varchar(10), rotationnumber int)

insert into @input

values

(1, 100, 'abc', 9),

(2, 200, 'cod', 5),

(3, 450, 'xay', 1)

select N.*

from @input...

While we're on the subject, does anyone know of a reason there could be a performance hit from doing all these cross applies? I'm assuming it makes...

This is part of an ETL process I'm having to work on replacing. The existing process has rather complicated logic governing when columns can be updated in...

One more thing. One of the reasons I've always loved SSC as a resource is that you guys went to the trouble of writing the code to...

Fortunately, I only need around 300, not thousands. 😀

Thanks guys.