With well over 500 points I find it amazing you would post this. There is no ddl for any of the tables, there are multiple additional procs being called and...

SQL Kiwi (5/22/2012)

---

Sean Lange (5/22/2012)

---

I still say the Kaprekar series is entirely too much looping for t-sql. It can be done but you will basically have to add some form...

boehnc (5/22/2012)

---

thank you for the code..I'll give that a try. Do you have better suggestion for the sum? I'm trying to add all the department code charges, and if there...

I still say the Kaprekar series is entirely too much looping for t-sql. It can be done but you will basically have to add some form of recursion to call...

SQL Kiwi (5/22/2012)

---

This doesn't compute someone's age. It needs a formula like:

Age =

CASE

WHEN DATEPART(DAY, dbo.b_ENROLLMENT.MEMBER_DOB_DATE) > DATEPART(DAY,...

That is what UNION does. It will combine multiple queries into a single resultset. I have a feeling you want to look at crosstab or pivots.

http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

Like this???

Select

dbo.b_ENROLLMENT.MEMBER_DOB_DATE,

dbo.b_ENROLLMENT.EFF_DATE,

dbo.b_ENROLLMENT.MED_ID,

dbo.b_ENROLLMENT.PLAN_CODE as aid,

dbo.p_DMAS_MEDICAL_TRANSITION.recip as recipno,

dbo.p_DMAS_MEDICAL_TRANSITION.SEX as sex,

CASE WHEN (dbo.p_DMAS_MEDICAL_TRANSITION.SEX)='M' THEN 1

WHEN (dbo.p_DMAS_MEDICAL_TRANSITION.SEX)='F' THEN 0

END AS MALE,

case

when (dbo.b_ENROLLMENT.PLAN_CODE)='450' or (dbo.b_ENROLLMENT.PLAN_CODE)='451' or...

chalbert (5/22/2012)

---

Thanks...but I keep getting the errors:

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16, State 1, Line 22

Invalid column name 'aid'.

Msg 207, Level 16,...

chalbert (5/22/2012)

---

The following data keeps coming up with the error that there is an issue around the as in the alias for age...any thoughts?

Select

dbo.b_ENROLLMENT.MEMBER_DOB_DATE,

dbo.b_ENROLLMENT.EFF_DATE,

dbo.b_ENROLLMENT.MED_ID,

dbo.b_ENROLLMENT.PLAN_CODE as aid,

dbo.p_DMAS_MEDICAL_TRANSITION.recip as recipno,

dbo.p_DMAS_MEDICAL_TRANSITION.SEX...

With the amount of looping and such I...

I am a firm believer that any column should have a name that identifies it clearly and should not change between tables. Column names changing table to table is complete...

toddasd (5/22/2012)

---

Sean Lange (5/21/2012)

---

toddasd (5/21/2012)

---

If it is already a space why change it to a space? Wouldn't this get everything:

Select ISNULL(Item, ' ') from ITEMS

Or are you trying to...

What you have is the beginning of your worst nightmare. The challenges you are facing is the reason you shouldn't store more than 1 value in a single column. You...

I do however accept Guinness. 😛

Thanks for the props but we don't roll like that around here. It could be that...