{thundering voice in the background}CALM DOWN

😎

Rankerg (1/10/2016)

---

That is the requirement, any changes to any column means that is a CHANGED / MODIFIED record and these CHANGED/ MODIFIED files I want ? duplicates to be...

Grant, the link to your article doesn't work, copy...

harikumar.mindi (1/8/2016)

---

Hi Geeks,

I have a situation where our customers are planning to migrate their application from one Datacenter to another. We are currently performing a test to understand any performance...

Rankerg (1/10/2016)

---

Thank you but please explain, I could not understand the answer ?

Meanwhile let me rephrase my question

So let me rephrase the question

We would take the full file (Dec...

Thanks Gail, I totally missed that fact

😎

Thought the question was kind of odd but at that point there wasn't enough caffeine in the system.

Steve Jones - SSC Editor (1/10/2016)

---

Apologies, misread the piece. I thought it was everything before Edge, and not sure why I saw that, but I'm incorrect. It's all versions prior...

Jeff Moden (1/10/2016)

---

...Last but not least, you've made the code work and that's great. Next, the above code will help make it fast. Now you need to make...

First of all you need to provide the full and complete information, remember that we cannot see or know anything that's not posted here! Suggest that you post the DDL(create...

UDF is the equivalent...

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this into yyyy-mm-dd ...

adas-768309 (7/18/2011)

---

Hi all

I have been using SQL server 2005 Standard (32-bit).

I am planning to upgrade to 64 bit. But unfortunately I cant find a download link for SQl server 2005...

Duplicate post!

😎

Behind

Piling on, if for some reasons you don't want to use the unpivoting method then using three separate WHERE IN clauses is a much better option, it will use indices...