4,799 reputation
21444
bio website onlybluefeet.com
location Arizona
age 39
visits member for 2 years, 7 months
seen 14 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


Dec
9
comment Convert date and time
What is the data type of the column? If it is a datetime, then you will want to return the data in that format, not store it in a specific format. Also what database are you using?
Dec
5
revised Select rows with same id but null and some other value in another column for that id
added 550 characters in body
Dec
5
comment Select rows with same id but null and some other value in another column for that id
@ITresearcher That is a simple fix - you need to change the HAVING clause to be >=1 - sqlfiddle.com/#!3/8af72/2
Dec
4
revised Select rows with same id but null and some other value in another column for that id
added 181 characters in body
Dec
4
answered Select rows with same id but null and some other value in another column for that id
Dec
2
reviewed Close MySQL created_by or updated_last-by
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