Just my 2¢ but why keep it so small? Since it is holding aggregate data let...

With no more details than this we don't have much chance of providing much help. The best we can do is take a shot in the dark. At the absolute...

Well if the column that is being changed is used as a parameter...

The code is much as I expected. It is better if you can post the ddl for your tables and the data as inserts. That way we are not left...

aaron.reese (6/17/2013)

---

I would say don't worry about how it works, just play with the different parts to see what effect is has on the output. This will allow you...

There are a LOT of possible culprits in here. The excessive amount of scalar functions is certainly one of them. By my count there are 9 columns that are direct...

That isn't the point of normalization. I would guess that if this is an online account you...

T.Ashish (6/17/2013)

---

SQL Server allows the nesting of transactions. Like:

BEGIN TRAN

BEGIN TRAN

code...

...

Lynn Pettis (6/14/2013)

---

***************************************************

I am officially going to Afghanistan!

I leave for IRDO at Camp Atterbury in Indiana on Sunday, June 23rd. All should go well there with me leaving there...

jcrawf02 (6/14/2013)

---

SQLRNNR (6/13/2013)

---

Chad Crawford (6/13/2013)

---

The Dixie Flatline (6/13/2013)

---

I will explain...

No, to explain will take too long. I will sum up.

The Doctor is on first.

The enemy's gate is...

Jan Van der Eecken (6/14/2013)

---

dwain.c (6/13/2013)

---

Sean Lange (6/13/2013)

---

WayneS (6/13/2013)

---

dwain.c (6/12/2013)

---

I can only imagine what it must be like to have SQL Server running in some non-English language. MS probably...

certcognos (6/14/2013)

---

Hey Gurus,

I have one string variable that defines the transaction type as "Revenue" or "Finance". I have another variable that am using to execute the appropriate stored procedure based...

sdhamani1020 (6/13/2013)

---

I tried this option. Apparently the table with CompanyID does not have any related table.

However , the table with revenue id , does bring up lot of related...

How about some basic ddl and a little bit bigger piece of the puzzle? The details are so sparse we are left guessing what it is you want to do.

adonetok (6/13/2013)

---

I am learning crosstab query and create a sample. It works fine.

Since my real project needs date range is mydate >= (getdate() -15) which will make mydate are different...