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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
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]
...
_____________
Code for TallyGenerator
May 8, 2011 at 8:28 pm
"= @[PKey]" - is it the actual syntax?
_____________
Code for TallyGenerator
May 3, 2011 at 7:10 pm
Use NULLIF function:
SELECT DISTINCT ISNULL(NULLIF(1stID, ''), NULLIF(2ndID, '')) theID
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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.
_____________
Code for TallyGenerator
March 24, 2011 at 10:10 pm
What are you trying to set with the last statement?
_____________
Code for TallyGenerator
December 21, 2010 at 4:30 am
Hi Jeff,
Will have look at your samples.
As soon as I've got my computer back from the workshop.
🙂
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
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...
_____________
Code for TallyGenerator
November 29, 2010 at 2:12 pm
Viewing 15 posts - 2,311 through 2,325 (of 6,036 total)