Declare @search as varchar(25)

set @search = 'id'

Select name from dbo.SysColumns where name like '%' + @search + '%'

order by case when name like @search + '%' THEN 0 ELSE 1...

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...

HTH.

Sorry for the late reply. What you are looking for is : Application.CurrentProject.Path

Here's the final query if anyone is interested :

SELECT TOP 100 PERCENT dtRanks.Name, dtRanks.Rank - dtTieBreaker.number + 1 AS NewRank

FROM ...

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...

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...

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...

It was your idea first... can't take the full credit.

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...

Do you have an exemple of such a tie breaker?.. can't think of one right off.

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...

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...

Select dateadd(M, datediff(M, 0, getdate()), 0)

I just don't see it... What about the query analyser results?