4,704 reputation
21444
bio website onlybluefeet.com
location Arizona
age 39
visits member for 2 years, 6 months
seen 6 hours ago

developer, techie, nerd.....

I like questions...

My feet are blue from running or I am part smurf. I haven't figured it out yet.

contact:

@onlybluefeet


Nov
21
revised Convert a list into one row with dynamic column in MySQL
edited tags
Nov
19
reviewed Close Ideal DBMS Solution for domain problem
Nov
17
awarded  Famous Question
Nov
13
awarded  sql-server
Nov
12
awarded  Nice Answer
Nov
5
revised about latest row in sql server
edited tags
Nov
4
revised How to sort rows to appear alternatively (e.g. A B A B … )?
edited tags
Oct
27
comment SSRS pivot dynamic columns
@jhowe Based on your edit I'm guessing you are including too many columns in your query, but since your image doesn't match the sample data I'm not sure.
Oct
27
comment SSRS pivot dynamic columns
@jhowe It seems like you could just use this demo -- sqlfiddle.com/#!3/8a382/3
Oct
27
comment SSRS pivot dynamic columns
@jhowe Can you edit your post to include the desired result? It's not exactly clear what you want for the final product.
Oct
7
revised Using count() and sum() in a calculation in a select
added 51 characters in body
Oct
7
comment joins with “could be blank” conditions
I'd suggest creating a sql fiddle with your tables, sample data and then post the desired final result.
Oct
7
comment joins with “could be blank” conditions
Why not use a LEFT JOIN on the location_flag table?
Oct
7
revised joins with “could be blank” conditions
added 62 characters in body
Sep
30
awarded  Explainer
Sep
30
revised How to create a view joining 2 tables?
corrected aggregate version to return the proper sum
Sep
30
revised How to create a view joining 2 tables?
added 103 characters in body
Sep
30
answered How to create a view joining 2 tables?
Sep
30
revised How to create a view joining 2 tables?
added 795 characters in body; edited title
Sep
29
comment MYSQL Tables Join Filtering For Favorites
Your Q1+Q2+Q3+Q4+Q5+Q6+Q7+ screams there is a design flaw with your table.