Brandie Tarvin (6/23/2015)

---

So I know it's dirty pool to promote one's own blog on the forums, but in this case, I absolutely MUST show off.

Click it and you'll see why....

paul.howard.raines (6/22/2015)

---

Thank you all for your very helpful replies.

I broke down my query to remove that "firstname and lastname" nonsense.

Now, my query is running based on criteria like :...

Yes I know, I saw it. You need the year as well as the month...

Being neither big nor an engineer I'm not really qualified to play with any data, but I do, and there are plenty of tables under the roof here which are...

sqlinterset (6/22/2015)

---

I have a table has data of all months. i want to have this table data in the form as first it lists data

from 1 month to current...

Alvin Ramard (6/22/2015)

---

GilaMonster (6/22/2015)

---

It's starting to look like the replication which keeled over last week did so because the passwords on the distributor were changed. If I've lost my entire...

djj (6/22/2015)

---

Since I did not write the stored procedure, I wanted to check the behavior before possible re-write.

I have actually run across something similar some place but I did not...

lmarkum (6/19/2015)

---

I have an UPDATE statement that joins two table by SendId. One table, I'll call it T1, has a clustered index on SendId ASC. The other table...

I'm with Alvin on this one Sean - walk away. The OP's...

Alan.B (6/18/2015)

---

ChrisM@Work (6/18/2015)

---

You will find this much easier to work with if you can reduce the clutter, and one way of doing this is to encapsulate sections of the code...

paul.howard.raines (6/18/2015)

---

ChrisM@Work (6/18/2015)

---

Does this simplification work for you? We can add Clean and Unclean next.

SELECT

RES.method,

payment_id = SUM(CASE WHEN Filter = 1 THEN 1 ELSE 0 END),

[status] =...

Sean Lange (6/18/2015)

---

Ed Wagner (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

Sean Lange (6/18/2015)

---

Eirikur Eiriksson (6/18/2015)

---

Too busy to respond and I think it's time to introduce "crystal bullets" since the C-ball is a no show...

GilaMonster (6/18/2015)

---

It's...

sqlinterset (6/18/2015)

---

Tables which already exist in database i am using 3 name table convention but there are two tables which are created in database itself, where i can't use 3...

sqlinterset (6/18/2015)

---

This is the sequence of errors when running the same query through excel pivot option

1)Changed database context to XXXXX

2) Problems obtaining data

3) A pivot table using connection 'YYYY' has...