Please post a script that creates a table, temp table or table variable with insert statement(s) of sample data, what you've tried and desired output.