I'm sorry I wasn't more specific. It could be either a cumulative file daily or a file with just new records/leads.

regards,

John

Good point, Scott. I did some tweaking but in essence that was the direction I needed to take to get the desired result.

J.

Mark, thanks a lot for the solution. It was just what I was looking for to get the results I needed.

Much appreciated,

John

That's right Lynn, I did accomplish it. I started by creating a temp table w/ an incremental field. Then created my final table from it ordering by newid. It worked...

Lowell, let me bounce this off you now:

I have tested my 3 steps of the solution and they all work great. However, after presenting it, I was asked that it...

I'll definitely look into it.

Thanks,

John

Thanks, man. I was able to run it from the SQL Mgtmt Console and cmd window. This tentatively completes the requirements for my solution:

Create/sched. a SQL Job that: runs...

Thanks, Lowell.

I went with option one and after some tweaks, I have my temp table. Now, I'm getting ready to exec EXECUTE master.dbo.xp_cmdshell but I can't find this anywhere. ...

Thanks, Matt. that works just fine.

Regards,

John

Hey Matt, what if the table is in a different database? For example: DATABASE2.

Where would it fall within the syntax:

Declare @SQLExec varchar(1000),

@BackName varchar(8)

Set @BackName = replace(convert(varchar,getdate(),101),'/','')

-- select @BackName

Set @SQLExec =...

Thanks, Matt. It works! I thought it was somewhere in the placing of the quote marks. FYI, it works with "exec" vs "print".

Regards,

John

I know this was posted ages ago, but I just came across a scenario that requires me to replace such values and I would like to be able to do...

I may not have phrased it correctly, thus, I apologize. The field type is float and the value it has is 24701. What I am trying to do...

It turns out I had already installed that component, so that was not it. BTW, I have the developer ed. installed.

Regards,

John

Cath, do I need to unistall and re-install sql server, do can I just run set up.exe and add that component?

Regards,

John