Finding unique combinations of fields SQL SERVER
===

I'm trying to write a select query but am having trouble, probably because I'm not familiar with SQL SERVER (usually use MySQL). Basically what I need to do is find the number of unique combinations of 2 fields, one a varchar and one a double. There are less records in one than another, so I've been trying to figure out the right way to do this. Essentially pretend Table.Varchar has in it: apple, orange and Table.Float has in it: 1 2 3. How could I write a query which returns apple1, apple2, apple3, orange 1, orange2, orange3? Long day at work and I think I'm just overthinking this what I've tried so far is to concat the two fields and then count but it's not working. Any ideas to better go about this?