Create Serial Number using SQL script on MSSQL 2005/2008

There is a build in function for for generation SN

SELECT ROW_NUMBER() OVER (ORDER BY Col1) As SN, Col1 FROM TableName

Vampire war - What to do when hit listed

Hope this is useful.

When Hit Listed:
Keep an eye on the notifications box, it gives you extra time.
1. Bank All your blood (you probably know that already)
2. Use your rage to make attacks where you will use lots of health points, hopefully not skill points. Get HP below 20, and try to keep it there. Bounty hunter will only get 2 strikes at most, so XP loss is minimum.
3. Use the time to: Do missions if possible, Make gifts to your clan, Talk to members of your Clan, Make a shopping list at the Bazaar. Recruit new members.
4. If the Bounty hunter sends a comment , saying sorry, get back to them, say you have no hard feelings, it’s a game. Sound them out for your clan. If they are your kind of Vamp, then invite them in!
5. If you’re getting a string of them: And you’re closing down on VW, Try to get HP down to <10. Then close shop, the HL page will say that you are dead.

my friend send me this message.
thanks Greg Cowell
I cannot post the reference link for this one. because i got this from facebook inbox.