Viewing 15 posts - 3,436 through 3,450 (of 3,475 total)
Here is the initial data:
USE SampleDatabase
GO
INSERT INTO Workstation (WkstationID, Manufacturer, OS, IP)
VALUES ('JFK1ABCD123', 'DELL', 'Windows 7.0', '123.123.123.21')
INSERT INTO Workstation (WkstationID, Manufacturer, OS, IP)
VALUES ('JFK1ABCD124', 'DELL', 'Windows XP', '123.123.123.22')
For starters, you...
June 5, 2011 at 9:35 pm
It should. IIRC, you can specify the collation in your query if you absolutely have to. Either that or you can set it globally in a stored procedure,...
June 5, 2011 at 1:12 pm
sqlguy,
I *think* you're on the money. I asked Louis Davidson (a SQL Server MVP/author) here in town about a question like that, and he says he deals with subclassing...
June 5, 2011 at 8:56 am
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
Viewing 15 posts - 3,436 through 3,450 (of 3,475 total)