if you even suspect someone is making changes without permissions, you should simply change the password(s) (probably for sa..developers connecting on production as sa a possiblity?)

then create a new role,...

i'm not sure why it jumps to scientific notation...wierd.

this works, it's simply a double cast/do the same with convert:

DECLARE @fl AS FLOAT

SET @fl = 789512385

SELECT cast(CAST(@fl AS bigint) AS varchar(50))

i'd go with Michaels suggestion. don't display the date at all. either print something like 'xx/xx/xxxx', or don't display it. munging it into the number of seconds, or turning it...

take look at this link;

http://www.sqlteam.com/article/using-bulk-insert-to-load-a-text-file

basically, they are using dblquote-comma-dblquote as the field delimiter, and dblquote-slash-n as the row terminator.

that just leaves removing the preceeding dbl-quote for cleanup.

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...