self

SELECT

ae.BenId,

ae.OptionId,

COUNT(ae.PersonId) AS 'Total Employee Enrollment'

,COUNT(ae.PersonId)/(ca.TotalCount*1.0) as PercentEnrolled

FROM util_active_elections ae

INNER JOIN cdm_employment_his eh

ON ae.PersonId = eh.PersonId

CROSS APPLY (SELECT COUNT(ae.PersonId) AS TotalCount

FROM util_active_elections ae

JOIN cdm_employment_his eh

ON ae.PersonId =...

ronan.healy (8/11/2014)

---

ok

would I still be able to use SUBSTRING(TaxLotDescription,1,3) for pulling the first 3 chars.

how would I be able to do in tsql

III.Identify the amounts purchased / amounts sold

a.If the...

Besides the blatant shrink is the lack of care for the recovery model and ensuring the recovery objectives are still in place.

If this script is going to force a change...

All of that can be done via TSQL query in your data source.

One method to do that is to join back to the table based on Phone where personid <> personid.

You could also implement a row_number() function on the dataset, based on...

ronan.healy (8/11/2014)

---

hi

i have a tbale and after the table i want to put in a derived column that then pick just the data from the InvestmentType == "Forward Cash"

now i...

Phil Parkin (8/11/2014)

---

ronan.healy (8/11/2014)

---

hi

i have a tbale and after the table i want to put in a derived column that then pick just the data from the InvestmentType == "Forward...

Robert.Sterbal (8/11/2014)

---

More data might not get you the specific price on a house, but it will often help get you the reasonable estimate of whether a house should sell for...

charitable

LutzM (8/10/2014)

---

Is it as annoying for you as it is for me to see all those spam posts?

Today (Sunday, August 10th), 22 out of 36 posts were plain spam. All...

Compost

Ed Wagner (8/8/2014)

---

sing4you (8/8/2014)

---

Ed Wagner (8/8/2014)

---

TomThomson (8/8/2014)

---

Ed Wagner (8/8/2014)

---

Hull (Thanks...I had to look up the meaning of the word and it's always nice to...

No. Those settings take immediate effect.

doug.hill (8/8/2014)

---

Thanks for the lead sqlrnnr. I tried to get in touch wit SSG, but no one answered their phones or has replied to and emails.

Has anyone had success with...