You really should test your sample data scripts before posting.

* Your action table is missing the field event_name referenced in the view.

* You're view is missing the full_name field referenced...

seismicbeat (10/31/2016)

---

Hello,

Thanks all for all the help, sorry for not providing you the queries and not showing how I compile the data. The data is provided to me in an...

Calendar Tables[/url]

Drew

If you want tested results, post sample data and expected results as insert scripts as outlined in the first link in my signature. A picture of data is no...

The Dixie Flatline (11/1/2016)

---

So far you've only coded for an UPDATE...

Use Grouping Sets.

FROM CalcPart

GROUP BY GROUPING SETS ((subdepartment), (subdepartment,dutyhours,day,friday,saturday))

Drew

Since you haven't provided table definitions, index definitions, and the actual execution plan (as a .sqlplan file), there's not much advice that we can give you.

I did notice that you're...

snowprincess42073 (10/31/2016)

---

Hi all,

I would like to show the data up to 2 decimal places but without rounding off the integers. If the number is 4.6758 then data retrieved should be...

Please don't cross post. You already have a thread on this topic here. When you cross post, you fragment the discussion.

Drew

shorton2 (11/1/2016)

---

I figured it...

You do realize that for most purposes ISNULL and COALESCE are the same. I'm confused why you think that ISNULL won't work, but COALESCE will.

Drew

You're creating columnsequences named 'market1', 'market2', etc., but you're looking for columnsequences 'm1', 'm2', etc. I just changed your script to create columnsequences with the shorter name.

select delegatesname, m1,m2,m3,m4,m5,m6,m7,m8,m9,m10,m11,m12,m13,m14,m15,m16,m17,m18,m19,m20,m21,m22,m23,m24,m25,m26,m27,m28,m29,m30,m31,m32,m33,m34,m35,m36,m37,m38,m39,m40,m41,

m42,m43,m44,m45,m46,m47,m48,m49

into...

Latin is the base for ALL Romance languages. I have an MA in Linguistics, so I have some idea what I'm...

david.jack (10/31/2016)

---

drew.allen (10/28/2016)

---

david.jack (10/28/2016)

---

VAL1 can return NULL unfortunately so using a...

DesNorton (10/31/2016)

---

Eirikur's solution groups by PaymentComfirmDate.

In order to group by Year/Month, you will need to use something like this, which groups by the 1st of every month.

-- ...

MonthYear = DATEADD(mm,...