390 reputation
313
bio website twitter.com/AakashMehendale
location London, United Kingdom
age
visits member for 2 years, 9 months
seen 16 hours ago

1d
answered Finding the end of a Relationship chain optimally
1d
comment Efficient way to transpose large categorical column to one-hot table row
So you want to end up with a resultset with ~8000 columns?
1d
comment Why is my Make Table query pasting 0 rows?
The query is coming up with 0 results because, given your data, the join conditions you've specified mean there are no matching rows. It's not going to be easy for us to say whether the problem is with your data or your query. Maybe do a SELECT on just the inner of your two JOINs, and see if that returns the data you expect; then manually examine a SELECT on Doc4.
Mar
3
revised What is causing an INTERSECT to run forever when the individual SELECTs run quickly?
expand title
Mar
3
suggested approved edit on What is causing an INTERSECT to run forever when the individual SELECTs run quickly?
Feb
20
suggested rejected edit on SQL Server's aggregate functions ignore nulls. How do I correct this?
Feb
17
comment Rank function creating duplicate partitions? (two rank 1's for the same key)
Or, if you're happy for SQL Server to completely arbitrarily pick a winner from two identical rows, use ROW_NUMBER rather than RANK.
Nov
28
comment how to compare time slots?
Are all your times always exact minutes?
Nov
28
comment Why is casting a string to DATETIME not accurate to the ms?
@DamienGolding what would you expect SELECT CAST('3.6666666666666666' AS float) to return?
Nov
21
revised Is there any way to use “like” operator during oracle table partitioning
tags, tidy up
Nov
21
revised How can I check for stored procedure consistency across multiples servers
english .
Nov
21
suggested approved edit on How can I check for stored procedure consistency across multiples servers
Nov
21
suggested approved edit on Is there any way to use “like” operator during oracle table partitioning
Nov
13
comment Restoring a SQL Server 2012 database in high availability
Who "advised" you, and why don't you believe them? (note that I'm not saying whether what they said is right or wrong; I don't know)
Nov
12
answered Trigger firing when it shouldn't
Nov
6
comment Migration script fires 'The data definition language (DDL) command cannot be executed at the Subscriber'
Presumably, yesterday when it worked, you weren't executing the exact same script on the exact same server (since you wouldn't want to add the same column twice). What's changed since then?
Nov
4
comment Grouping data by MONTH on DATETIME column in SQL Server
Given the date of asking, I'd say there's a third and most likely possibility: that we seek the count of users who joined in October 2014.
Sep
24
revised XML Whitespaces/Unwanted Characters
formatting, tags
Sep
24
suggested approved edit on XML Whitespaces/Unwanted Characters
Sep
18
revised Is it possible that records are changed while a read query is still executing?
tag with mysql