Viewing 15 posts - 17,611 through 17,625 (of 18,926 total)
Select A.CompanyID, A.ItemDescription, A.ItemReferenceNumber, A.ItemQty from dbo.YourTable inner join dbo.Numbers N on A.ItemQty <= N.PkNumber
--I use this table for many other string operations as well
CREATE TABLE [Numbers] (
[PkNumber] [int] IDENTITY...
May 26, 2005 at 1:06 pm
Sorry for the late reply. What you are looking for is : Application.CurrentProject.Path
May 26, 2005 at 12:25 pm
Here's the final query if anyone is interested :
SELECT TOP 100 PERCENT dtRanks.Name, dtRanks.Rank - dtTieBreaker.number + 1 AS NewRank
FROM ...
May 26, 2005 at 12:08 pm
Well you could always resplit the string but that would seem to be a lot of work for absolutely nothing. I think that the small task of copying the...
May 26, 2005 at 11:42 am
The only scenario I imagine is like so :
You would have a user start editing a record then goes home (the changes are not saved to the server untill...
May 26, 2005 at 11:30 am
I'm not sure I understand your tie breaker.
Can you write a tie breaker for this query (without using the colid column
)?
Select C.Name, (Select...
May 26, 2005 at 10:16 am
It was your idea first... can't take the full credit.
May 26, 2005 at 10:03 am
functions like year() and month() forces index scans or worst, clustered index scan. My method allows for a seek. You can't imagine the performance gain on a huge...
May 26, 2005 at 10:01 am
Do you have an exemple of such a tie breaker?.. can't think of one right off.
May 26, 2005 at 9:58 am
Just a final comment... Even if the number of items change : the query doesn't change and the client code doesn't change (if done right).
It works, has 0 maintenance...
May 26, 2005 at 9:56 am
Just curious... does it still work if you have the same item ordered twice with the same quantity (let's say for 2 different adress)?
Won't the ranking return a tie in...
May 26, 2005 at 9:52 am
I just don't see it... What about the query analyser results?
May 26, 2005 at 9:38 am
Viewing 15 posts - 17,611 through 17,625 (of 18,926 total)