Snow, nothing more to add to what everyone has said. Really, Snow, it is time to go, for the children's sake. The scene with your dd shocked me. PLEASE Get out. If you can, stay within reach of DD's school as she will need that continuity, but even if you can't the important thing is to get her away from the whole situation at home.
Also, as I said before, find yourself some support from your nearest Al Anon - if you're in a city, there may be several groups within reach, try all of them till you find one you feel happy with. Ask if they have an Al Ateen group - it's for the children of alcoholics and your DD would probably benefit.
But honestly Snow, the important thing now, is to get them and yourself away - especially if he's at home and drinking all day. What kind of half term hol will it be for DD, if she has to be home and see this?! I don't say this lightly, I'm usually one for trying to keep a relationship together, but you MUST put your children first. I have no idea how low your DH needs to go before he realises he needs to make a change, but it seems now that you have to stop worrying about him, stop trying to make it better, stop taking this all on your shoulders. Take your children and go - make that your first move. Don't worry about what to do next - take it one step at a time. If you try to think too far ahead, it will overwhelm you and you will do nothing.
Please Snow, let your next post be to say you are out!