Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
6
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Jan
8
awarded  Popular Question
Jan
8
comment Tuning query to remove joins for reporting
Because the original query was very poorly formatted, and I simplified the query to what was really needed.
Jan
8
revised Tuning query to remove joins for reporting
Edited bottom query and fixed typos
Jan
8
comment Tuning query to remove joins for reporting
They are both left outer joins, that was my bad.
Jan
8
comment Tuning query to remove joins for reporting
haha sorry, jon, I was typing it while looking at a different inner join on another screen.
Jan
8
revised Tuning query to remove joins for reporting
edited body
Jan
8
asked Tuning query to remove joins for reporting
Oct
4
answered SQL Server DB restore fails
Oct
4
comment Visio 2010 and SQL 2012 - Reverse Enginnering
Here is another post with a similar question. Since SQL Server 2012 came out after Visio 2010 it is not supported, even though it uses the Native Client.
Oct
3
comment How to store formula method in the table
so are you going to have a list of a handful of formulas that can be chosen from? Like (a + b + c) for HDD, (a + b) for HDD, (a+b+c/200) for HDD etc, or did you want it highly editable like enter formula for HDD here: ?
Oct
3
comment How to store formula method in the table
Are you trying to say you want a table of formulas that you use eval() in php with? I would just perform a join with formula table then perform a eval. Are you looking for something similar to this post?
Oct
3
awarded  Editor
Oct
3
revised How to store formula method in the table
fixed formula
Oct
3
awarded  Teacher
Oct
3
answered How to store formula method in the table
Oct
2
awarded  Scholar
Oct
2
accepted Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Oct
2
comment Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Max, thanks for helping me so much!
Oct
2
asked Does SQL Server Snapshot replication completely copy the data every time or does it issue deltas?
Oct
1
awarded  Supporter