3,911 reputation
11136
bio website onlybluefeet.com
location Arizona
age 38
visits member for 1 year, 11 months
seen 1 hour 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


2d
comment sql statement in access that group items and count their sum
How are you determining the ID for the final result? Those values don't seem to match the sample data.
2d
revised sql statement in access that group items and count their sum
edited tags
Apr
4
revised Import 10 Billion Rows, Daily
edited tags
Apr
3
comment MySQL Rows to Columns to HBase (using Sqoop)
Returning 4030 columns of data is not something you should be doing in a SQL statement.
Apr
2
reviewed Close mysql inner join if value = true ( share system )
Apr
2
reviewed Close Data History Table vs Using a Current Record Flag
Mar
21
awarded  Civic Duty
Mar
6
revised Can IS DISTINCT FROM be combined with ANY or ALL somehow?
edited title
Mar
6
comment SQL Server 2008 single-line PIVOT/UNPIVOT combo
You stated that you were able to get the result into columns but it has null, can you edit your question and post your attempts at getting the result?
Feb
24
revised SQL Select query with postgresql
deleted 210 characters in body; edited tags; edited title
Feb
14
revised What is the performance difference between IN (42) and id = 42 in MySQL?
added 27 characters in body; edited title
Feb
13
comment SUM a new value to an existing value
You can post it as your own answer, you had already solved the problem when you asked the question. Then you can accept it as well.
Feb
13
comment SUM a new value to an existing value
If you want to add the new value to everything in your table, then your query would be correct. If you want to update only specific rows, then you need a WHERE clause.
Feb
13
revised SUM a new value to an existing value
added 8 characters in body
Feb
11
comment Case when missing line logic
This has been cross-posted on Stack Overflow stackoverflow.com/questions/21703156/… If you feel that DBA.SE is a better fit for this question then you should flag it for mod attention asking that they move it to an appropriate site.
Feb
6
comment sql server service broker queue pass parameter to stored procedure
Please don't cross-post questions - this was also posted on Stack Overflow -stackoverflow.com/questions/21601982/…. If you feel that this is a better fit for DBA.SE, then flag your question for the moderators to move it or delete it from Stack Overflow before posting it on another site.
Jan
31
answered Using inner join on a specific record?
Jan
31
revised Using inner join on a specific record?
added 33 characters in body
Jan
27
revised Slow insert - 300+ Million Records
added 2095 characters in body
Jan
23
awarded  Deputy