I'm trying to make a query that will grab all the "board_specialty" from the physicians tables. The problem is in the way the tables are designed. This is how it looks:
Board_Name Specialty_Name Order_
American Board of... Surgery 1
American Board of... Family Practice 2
American Board of... Internal Medicine 3
How I'd like it to look after the query (to avoid 3 rows with the same info):
Physician_Name Board_Name1 Board_Name2 Board_Name3 Spec_Name
John Doe American board of... American board of... American Board of... Surgery
Mary Sue American board of... American board of... American board of... Pediatrics
Bob Dillon American board of... American board of... American board of... Cardiovascular
I dont need to query the multiple secialty names...just the different board names on a flat file.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…