That seems like a massive amount of growth in a 9 month period to me, but it really depends on what's being stored.

If it's down to the level of...

select cast(round(((1*100.0)/9),2) as decimal(5,2))

It's impossible for people to know without knowing the full definition of your tables and how hbhousehold and hbincome are related, but it looks like you're stating that the link...

Whichever table you want fff to be the alias for, you have to define it in the statement.

If you need to refer to the flight table, you need to...

Why have you got a GO in the middle of the stored proc? This will create the stored Proc at that point, then the rest is just a seperate query...

It depends on how many different possible equations there are. If there's only a small number and they aren't going to change, you could use case:

select

partmark,

equation,

case

when...