Hey Lowell, thanks for your help, I'm trying to get the number of days less or equal 30 days.

the report supposes to show the patients whose got admitted within 30...

That really worked ! thanks so much and cheers for the reply and the brains....

dant12 (4/16/2010)

---

as far as I know you can't "SELECT * INTO TABLE" into an already created...

Thanks for that.... playing around with it now ..

jcrawf02 (4/7/2010)

---

In case this helps, here's what I use when I need to look for help, just realized that the date shifting...

jcrawf02 (4/7/2010)

---

Readmits within what time frame? We have been looking within 30 days typically, but some reports want any readmits within a rolling 12 months with a 3 month lag...

Thanks anyway Steve, but it was made up and mixed up data..anyway I hope someone can direct me of how to do it using a query or using SSIS.

Thanks

No problem, I'm working on a JOHN DOE example 🙂 but i'm trying to match my sample data with the final report... working on it.

Thanks

No Actually not, it wasn't real live data, I just mixed the names and the numbers 🙂

Hi Lynn,

Thank you for your reply...

I've attached , the DATA, TABLE query, and the final results..

What I've done actually for the last 2 days is NOTHING, running 10000 or queries...

Hello and congrats, did you use any dumps? or how did you prepare? thanks...