Wow, cool! With a minor tweak, it works a CHAMP!

with CoursePrereqs (

CourseName,

CourseNo,

reqCourseNo,

nextCourseNo

)as (

select

...

Jeff,

I would settle for something like this:

CourseNo, Level

503, 1

601, 1

605, 2

608, 2

620, 3

The last time I played with this (a LONG time ago!) I got sort of close to what...

Found one good article... hopefully it helps someone else... because reading the stuff in the MS book pretty much put me to sleep...

http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-basics-of-transaction-isolation-levels.aspx

Okay, all joking aside... the hard part about designing an ERD has nothing to do with SQL Server or any other RDB software. My absolute favorite tool for creating...

LOL... I a went to Office Depot the other day, and I asked them where the "smart pens" were, and they just looked at me funny... and then when I...

Where do I purchase this "Brain Assisted Pen"? Does it have to be assisted by my brain? (What good is that?!)

For someone who "needs to solve [this] on his own", you sure got the newsgroup to do a lot of your homework. The problem with that is who is...

Oh, okay... this is almost starting to sound like an episode of Intervention... "You gotta kick the cursor habit, man!! That stuff will kill you!"

I'm a recovering Access guy....

Really interesting discussion! (nearly wrote "disscussion" which almost seems appropriate!) thanks everybody for your input and examples.

just create a summary query

SELECT Booking_ID, SUM(TEU) As BookingTotal

FROM [MG_BOOKING_EQUIPMENT_REQ]

GROUP BY Booking_ID

ORDER BY Booking_ID;

If you use SSIS to do the data migration, you can change data types inside the SSIS package, and then write the data to the final table. Once you...

Not enough information. Post your Partition Scheme and Partition Function. Are you returning only the month in the Partition Function?

If the database is complicated, you may want to create views, stored procedures, and table-valued functions to return data to the users. Then you can basically hide the complexity...

JayK (12/12/2010)

I have an Order_Products table which has all products for all orders in our database for the past 5 years. The Order_Products table is transactionally replicated on our reporting...

Maybe I'm stating the blatantly obvious, but if you work your way through the Microsoft book covering the exam you're taking, you'll be okay. Just brew lots of coffee...