I think you are confusing the issue here. When you create a string literal without the N it is a varchar in the ASCII character set. To get your value...

So we got a little bit of hail Monday evening. Ok so we actually got a crap load of hail. It piled up to almost 4" at the edge of...

Thanks for posting such clean details. You can do this a number of ways. I used a cte here to help demonstrate the logical separation you need. I use your...

I have to agree with sknox. This is a great question but I didn't actually understand the question until I read his comment. I too missed that it was a...