Jeff Moden (10/15/2007)

---

Heh... too bad I don't have SQL Server 2k5, yet... would be an interesting test 'cause, you're right, Regex is very fast.

The fastest option, though, would be to...

which RID? if you group on R_ID AND FilterDesc, you get the whole table...

SELECT SUM(RowsCount)AS SUMROWCOUNT ,FilterDesc

FROM @SAMPLE

GROUP BY FilterDesc

maybe you mean you want the r_ID ANd the totals?

select S.R_ID,X.SUMROWCOUNT...

here's how i would do it:

--sample data for testing:

DECLARE @SAMPLE TABLE(R_id int, ProductCode varchar(4), FilterDesc varchar(50), RowsCount int, FilterCount int)

INSERT INTO @SAMPLE

SELECT 99 ,'APUS','After all non HK removed', 6, 0...

it looks to me like you are inserting

data into t_SRateTable, but doing it in a RBAR(Row-By-Agonizing-Row Basis) (--Jeff Moden 2005-2007)

It seems like you could just insert the whole batch.

the...

Am i reading the question correctly? you are trying to find out if an object has changed owners? or are you trying to audit WHETHER a login has issued the...

well first thing i would do is at the top of the procedure, Id issue this command:

SET ROWCOUNT 10000

that way, no matter what filters/conditions were passed or not, i return...

I agree with colin; a master procedure to handle things in batches is a great idea....I'd question whether a user interface really needs to look at a million records, or...

i would lean towards the data not being in the expected format....maybe it's a unix based file, and contains only \r for the rowterminator and not , which is Carriage...

take a look in the scripts section:

http://www.sqlservercentral.com/scripts/Index+Management/30139/

the above is a script to reindex all tables.

it's all there:

n:Login failed for user 'sa'.

you must have mis typed the password. reenter it, and if permissible, run it right now on demand, instead to confirm it runs.

you had almost everything you need...you simply want to sub select:

SELECT * FROM CustomerRecords

WHERE SSN IN (SELECT SSN

FROM CustomerRecords

GROUP BY SSN

HAVING (COUNT(SSN) > 1)

) X

ORDER BY SSN

it's not blindingly obvious, but in QA when you do a SELECT INTO statement, to dynamically make a new row, the table that gets created from the data is created...

sure you can, you just have to raise the error yourself:

begin

[logic for determining if an issue appears here]

declare @err varchar(400)

set @err='Transaction (Process ID ' + convert(varchar,@@spid) + ') was deadlocked...

Ironically, the error given is the answer.

error numbers belwo 50,000 are reserved, and can only be raised by the SQL Server engine. you can read the list of error...

when run in QA or anything like that, yes only column names appear...the rest is hidden.

when placed in a client side data table or ADODB.Recordset. the attributes like data type,...