meta user
network profile
| bio | website | lobsterpot.com.au |
|---|---|---|
| location | Adelaide, Australia | |
| age | 38 | |
| visits | member for | 1 year, 6 months |
| seen | May 8 at 13:48 | |
| stats | profile views | 84 |
Owner / Principal at LobsterPot Solutions
Adelaide (Australia) based SQL MVP
On twitter @rob_farley
Blog at http://sqlblog.com/blogs/rob_farley
(Old blog at http://msmvps.com/blogs/robfarley)
|
Jan 23 |
answered | does a subquery pull the entire table? |
|
Jan 2 |
answered | Count consecutive rows in mysql |
|
Jan 2 |
comment |
Why would a SELECT INTO cause an arithmetic overflow? Oh, and go vote for connect.microsoft.com/SQLServer/feedback/details/774754 to make this kind of debugging much easier. |
|
Jan 2 |
answered | Why would a SELECT INTO cause an arithmetic overflow? |
|
Nov 22 |
answered | Simulating having multiple Control Flows in a SSIS package |
|
Oct 26 |
awarded | Yearling |
|
Oct 15 |
answered | debugging an ssis package which is invoked from a .net application? |
|
Oct 13 |
comment |
Order questions depending on answer votes But you can omit them from the SELECT clause to avoid that particular error. My point is that even if you're not outputting the QuestionID, it's still worth grouping by it. |
|
Oct 13 |
comment |
Order questions depending on answer votes So - use the appropriate formula. I wasn't sure whether you wanted the total score, or the total number of votes regardless of whether they were positive or negative. You may want the minus to be plus in the first line. |
|
Oct 13 |
answered | Order questions depending on answer votes |
|
Sep 29 |
answered | SELECT permission on view querying table from another database |
|
Sep 27 |
awarded | Cleanup |
|
Sep 27 |
revised |
Are these two queries technically equal to each other? rolled back to a previous revision |
|
Sep 27 |
comment |
Are these two queries technically equal to each other? Logically equivalent, yes. But they'll produce different plans, as per my bit.ly/LJvNE post. |
|
Sep 27 |
comment |
Are these two queries technically equal to each other? So... my answer was based on the assumption that your first query was supposed to be the one that ypercube answered with. |
|
Sep 27 |
revised |
Are these two queries technically equal to each other? deleted 124 characters in body |
|
Sep 27 |
answered | Are these two queries technically equal to each other? |
|
Sep 27 |
comment |
Are these two queries technically equal to each other? You mean apart from the obvious thing that there's no filter on dateOfConfirmation or isConfirmed in the first query? |
|
Sep 27 |
answered | SELECT Statements only please |
|
Sep 26 |
answered | The best way to log access to SSRS reports |
