Reputation
5,436
Next tag badge:
119/100 score
18/20 answers
Badges
2 20 50
Newest
 Nice Answer
Impact
~329k people reached

Aug
17
awarded  Nice Answer
Aug
11
awarded  Convention
Aug
10
revised Split after comma into separate row
added 56 characters in body
Aug
3
awarded  Constituent
Jul
27
awarded  Caucus
Jul
7
comment How to do a SELECT inside of a PIVOT
You can't, you have to use dynamic SQL. PIVOT requires that the columns be known when the command is executed. See this question - dba.stackexchange.com/questions/31760/…
Jun
18
revised Compare 4 or more columns values
added 8 characters in body
May
28
comment Parameter Sniffing Question
Can you cut the code down to something that could be posted? Otherwise we'd be guessing.
May
25
awarded  Yearling
May
25
awarded  Nice Answer
May
23
comment Grouping based on the status, then count its product and the total based on its category ID
What's the logic to assign published and unpublished?
May
21
answered Left Outer Join doesn't give expected result. What am I missing?
May
13
comment Selecting the correct row given multiple input value combinations
I don't see how item = pen, color = blue and type = gel gets you 006, is there a typo or what is the logic that you are using? Also where is the color = orange to get a result of 004? Do you want the row that returns the most items matched?
May
11
comment Mysql Query for Multiple table
Do you know how many question/answer combinations you are going to have?
May
11
revised Mysql Query for Multiple table
added 116 characters in body
May
8
awarded  Enlightened
May
8
awarded  Nice Answer
May
7
revised Help with PIVOT query
fixed typo
May
7
answered Help with PIVOT query
Apr
17
answered Can't seem to understand why STUFF isn't working