To merge 2 tables into a distinct (no dups) resultset, use UNION: SELECT MyField1, MyField2 FROM MyTable1 UNION SELECT MyField1, MyField2 FROM MyTable2 To see if a set of columns is NOTin another table, there are numerous ways: SELECT * FROM MyTable2 t2 WHERE NOT EXISTS ( SELECT MyField1, MyField2 FROM MyTable1 t1 WHERE t1.MyField1 […]
2003-08-22
quote: The only thing that i need to change is this key? This is an 'official' procedure? Seems like i'm breaking some license agreement :)) It's not the ONLY thing. You need to change your agreement with Microsoft. What type of license did you buy from them? -SQLBill
2003-08-22
1 reads
quote: Couple of days back we had a situation that the jobs were hung with a status "performing completion actions". We had an emergency reboot of the server, then everything seems working fine for 1.5 days. What kind of jobs? Are they created by maintenance plans?
2003-08-22
2 reads
Definitely adding the choices of "AND" and "OR" will not cause you to many problems. Most users are familiar enough with boolean logic to get by. Adding parenthesis to allow nesting and grouping is something altogether different. Most users can't handle it (heck, even programmers get confused by this sometimes). The answer is to make […]
2003-08-21
It is what you need. http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
2003-08-21
Havent run into that before. Good that you've isolated to MMC. You might try something like Dependency Walker to find all the dependencies, see if any that are write protected? Or just rename all of them (if not system dlls) then try installing. Depending on your time frame, might be worth a support call, or […]
2003-08-19
2 reads
Brian, I have seen this also in my nephew's league to the point where parents get ejected and find it disturbing. What kind of sportsmanship are they teaching their kids? And you'd almost have to be crazy to be a coach these days...it's not a job I'd want. I wonder if this is purely an […]
2003-08-19
Another reason this can happen is if you're running transactional replication and the log reader isn't running. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-16
1 reads
Dan: Thanks for the tip. Using dbcc opentran, there was one stray open transaction. It makes sense now! Billy
2003-08-14
1 reads
I think I will use C for this time. I just hate mixing up development languages. The app. will run each morning in the login script each file has between 20 and 500 rows and there are 3.000-4.000 files each morning. The goal is to insert as quick as possible to insure the concurrency
2003-08-14
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers