Steve that is the usual transition from Summer to Winter here in KC. Fall is usually right around 5-6 hours followed by a long and cold winter. 😛

Understand. Did you see this part?

If you really want some help...

fmarler (11/17/2015)

---

SELECT

[transaction_detail_id]

,[transaction_code]

,[transaction_short_desc]

,[transaction_desc]

[highlight=#ffff11] ...

ROFL.

Alan.B (11/16/2015)

---

The Dixie Flatline (11/16/2015)

---

Without using specific examples to test, it is hard to explain why set-based processing outperforms cursor-based code. ..."It depends" to coin a cliche. ...

luissantos (11/16/2015)

---

Hello comunity

I read that is not best practice to Shrink database due to index defragmentation,

but my DATA file occupies in disk 39 GB when in fact the size is...

robert.sterbal 56890 (11/16/2015)

---

Along with the answer to a persistently "lazy" person, it might be nice to put out a resource you can send them to that goes over the expectation...

Ed Wagner (11/16/2015)

---

Sean Lange (11/16/2015)

---

I didn't think it was that snippy. I wouldn't have given them the code...

I didn't think it was that snippy. I wouldn't have given them the code though. 😀

Then use DATEADD. https://msdn.microsoft.com/en-us/library/ms186819.aspx

Let's start with some formatting so it is legible.

SELECT t00.ScenarioID

,t01.[GROUP]

,'' AS GroupName

,t01.companygroupaccount

,t01.accountnum

,t01.accountname

,SUM(t00.ActualValue + t00.Forecast) AS Forecast

,0 AS ForecastPercentage

,SUM(t00.BudgetValue) AS Budget

,0 AS BudgetPercentage

,SUM(t00.BudgetValue - (t00.ActualValue + t00.Forecast)) AS Variance

,0 AS VariancePercentage

FROM...

vavfam 50321 (11/16/2015)

---

Here is the error I get. I also max out on errors and it fails at that point.

Bulk load data conversion error (type mismatch or invalid character...

sqlinterset (11/16/2015)

---

I need to calculate a date from specific date. For e.g. If my date is 2015-10-08 and i want to see date after 4/14 months. How can i do...

sharonsql2013 (11/16/2015)

---

I need to calculate the difference in two adjacent fields and if the variance is +20% or -20% or more than flag it.

Say the fields are JanTotal and Febtotal.

Can...

vavfam 50321 (11/16/2015)

---

I have a text file that I receive from a partner. The file gets imported into our SQL using a temp table in a SQL Job. ...