Viewing 15 posts - 3,451 through 3,465 (of 3,482 total)
Wow, I got my own village!
Silly me... forgot one of the tenets of good newsgroup postings... like "Did you search that big site that MicroSomething has about their stuff? like...
April 7, 2011 at 8:42 pm
Sorry, couldn't see your database... (your head was in the way). I think the only way you can get the value of the Identity column for the update is...
March 29, 2011 at 12:33 am
why not import it into TempDB, then use a series of INSERTS to move the data where you want it? Or better, use Integration Services if you have to...
March 29, 2011 at 12:14 am
Great! Thanks! I knew it had to be something stupid I was overlooking.
March 20, 2011 at 11:56 pm
Lynn,
if a course has multiple prerequisites, take the highest level... I think this works...
/*DECLARE @Sequence int
SET @Sequence = 4;
*/
-- define shape of output
with CoursePrereqs (
...
March 14, 2011 at 12:47 pm
Wow, cool! With a minor tweak, it works a CHAMP!
with CoursePrereqs (
CourseName,
CourseNo,
reqCourseNo,
nextCourseNo
)as (
select
...
March 13, 2011 at 9:57 am
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...
March 13, 2011 at 12:34 am
Found one good article... hopefully it helps someone else... because reading the stuff in the MS book pretty much put me to sleep...
February 27, 2011 at 10:20 pm
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...
February 27, 2011 at 2:38 pm
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...
February 27, 2011 at 2:31 pm
Where do I purchase this "Brain Assisted Pen"? Does it have to be assisted by my brain? (What good is that?!)
February 27, 2011 at 10:21 am
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...
February 27, 2011 at 10:06 am
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....
February 17, 2011 at 12:34 pm
Really interesting discussion! (nearly wrote "disscussion" which almost seems appropriate!) thanks everybody for your input and examples.
February 17, 2011 at 9:43 am
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;
February 2, 2011 at 8:06 pm
Viewing 15 posts - 3,451 through 3,465 (of 3,482 total)