Forum: MS SQL Mar 17th, 2009 |
| Replies: 2 Views: 528 select top 3 *
from tableName
order by col3 desc |
Forum: MS SQL Mar 11th, 2009 |
| Replies: 4 Views: 1,677 i'm not quite sure what you are trying to do here, but there are 2 things
first you are referencing R3 outside of its scope, second you have a where instead of an and, here is my shot at what i... |
Forum: MS SQL Mar 10th, 2009 |
| Replies: 6 Views: 901 Ok, just wanted to make sure we aren't chasing a ghost
Rather than just adding the parameters with a name and value, try to add them with a name and type
SqlParameter param1 = new... |
Forum: MS SQL Nov 28th, 2008 |
| Replies: 2 Views: 603 |
Forum: MS SQL Oct 17th, 2008 |
| Replies: 6 Views: 1,391 The issue is because you are placing the constraints on the same table
Think of it this way, if you remove a trip in the middle of the sequence, it will cause all other trips that are fk'd from it... |