Reputation
5,270
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
2 18 48
Newest
 Yearling
Impact
~262k people reached

1m
comment Get .csv file from ftp server and save it to a local location with batch
I take it back it looks like you already asked this on SO. When posting questions pick one site where the question is on-topic and make it a quality question.
3m
comment Get .csv file from ftp server and save it to a local location with batch
This is not really on-topic for DBA. You might be able to get some help on Stack Overflow but please read how to ask before asking there. Right now, this is far too broad of a question.
3h
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
Apr
17
comment Can't seem to understand why STUFF isn't working
Depending on your actual query you could shorten your code to - sqlfiddle.com/#!6/f25dc/4
Apr
17
comment Can't seem to understand why STUFF isn't working
You need a WHERE clause in your STUFF - sqlfiddle.com/#!6/f25dc/2 to tie the outer data to the list.
Apr
10
comment SELECT rows with duplicate values
I'd include in your question you attempts. Right now, this is written as a do my work for me type of question.
Apr
10
comment SELECT rows with duplicate values
Did you try anything to get this result?
Apr
2
awarded  Notable Question