Viewing 15 posts - 2,311 through 2,325 (of 6,036 total)
Lowell (5/11/2011)
it ooks like the desired sorting is "strip non numeric chars and order by the numeric portion(if it exists) then by the string"
Your assumption is onviously wrong.
Look at this...
May 11, 2011 at 6:28 pm
seshukumar.thokala (5/11/2011)
Actually my table consist of different data like as i mentioned above it have int,float,char so i would like to sort that data is there...
May 11, 2011 at 6:24 pm
Please describe the rule of sorting.
We really have little of idea what we have to implement here.
May 11, 2011 at 4:17 am
lindsay,
use you original query to create a view on the remote server (of course, if you can do it):
CREATE VIEW RemoteReport
AS
SELECT TOP 1 [EmployeeKey],[ParentEmployeeKey],[EmployeeNationalIDAlternateKey],[ParentEmployeeNationalIDAlternateKey]
,[SalesTerritoryKey],[FirstName],[LastName],[MiddleName],[NameStyle],[Title],[HireDate],[BirthDate],[LoginID]
...
May 8, 2011 at 8:28 pm
"= @[PKey]" - is it the actual syntax?
May 3, 2011 at 7:10 pm
Use NULLIF function:
SELECT DISTINCT ISNULL(NULLIF(1stID, ''), NULLIF(2ndID, '')) theID
May 3, 2011 at 6:42 pm
You may parse the string into a table and search for values in there.
Search this site for "split function" and choose the one you like the most.
You may put the...
April 26, 2011 at 4:28 pm
Delete From TableB
where exists (select * from TableA
where TableA.LinkedID=TableB.LinkedID )
Repeat this for tables B and C, and then run
Delete from TableA
If you need to delete...
April 25, 2011 at 10:03 pm
ananda.murugesan (4/21/2011)
In SQL SERVER 2000.
Blocked process not clear after restarting SQL SERVICES, please tell me what could be reason? once restart the service all transaction will be terminated...
April 25, 2011 at 7:36 pm
Phineas Gage (4/18/2011)
There are 3 non-clustered indexes on that table, 2 of which use the date column.
First ,you most likely don't need 2 indexes on the same column.
Second, if a...
April 18, 2011 at 3:14 pm
Create a small mapping table for ([function], pool), place all your cases into that table, join it to your query and just GROUP BY pool.
March 24, 2011 at 10:10 pm
Hi Jeff,
Will have look at your samples.
As soon as I've got my computer back from the workshop.
🙂
December 2, 2010 at 5:19 pm
Something like this:
SELECT TOP 10 * FROM Table
WHERE Name < @Name
ORDER BY Name DESC
UNION ALL
SELECT TOP 10 * FROM Table
WHERE Name > @Name
ORDER BY Name
You need a little...
December 2, 2010 at 5:00 pm
Hi Jeff,
No argument about adjusting indexes to queries - it really works.
Don't have time to analize the data patterns, but from the first glance - "A different way to use...
November 29, 2010 at 2:12 pm
Viewing 15 posts - 2,311 through 2,325 (of 6,036 total)