DBAs have multiple accounts: Regular accounts are in a security group that has SA rights on the servers in that domain. Each DBA has a service account in each domain....

I have to agree with others. What does the above quote have to do with the question?...

rajasekhar857 (9/8/2009)

---

i need the following query in 2000.please look into this.

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)

---

Bascially I want to populate the numberofvisits column with the sum of the frequency dependent upon the number of hours

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)

---

I guess I don't understand a couple of things... when you say you want to "randomly generate the 3rd and 4th column", do you mean just for the...

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)

---

Well, I'm not a DBA anyway but...

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)

---

My only consolation is that there seem to be so many posts about this issue both here and on other forums that they have to do something about it,...

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

---

Wayne,

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.

...