What a strange question. I assumed you would get script B in both cases. I tested this in 2008r2 and confirmed that is correct. I don't have 2014 at work...

HookSqlDba7 (6/3/2015)

---

I have been doing some research on sp_UpdateStats stored procedure, UPDATE STATISTICS SQL Statement, and Auto Update Statistics. Sounds like 'sp_UpdateStats' stored procedure updates the database statistics for all...

cstg85 (6/3/2015)

---

I am creating a package that performs a simple insert into a couple of float columns. The reason for using float is because we are storing exponents. I have...

ramana3327 (6/3/2015)

---

It is reducing the execution time but in the execution plan the new index is not showing anywhere. How can we say the index is using or not while...

yusufm 48726 (6/3/2015)

---

The issue is with date sort order. it sorts it in lower number first then higher date it is a weekly report but when the month change and...

Yes that is my sentiment exactly. The GOTO has no relevance in t-sql since...

Alan.B (6/1/2015)

---

You don't.

When you create a primary key you have the ability...

Lenochka (6/1/2015)

---

Thank you for writing this. I used to ask a cursor question when interviewing candidates and I got the same answer every time “you shouldn’t use cursors,...

ZZartin (6/1/2015)

---

g.britton (6/1/2015)

---

pietlinden (6/1/2015)

---

Not a very helpful article. A really helpful article would have gone something like...

Here are some places where you might consider a cursor...

Here are places...

Bill...

There are absolutely times where cursors are the best coding methodology for the task at hand. I think this editorial would have been a LOT more persuasive if we had...

Lynn Pettis (5/29/2015)

---

Eirikur Eiriksson (5/29/2015)

---

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how...

Alan.B (5/29/2015)

---

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in...

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition to the...

sarath.tata (5/29/2015)

---

Sean Lange (5/29/2015)

---

Your question is not at all clear. What would be helpful is if you could post ddl and sample data in addition to the desired output. I...