Viewing 15 posts - 4,561 through 4,575 (of 7,429 total)
Another way which is set based is to use a LEFT JOIN
SELECT t1.*
FROM
t1
LEFT JOIN
t2
WHERE t1.id = t2.id
WHERE
t2.id IS NULL
With the left join when there is no match the output will...
October 25, 2002 at 8:50 am
Was there a previous install of SQL that maybe had been unistalled or someone started to install to C: then changed mind and stopped. There is a believe a known...
October 25, 2002 at 8:46 am
Sounds like you may not have turned on cascading updates (sql 2k) or you didn't build a trigger to cascade updates (sql 7).
"Don't roll your eyes at me. I will...
October 25, 2002 at 8:39 am
It is not supposed to make another trip to the Domain Controller (PDC or BDC). The security token has enough detail to provide SQL the answer as to who the...
October 24, 2002 at 9:47 pm
Need to not do this on sections such as Content Discussions and other items that have no reason for someone to neccessarily reply.
Ex.
"Don't roll your eyes at me. I will...
October 24, 2002 at 8:49 am
You can do in the same DTS package by setting up a CONNECTION object for the server and one for the file. The setup two transfermations from the file connection...
October 24, 2002 at 6:09 am
Sorry, I cannot find it but the is a command line switch you can use with SQL setup that will prompt you at each step. This should give you an...
October 24, 2002 at 5:58 am
quote:
1. Use the tbl_Contacts locally. You can do it by copying it to a local temporary table (in the beginning of you...
October 24, 2002 at 5:19 am
To the best of my knowledge MS quit producing those books and no SQL 2000 Manual version of BOL is available.
"Don't roll your eyes at me. I will tape them...
October 24, 2002 at 5:03 am
In that situation I wuld export the data per year into text files (this makes sure can be recovered in case software version outdates other modes).
Depending on the size of...
October 24, 2002 at 5:01 am
Not sure but the install should have created a log of the events that in went thru and may offer some help. Sorry I forget the names but should be...
October 23, 2002 at 8:35 pm
Now degress are different as the person should have spent a good amount of time in labs. With a Masters they should also have a good deal of hands on...
October 23, 2002 at 8:31 pm
This is the basics for 1 copy.
INSERT tblX (names, vens) SELECT 'name2', vens FROM tblX where name = 'name1'
Try a while loop sorta like this if you need to do...
October 23, 2002 at 8:22 pm
Not really sure but I see this with 4Gb restores taking 45mins to an Hour. I believe it is an IO related coming from my Tape Drive. However when I...
October 23, 2002 at 8:07 pm
Depending on how you get the records and what fields are duplicated you have multiple options. How many columns must have the same data to be considered a duplicate. If...
October 23, 2002 at 7:56 pm
Viewing 15 posts - 4,561 through 4,575 (of 7,429 total)