Apologies for late response. So here is the complete picture:
Every user is mapped with one or more unit ids. Every month when our batch is processed, all entries get...

Hey Thom, these are dates only and no VARCHAR. I gave few records to show they type of data. All date related columns are in datetime data types only.

Thanks Sue. However I was looking for something to see if there can be any code breaks while going from SQL 2008 r2 to 2014. Any code which will need...

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.