Just wanted the free point 😛

The code you provided gives you all the parameters that are either passed in or out of the stored procedure, so they will all be at the beginning of the...

Are Cash and Expense always going to have opposite signs? This is coded assuming they will, but the Debits and Credits have the same signs. What about the...

First off, a 2Tb table should be partitioned, otherwise any type of management, querying etc... will be a nightmare.

Adding a column, then updating it, moving it to another...

Were you running this in BIDS or executing the package through SSIS? You should be able to write the events out to a log file that will give more...

I think adding 20 indexes is way too mich overkill. Have you tried running a simple trace for a couple of "normal" days to see what kind of activity...

When you do the insert and have a union all, the Insert into statement only needs to appear once

--Start and End Dates For Auto Fields

INSERT @Cols (SortOrder, Head) ...

Here's the same issue with some answers

http://www.sqlservercentral.com/Forums/Topic1101072-392-1.aspx

I guess it depends. The code you have will give the columns in desc order. If you remove the desc, then the columns ascending order. If you...

You were close. Instead of setting the value to an empty string, try null,

(DT_DBDATE)(([FEES-DUE-DT] == "0000-00-00") ? NULL(DT_WSTR,10) : [FEES-DUE-DT])

Got it now. You can use the case statement that you originally used. This will work as long as they are both strings, if not then you will...

That guy wrote a statement like

Update dbo.Transactions Set

TractorPPG = @price,

TractorCost = @TotalCost

Where Current OF OPIS_Cursor

do you think any index will help here as this update statement is...

chandan_jha18 (5/12/2011)

---

Mike01 (5/12/2011)

---

Just a question. What is this code for? I will also echo what has already be said.

select distinct

t.TransactionDate ,

...

Just a question. What is this code for? I will also echo what has already be said.

select distinct

t.TransactionDate ,

pd.productDescription as...

WOW!!! That's some query. Can you pare it down to include only the columns you are concerned about? Also, how about some table layouts and sample data?