Viewing 15 posts - 4,231 through 4,245 (of 4,820 total)
The only problem I can foresee here is that what you describe so well as business rules definitely does not correspond to the real world, as landlords often have multiple...
July 24, 2009 at 1:55 pm
I don't suppose encapsulation into a transaction would help, would it?
Steve
(aka smunson)
:-):-):-)
July 24, 2009 at 12:12 pm
Yup, I just realized I had messed up because what I posted left out the other foreign key needed, and I had it in my code, but somewhere in the...
July 24, 2009 at 12:03 pm
See the changes to your code: All I did was add the table alias, as otherwise there would be two possible fields that SQL Server would have to...
July 24, 2009 at 7:26 am
As long as you substitute actual date text for the @Date you have between the quote signs, you'll be ok. @Date would NOT be interpreted as a declared...
July 23, 2009 at 6:27 pm
Scott,
You're quite right. I didn't have SSMS open and was in a bit of a time crunch and thought I had it straight, but now that I've had...
July 23, 2009 at 6:21 pm
Oops again! Here's the updated code. If you want to see a count for each record, we have to add 1 to the count in the...
July 23, 2009 at 2:34 pm
Had an oops in the code, updated mm to mi in the DATEDIFF function.
Steve
(aka smunson)
:-D:-D:-D
July 23, 2009 at 2:31 pm
Ok, let's try this on for size. It includes sample data. Not sure if this works 100%, so you'll need a lot more data to test...
July 23, 2009 at 2:25 pm
Ok, now I see what you're saying. City is at the top of the heirarchy, with Area being the next level. The user has a relationship...
July 23, 2009 at 2:02 pm
Thanks Jeff... I was wondering if I had just missed something that everyone else was assuming. And to add oil and water to the fire, if you...
July 23, 2009 at 1:30 pm
Ok, maybe someone can make sense of this for me, but what kind of a heirachy are we dealing with here? If an Area can only have 1...
July 23, 2009 at 11:22 am
Well, this sure is an interesting debacle... Is the record data just inserted sufficiently unique that the data's ID field could be selected in a query because you...
July 23, 2009 at 10:55 am
When you eliminate the impossible, whatever remains, however improbable, must be true. I suspect that your left outer join is becoming an INNER JOIN by virtue of a...
July 23, 2009 at 10:38 am
There's a logic problem here... For the data shown here:
Emp_ID Start_Entry End_Entry ...
July 23, 2009 at 10:23 am
Viewing 15 posts - 4,231 through 4,245 (of 4,820 total)