Thanks a lot Grant. So this means I had correct understanding. Seems lots of people have incorrect understanding of this slight difference between the two.

Thanks Grant for giving me direction. I'll check it out. One more thing. The text values in my file are enclosed within " for example "sports". And the numeric values...

Thanks for clarifying that thing guys. Appreciate.

One more question now. So I should change the ownership or my db schema from abc_dev to abc_prod. So whenever i'll refresh...

Thanks John. That helps and clarifies my doubt

Thanks mgnson, but I want to do it using SQL programming. Is it possible ?

So I have a table as following information

CustID productID qty amt orderdate

1001 prod1 ...

Apologies for the late reply but the query works like charm.

Jeff Moden (9/14/2016)

---

sqlenthu 89358 (9/14/2016)

---

Hi all, I have to transfer around 50 million records from one table to another. What should be the best approach. I know it can be...

Table is not partitioned and also system will...

I got it. I have to run the alter scheme after every alter partition to use primary filegroup.

Hi Gail,...

Hi Gail,

One more question. Can I have more no of partitions then the no of filegroups ? Though my partition scheme says all partition should be in primary filegroup.

Perfect. Changing partition function to just date worked perfect. Thanks a lot Gail.

Hi Jeff, thanks for the explanation. In my table there will be truncate load operation on monthly basis plus only few read operations. I have currently put all the partitions...

I wanted to do the same Matt and as you clarified, I get it that it's not possible. Rather I am taking a new approach now. The whole purpose was...