Thanks, I think I just pay attention to change the data and log directory, but ignored the backup directory, I need to pay more attention to that and make it...

I figured out, using facet in 2008 R2 is very handy to do. But anyone remembers if it is asked when do the installation? If so, I need to pay...

Thanks, that is what I found out too - to format the columns before copy, paste.

I am thinking more now into SSIS, to export sql result to excel, this may...

Thanks, replace will work.

I just tried it, when I paste to excel, it still has the appostrope, like '9-12

It is not hiding the ', also tried to paste special as text, same result.

dwain.c (7/5/2012)

Two surrounding apostrophes to denote the character string. Because apostrophe is the character string definition operator,...

Thanks, could I ask why it is 4 ', like ''''?

Thanks

I tried many times, that is not working as supposed to.

For example the orginal is 3-5, then when I copied to Excel, it becomes 5-Mar, then if I right click...

For my case, the hard part is I would like to compare the rangeCd that is a range, and separate grade level and make them not duplicate

Reload the script

I will reload them

Sorry, for some reason when I save from .sql to .txt, it changes the format.

i will try to attach it again.

Thanks all.

Yes, I ask one developer who has similar table columns, he said SK is surrogated key, NK is natural key

Thanks, will check into it.