a procedure cannot take a table variable in as a parameter, so you'll need to tweak the logic and have the procedure CALL the function from within the code instead;...

can you change the comparison to a money or decimal type ?

SELECT CONVERT(MONEY,-648365.80999999424)AS P1,

CONVERT(MONEY,-648365.81000000483) AS P2

SELECT CONVERT(DECIMAL(10,4),-648365.80999999424)AS P1,

CONVERT(DECIMAL(10,4),-648365.81000000483) AS P2

P1 ...

Christian now THAT was sweet idea; i forgot about the object_defintion function in 2005; only thing i did for testing was to add a WHERE statment to make sure i...

here's something that colin wrote to search the text of all objects.

because a procedure is compiled, changing the text of a proc would have no effect...you must alter the procedure...

don't know about others, but i use EditPlus for my text/sql editor. it has syntax highlighting,a nd has the ability to keep an unlimited number of scripts and snippets at...

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.