Grant Fritchey (4/9/2015)

---

Sean Lange (4/9/2015)

---

sqlfriends (4/9/2015)

---

Yes, I rarely do that too, but if it is a very simple change, I do that to save time.

Just curious if SQL server have...

Brandie Tarvin (4/10/2015)

---

Here's what I did at a similar event at my workplace. You might not have time for it all, but it's a place to start and the kids...

The only way you will be able to conditionally select columns is with dynamic sql. That means that you are going to have to first run your dynamic pivot and...

tomsharp85 (4/9/2015)

---

Hi, I think I am closer to posing a clearer question. Here is a company information table that I split from the address one:

USE DataCompany

CREATE TABLE CompanyInformation

( CompanyCategory varchar...

Luis Cazares (4/9/2015)

---

I was expecting an advice from Grant involving a kilt. 😀

Seriously, now.

- Try to be very organized as your time is very limited.

- Measure...

kyliebjoe (4/9/2015)

---

Hi John,

I thought I had used what you saidby trimming the front and back off which works fine when a middle name is present.

BUT when it is...

Grant Fritchey (4/9/2015)

---

That's tough, but for a 10 minute presentation, focus on communicate a single idea. Don't try to cover too much. You want to show the magic of development,...

Not unless most of your updates are only to a single column. I would make a copy of the table to hold the "old" values. If you update 7 out...

SQL_Surfer (4/9/2015)

---

Hello all, I have atttached the query plan. I think the problem is from using Count Distinct. Is there any work around that? If I remove, count(distinct), it...

homebrew01 (4/9/2015)

---

Hi, I have data in a trace file, and I need to extract some info such as phone number.

The problem is the phone number could be varying lengths, and...

Here is the challenge I see from your design. You are creating a EAV style of logging table. This is a real pain to deal with in the long run....

For any of you regular speakers I could use a little help over here. http://www.sqlservercentral.com/Forums/Topic1675923-61-1.aspx

Eirikur Eiriksson (4/9/2015)

---

Good point, then we use the sys.all_sql_modules

😎

SELECT...

One caveat of Eirikur's excellent suggestion is that it will NOT find any references if your procedures contain dynamic sql.

sqlfriends (4/9/2015)

---

Yes, I rarely do that too, but if it is a very simple change, I do that to save time.

Just curious if SQL server have ability to do that...