to do what yoiu are asking, you need to take the RIGHT() 15 chars of 15 '0' + the convert of your value.

for example

SELECT RIGHT('000000000000000' + CONVERT(VARCHAR,GETDATE(),112) ,15)

look at...

anytime you SELECT something, you technically could insert it into another table.

if you did SELECT TOP 5 NAME FROM sysobjects WHERE xtype='U', there's 5 rows right?

if INSERT INTO SOMETABLE(TableNames)   SELECT...

--As Ray identified, an integer will return as a valid date, so you need to filter the results with what date ranges are acecptable for you:

declare @someval int,

        @MinDate...

system stored procedures have a lot of notes in Books Online.

all the other stored procs would be created by your developers or some other party, so it's up to...

just a quick note: your trigger will fail if the INSERTED table has more than one row . you should change it to something like this:

if update(entry)

  begin

    update results_ext...

awesome! glad it worked out for you.

It was a neat challenge to try and figure that one out. It's really just grabbing building blocks of code I used before, and...

lol sorry for pointing out the obvious...I'll read a bit more on it and see if i find something un-obvious.

Gordon that latch type 2 error made me remember that there was  a problem in early service packs....while it might not be your specific problem, what version is on your...

bcp doesn't allow you to append files, but the COPY command certainly is able to do it.

here's a complete example: it uses the function i suggested above.

psuedocode: bcp, make header,...

lookjs like you are assuming a specific date format and preceeding zeros that you did not mention previously:

well this will work, but I agree with Ray that this isn't the...

I agree with Lynn no value to using a function in this case; also, I'd suggest creating an index on those 7 columns; it would most likely help on performance...

you'll want to use the convert function most likely...

assume a db has three int or other numeric columns:

SELECT * from sometable

WHERE CONVERT(VARCHAR,MAJORVERSION) + '.' + CONVERT(VARCHAR,MINORVERSION) + '.'...

look at this script from the contributions, which opens a file and appends to the end of it:

you could BCP to a file, and then use the script to append...

interesting; other than a restore of the data, everything i tried so far left the CRDATE in master.dbo.sysdatabases intact:

stopping/starting server. also tried rebooting the server.

backup full database, then backup transaction...

yep use a snapshot: a developer doing SELECT * FROM THE800MILLIONROWTABLE will kill usability, and he might have done it just to remind himself of column names.

keep developers off production.