In Excel, insert a column next to the one with the date. Assuming there is a value in B2 displaying like 12/31/2015 ... Enter a formula into C2 (the new...

Great question. It reminds me of the merge join transform in SSIS, the inputs have to be ordered in like fashion.

summerpet39 (1/14/2016)

---

Extracting data from Google Analytics requires some programming skills.. specially with OAuth 2.0. If you are comfortable with C# or other language .. use their official SDK found on...

If this is indeed the case, I am not sure why updating one field means blanking out the other, but as I mentioned I am probably missing a thing or...

Now if a field does not need updating, I guess the value in the table would stay null.

How to get around that in some cases (UPDATE X SET field4=7,...

abdullah.zarour (1/13/2016)

---

Hello Michael

Quick questions. Have you ever partitioned a table? If so, can you provide some actual facts as to what the performance gains you realized?

Yes , I did...

Eirikur Eiriksson (1/13/2016)

---

SQLRNNR (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Jacob Wilkins (1/13/2016)

---

edwardwill (1/13/2016)

---

Eirikur Eiriksson (1/12/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error...

abdullah.zarour (1/13/2016)

---

Hello SSC-Enthusiastic ,

You might try the following point :

1. Create a table partition.

2. Configure the SQL Server Instance Option ( Optimize for Ad hoc workloads).

3. Check Max...

If that is the case I am wondering how many different permutations of updated columns do you need compared to the number of Id's... which leads me to wonder if...

Stijn977 (1/11/2016)

---

Hi Sir, talk about quick turnaround. I was actually already editing my post, please allow me to give some more details:

Can you further define "big transaction"?

==> 500 to...

Orlando Colamatteo (1/12/2016)

---

MMartin1 (1/12/2016)

---

Orlando Colamatteo (1/12/2016)

---

titsiros (1/12/2016)

---

The reason for the merge is because one client acquired the other and they don't want to maintain separate systems.

I know it's a...

Orlando Colamatteo (1/12/2016)

---

titsiros (1/12/2016)

---

The reason for the merge is because one client acquired the other and they don't want to maintain separate systems.

I know it's a grand task because...

Borrowing from Eirikur's code a little bit,

Maybe you are looking for something like this ?

create table #sampleScheduleData

(

scheduledClass VARCHAR(50) ...

I am assuming that this is a string column for a int column would not hold the leading zero by the way.

declare @myint int = '0123'

select @myint

Plus needless to...

If you are still introducing this into another string column then

declare @mystring varchar(10) = '01092015' ;

select right(@mystring,4) +'-'+

left(@mystring,2)+'-'+

substring(@mystring,3,2)asdateFormattedString

This leaves...