To find a proper solution you need to consider how you data set is represented. If the data has a specific order based on unique values Greg's method will work...

You may need to run profiler to get a better idea of the actgivity going on before, during and after the error shows up. You may have something you forgot...

I have had no issues. But there have been threads here related to issues others have encountered with SP2. Specifically what issue are you having and have you searched the...

If the data table has an identity field or a unique field that is a clustered index order the order you want to use then this type of syntax may...

With a nonstatic IP you may have better results going either way if you create a change notation table and place a trigger on the main table.

For exxample.

I have an...

quote:

---

Is there a way to trace the deleted rows ??

---

As far as knowing what rows...

Jorge's solution is great and should meet most situations. But as an alternative to use in case of performance you could create a temp table like so.

CREATE TABLE #tmp (

[idx]...

To save headache with your code there is no need to change the replace function just double the ' quotes you already have in your select statement. It will look...

See if this helps

CREATE FUNCTION GetSupervisor

(@id int)

RETURNS @groups TABLE (id int, parentid int, position varchar(20))

AS

begin

--declare @parentid int

-- Get the employee supervisor ID

select @id = parentid from employeelist where id...

Most of what I do is transferable by defining connection as local for SQL connections to local box and just save to other servers. In some cases I do have...

Invalid Pointer can mean several things. Is there any more information in the message. However have you tried testing by hand, recreating the process and testing by hand, and verifying...

If Dr. Watson did a dump you may be able to glen some info off it. However double check your rights, have ou installed anything recently (patches included), try another...

Like Andy said you just add COUNT(*) to get counts for each grouping.

SELECT source_order_prefix, source_order_number, style_description count(*) as ttl_grp_cnt FROM sum_orders

WHERE source_order_prefix LIKE '%K%' AND source_order_number LIKE '%9735%'

GROUP BY source_order_prefix,...

So you got your day. Glad problem was found. Exactly what was it in case someone else runs into? (Especially me)

"Don't roll your eyes at me. I will tape them...

And it depends on the type of Performance Tuning you tried. Is this index tuning with Profiler traces, query tuning using execution plans as ground work, what is it specifically...