Viewing 15 posts - 3,361 through 3,375 (of 3,396 total)
Outer join Products to the Sales and Returns tables. Do a totals query. Then you'll get a record for every Product regardless of whether it has had any...
June 5, 2011 at 8:49 am
FWIW, I took the SQL 2005 Developer cert exams. The Measure Up exams were significantly more difficult. (And realistic).
I'm really not sure having certs proves anything at all. ...
May 22, 2011 at 9:09 pm
FWIW, I would keep both in the same table at least for the time being. Then at least you can use the old/new keys to test that everything is...
May 14, 2011 at 7:51 am
Worked a champ! Thanks!
Pieter
May 8, 2011 at 2:26 pm
What if you partition the table on the date field and then you can drop the partitions you no longer want/need?
April 10, 2011 at 10:46 pm
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
Viewing 15 posts - 3,361 through 3,375 (of 3,396 total)