Thanks Wayne;

I think the minor tweak Lynn suggested is better; the change you made gives some inaccurate/unexpected results, even though the code runs without error:

i think it's because i was...

BOL says ALTER LOGIN can be used to rename a login, the example is for a SQL login though:

--Changing the name of a login

--The following example changes the name...

yep that did it; I'm looking at it now, not sure why there's a difference.

yeah Lynn, i had done basically the same thing...when i use a function, the function works, and i get the delimited results as expected, but when i try to do...

he's just gone from the company, not dead. We had almost the same thing happen, guy left and noone knew what to do.

There's always the thought that someone leaves you...

i just create a view of a trace,a nd then scripted the view to be a table;

CREATE VIEW sp_DMLTrace

AS

SELECT * FROM ::fn_trace_gettable('c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\MyDMLtrace2.trc', default)

here's it's definition;...

To continue with Sarab's points, two issues I always check for:

update statistics on production; this can make a big difference.

does your procedure have "default" values for any of it's parameters?...

skumar.klm (3/2/2010)

---

I want to select top 10 records from a table,this time another user select top 10 records.

my question is how to avoid first top 10 in second selection.

this 2...

Roust i'm still trying to get a working example going, it's early and pre-cafienne for me.

perforance like this will be slow because you are using a scalar function 15K times;...

if column 1 was was an identity(), or column 4 is a calculated column, your original statement would have worked with no errors...maybe you left something out? identities and calculated...

ZeeAtl you need to find the traceid by select * from sys.traces

then:

...

i used Lynns approach and stuck the results in a temp table;

no -4 offsets at all when i did that:

--create the tmp table

select getdate() As dt, getutcdate() as utcdt, datediff(hh,...

Al I'm seeing the same thing; i even changed it so that the calculation was in the loop, instead of as a function; i still got -4 offsets sometimes, but...

Ryan i think you'll want to left join the whole sub query and use a calculated column to return whether there was a complaint or not; i did not see...

i think that by using the REPLACE function for every space, and then adding one to it, you can get thecount of the words, because they are seperated by spaces;

example:

select...