try

backup log [yourdb] with truncate_only

dbcc sqlperf (logspace) -- returns log size/usage..

immediaelty do full db backup after above log backup .. (the logs are now invalidated)

dbcc shrinkfile ([logical_file_name], sizeMB)

backup...

Ryan,

Perfect! Thanks so much.

It will be used with other views to submit data to the .gov.. so a view is the ideal solution.

Farrell,

I did find your post. But the temp table can't be used in a view if my memory is correct.

I apologize for not being more clear but after staring at this for a good part of the day Im getting a little thick..

I should clarify:

There are thousands of...