We are dummying up some sample data for testing. I want to take any number that is NOT 100 and then multiple it by (for example) 0.8. I was thinking I could look at sys.objects and sys.columns to get ...
OK, I am not sure how to describe this. I guess I want to flatten a table into two columns... so basically pivot. Though I can't aggregate it like I could if it was quarter 1 sales, etc... <BR><BR>I'm ...