can you paste the query as text here as well? it helps to be able to see that as text and not as an image in order to help better.

lol encrypting is a good answer. way to go!

there's an excellent stored proc called sp_generate_inserts Written byNarayana Vyas Kondreddi

http://vyaskn.tripod.com

he's got one for 2000 and 2005 and it generated statements like...

you can use the table value function as a joined table or as an in() statment as well, if it's not obvious: i used a #tmp table,b ecause you might...

i think what you are asking for is exactly what full text indexing actually does.

it creates the word list for you, maintains an editable list of noise words, and handles...

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.