So there is no backup done on your databases? If this work related, I am sure there is backup, ask the system guys.

Thanks a lot Andy.

Thanks all guys!

client need the numbers to be displayed this way and our database has numeric type for that column.. i guess we need to change the data-type if the client is...

I need to insert that result into a column that has numeric data-type... which I was not able.

Thanks but I cannot change the data-type from numeric to money on the destination table. the value is 15610 I need to add '$'.

SELECT TOP 75 * FROM tableName

ORDER BY NEWID()

I think this should work.

Why don't you export the file and then rename the file appending date and archive it to some other folder.

I guess the best way is creating a template, formatting the column with leading zeros as text and then using the template. But then I have to do this for...

The other_id is the field that I am having problem with and it needs to be padded with leading zeros. Thanks for help guys.

Thanks entusiastic... here is the select statement.

SELECT replicate('0', 9-len(i.other_id)) + cast (i.other_id as varchar(9)),convert(varchar(10),p.pledgeDate, 101) as [EFFECTIVE_DATE],

  case when p.pledgeTypeFK = '3' then convert(varchar(11), p.amount)

  when  p.pledgeTypeFK = '5' then  convert(varchar(11),

  (convert(decimal(5,2),...

Thanks Steve, but I am not doing import... I am doing export.

someone!

Checked it... permission is not the issue here. Thanks for the help guys.

The account is fine.