That is a pretty bold statement to make when we don't...

latitiacasta (1/29/2014)

---

Hi,

I have excel file as below.

name addressText

helen chicago acon,vosl

jeniferNYC ...

Can you generate execution plans? It would be very helpful to see the actual execution plan from a query that is slow.

For maintaining indexes you should check out this link....

Awesome job posting ddl and sample data. Your explanation was quite clear too. This seems to be an art form that so many people are unwilling or unable to do...

CRC (1/28/2014)

---

Sean thanks so much for your help. Based on your previous response I was able to figure out what I needed to do. I just needed to...

OK I read your post again and was horribly confused by the query in the middle until I realized that is what you used to fill your table variable.

Here...

Not entirely sure what you want here. Do you want only the first row to show customer_id and any subsequent rows to hide that value? Essentially providing a report style...

Your sample data will not reproduce this issue. However, the reason you are getting "duplicate" rows is because in at least one of your additional tables your join matches on...

GilaMonster (1/28/2014)

---

Sean Lange (1/28/2014)

---

GilaMonster (1/28/2014)

---

When there are multiple triggers for the same action (multiple insert for example), you can defined which one runs first and which one runs last, but...

mike.conti (1/28/2014)

---

sorry for the confusion: there is no syntax issue

This works: SELECT top 10 * FROM ACTI**_**

it does not appear in when i run this SELECT * FROM sys.tables WHERE...

Interesting....

mike.conti (1/28/2014)

---

I am trying to see what happened to a table. It is a transaction table that I think may be dropped.

This works: SELECT top 10 * FROM ACTI*****_****

it...

ramana3327 (1/28/2014)

---

Please let me know the max no of triggers we can keep on a table & which will execute first if we have all insert, delete & update triggers...

jasona.work (1/27/2014)

---

Steve - Yes, that would be sufficient for what I'm looking for...

And Sean - THANK YOU! I'll tweak what you gave me to return the columns I need...

Terry Bottorff (1/27/2014)

---

Wow what a great way to do this. I am reading a great deal about pivots and cross tabs. I can see their huge power but with my...