4,895 reputation
21546
bio website onlybluefeet.com
location Arizona
age 39
visits member for 2 years, 10 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


Mar
25
comment Efficient way to transpose large categorical column to one-hot table row
@AaronBertrand They are gonna keep scrolling, scrolling, scrolling
Mar
24
comment Help on the pivot query
At this point, we'd be guessing on what the problem is so I'm voting to close this as unclear. I'd suggest editing your question to include the table structures, sample data and the final desired result.
Mar
24
revised Help on the pivot query
added 98 characters in body
Mar
24
comment Help on the pivot query
It looks like you've got a combination of dynamic sql and static sql hear, what's the exact code that you are executing and why isn't it working?
Mar
24
revised Help on the pivot query
added 68 characters in body
Mar
24
revised Help on the pivot query
added 68 characters in body
Mar
19
comment Purging Data that has Foreign Keys
If you need to delete massive amounts of data, then you always delete in batches to not overload/lock tables, etc. We have several processes that delete millions of rows a night in 10k-100k row batches. Reference 1, reference 2, reference 3
Mar
19
revised placing conditions in a join query join on vs where
added 68 characters in body
Mar
18
comment Distinct rows by order
Any number of ways could be used to return distinct rows but we'd be guessing. What columns have data that is duplicated? You'll have to break the query down and add each table individually and try to work past the duplicated data.
Mar
10
comment Unknown column in a table
@user61052 That's a different question, ask a new one - dba.stackexchange.com/questions/ask
Mar
10
comment Unknown column in a table
@user61052 You'd add the 3 table using another INNER JOIN and you would join ON the column the tables share - see my edit.
Mar
10
revised Unknown column in a table
added 217 characters in body
Mar
10
comment Unknown column in a table
@user61052 Those are aliases for each table. You don't need to use them, but it saves keystrokes by not having to fully type each table name.
Mar
10
revised Unknown column in a table
added 4 characters in body
Mar
10
answered Unknown column in a table
Mar
10
revised Unknown column in a table
added 273 characters in body; edited title
Mar
4
revised Trying to add a NULLable column to a table with over 90 million rows takes a very long time
deleted 19 characters in body; edited tags
Feb
26
awarded  Popular Question
Feb
25
revised How can we select data from another table during an insert?
added 381 characters in body
Feb
24
awarded  Popular Question