Sergiy you've got a lot of experience; if you were starting from scratch, how would you handle an email notification requirement?

I'm sure I have developer tunnel vision with an email...

also to follow up on this part of your question:

Say I enter a record on 10/15. On 10/21 at at 12:00 am what happens to the table so that my...

well, here's what i would suggest; instead of tracking 5/10/20 day, lets keep the emailID of the email you sent because somethign was 5 days old.

[font="Courier New"]

CREATE TABLE tblTest

(

ID INT...

i disagree that a trigger is needed; part of the scheduled job should be doing a query like this:

select * from tbltest where...

the convert() function has some special formats when converting date time...the format 112 is what you are looking for:

declare @cmd varchar(255)

SELECT CONVERT(VARCHAR,getdate(),112) + '.txt'

SELECT @cmd='osql -E -S Servername -i d:\query.sql...

Hi Greg;

remember that a trigger needs to just handle data, and not do business logic like sending an email...an email might take 5 seconds to actually finish doing the handshake...

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