rajasekhar857 (9/8/2009)

Select * from (

SELECT MED_NAME AS MEDICATION,

ETC,

generic_drug_name_override,Row_number() OVER (PARTITION BY MED_NAME

ORDER BY MED_MEDID_DESC ,

med_routed_med_id_desc ) rno

FROM EMRMedicationsTPLkup

WHERE UPPER(MED_NAME) = UPPER('Aspirin')

AND...

m.dunster (9/5/2009)

So the first row would have a number of visits...

It sounds to me that it's not so much that you want to remove the trailing zeros as it is that you only want the first 5 characters. So, try...

Jeff Moden (9/6/2009)

This is an interesting challenge, but you didn't provide enough information for anyone to really help you out. For instance, can you have a booking from 9:15am - 9:45am, or...

So true. I know that since I'm at a facility on the eastern shore, we're also prone to hurricanes. We actually shift over to our backup facility on all systems...

GilaMonster (9/3/2009)

Probably as a web or front-end developer. I still enjoy coding. I was half-planning some years back on going back to dev. A...

This could be your problem. If the column(s) in...

Restore your backup to a different database, on the same server if there is enough space. Then you can do an insert from the new database to the table where...

%^$^&%#&

Forgot all about the 24 hrs of SQL. Sounds like the presenters did a good job.

Set up a separate data flow task for each.

In each data flow task, set up your oledb source to your sql server, and an Excel Destination.

This should handle what you're...

cmcc (8/21/2009)

david.c.reynolds (8/21/2009)

This is a very fascinating article. I have always wondered it there was a way to write data from SQL directly into an Excel Spreadsheet.

...

Barry, I appreciate you looking into this. Take care of yourself first, and come back to this when you're up to it.

That "tough problem" part intrigues (and scares) me. If...

Not necessarily. If your 2000 db has features that have been removed, then those won't work.

I suggest that you run the Upgrade Advisor against the database to see what it...