Viewing 15 posts - 571 through 585 (of 616 total)
I'm not entirely sure what you are asking, however in general if you are doing performance tuning like that you can take the Profiler results and store them into a...
October 24, 2007 at 8:57 am
Pseudo code Jeff, Pseudo code.
October 24, 2007 at 8:50 am
Ok, maybe its because I have no idea what a golf leaderboard is supposed to look like but I thought it was DENSE_RANK.
IE an answer might be
Joe 277 1
John 277...
October 23, 2007 at 7:44 am
To the best of my knowledge that really is the best way to do it. If the columns are indexed that should go fairly quickly though.
Kenneth Fisher
October 22, 2007 at 3:22 pm
If you are pulling a file from excel it could have been loaded into it orriginally. Also the small squares arn't always carrage returns.
There are some functions out...
October 12, 2007 at 10:19 am
Ok .. just to see try
select * from upload where LTRIM(RTRIM(people_code_id)) ='P000008270'
Also confirm that the string 'P000008270' is correct in this particular query. You may be dealing...
October 12, 2007 at 9:15 am
Its possible you have some weird ascii character that may be invisible but still there. Its an unusual thing to have happen but it does happen. Try running...
October 12, 2007 at 9:02 am
Because you have to have some kind of condition to test on. If you did a NOT EXISTS (SELECT * FROM TABLE1) with no condition then the where clause...
October 11, 2007 at 3:32 pm
select distinct p.first_name
,p.last_name
,p.people_code_id
from people as p
inner join peopletype as pt
on p.people_code_id=pt.people_code_id
where p.deceased_flag='n'
and pt.people_type='alum'
AND NOT EXISTS (SELECT * FROM Upload WHERE Upload.First_Name = p.First_Name
AND Upload.Last_Name = p.Last_Name
AND Upload.People_Code_Id = p.People_Code_Id...
October 11, 2007 at 3:17 pm
Once you have the excel data into a table do something like this :
INSERT INTO ExcelTable
SELECT Field1, Field2, ...
FROM DBTable
WHERE KeyInfo NOT IN (SELECT KeyInfo FROM ExcelTable)
At least that...
October 11, 2007 at 2:59 pm
I'm not sure if this is the best approach or not but I would use a DTS package. Load the excel file into a temporary table. Update it...
October 11, 2007 at 2:50 pm
If it makes you feel any better debugging sp_executesql can be a royal pain.
Here is a quicky sample
declare @tablename nvarchar(50)
declare @sql nvarchar(1000)
SET @tablename = 'sysobjects'
set @sql...
October 11, 2007 at 2:44 pm
Unfortunatly in SQL 2000 you can not convert from text directly. What enterprise manager is doing behind the sceens is creating a temp table, loading it with the data...
October 11, 2007 at 2:24 pm
I would try changing the count(*) to a count(1). It is marganally faster. Also do you have any where conditions, groupings etc on the count? If so...
October 11, 2007 at 1:06 pm
If the process you killed is a long running command .. say a large insert .. then when it is killed it does a rollback. If you do another...
October 10, 2007 at 11:58 am
Viewing 15 posts - 571 through 585 (of 616 total)